Re: Oracle 7.3.2 with dbtools2.1.1

MouMei Fu wrote:
>
> Hi,
>
> Does anyone have experience with Oracle 7.3.2 with dbtools2.1.1? We have
> lots of performance problems but not quite sure if it's Oracle or Rogue Wave
> to slow process down. I'll appreciate if someone can enlighten me on this.
>

Mei,

We are using DBTools 2.1.1 with Oracle and havn't had any serious performance
problems that we couldn't track down. We've had other problems, but performance
is not really one of them.

We have noticed that certain RW operations are slow. For example, the RWDBDatabase::executeSql() function seems to be slower than if you use the overloaded operators with RWDBSelector, RWDBReader, etc. Don't know why this is.

Also, a _major_ thing we noticed was that some functions take an RWDBConnection object, but are overloaded so that you don't have to provide one. If you don't provide one, it will make one for you (this does an Oracle connect). Since connects seem to be pretty slow (especially for SQL*Net 2.x), this could be your problem. This isn't really covered in the documentation (that I could find).

By the way, what compiler are you using? We are using Borland 4.53 and/or
5.01 and have had serious problems when the application exits.

Hope this helps.

-Allen

-- 
Allen Hadden
Systems Engineer/Laboratory Application Specialist
Taratec Development Corporation
ahadden_at_taratec.com