Terrible performance writing to Oracle via MSDAORA

[slicendice]

Hi

I have a VB6 app that updates rows in an Oracle database. The app is using the MSDAORA driver and there are usually around about 200 updates required each time it is run (which will be every few hours).

The problem I'm having is that the updates are taking an absolute age to complete - I'm talking in the order of over an hour to do about 200 row updates, which is ludicrous!! The table it's updating is not being heavily used and I'm told that the field being used to search on to perform the update is indexed.

Does anyone have any idea why the performence might so dreadful??

Thanks very much

 

[CraigBest]

I do a lot of DB work with Oracle using the same interface. It always works quickly, or it doesn't work at all.

Have you tried different connection and cursor types? I use a client-side cursor and that works really well for me.

 

[slicendice]

OK, thanks Craig - I'll give it a go and let you know how I get on!

 

[johnwm]

Do a check on your connection string by comparing with:

http://www.able-consulting.com/ADO_Conn.htm

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'