Performance problems with ODBC (VB4 16-bit) -- HELP! 
Author Message
 Performance problems with ODBC (VB4 16-bit) -- HELP!


        I'm working on a moderate sized application that needs to be able to
read, update, and delete 12 tables (6 of which are one-to-many
relationship tables).  
        Initially I used dbSQLPassThough queries to load the data and it was
reasonably fast (took like 5 seconds to load).  Well, using the
passthorugh query made all of my recorsets (using Oracle 7.3) non-
updatable.  So I changed the program to attach to all the tables first
and pull the data using (recordset.findfirst STRING) and findnext.  This
was the only way I could find in my VB books and the Microsoft Examples
to code it.  The problem is that this is VERY VERY slow.  IT now takes
about 30 seconds to load the form and this is considered unacceptable.  
        Can anyone help we out with a way that I can access the data in my
Oracle tables (for insert, update, and delete) and maintain a
respectable level of system performance.  This wasn't a problem in the
past because this program only had two tables (which weren't one to
many) to work with.

any help would be greatly appreciated.



Sat, 13 May 2000 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. HELP: VB4-16 bit to VB5-32 bit problem

2. problem:vb4 16-bit, sql server 6.0 via odbc, data control

3. ole server performance (vb4 16 bit)

4. Migrating 16-bit ODBC DLL (SQLServer) to 32-bit ODBC DLL (MS Access)

5. Calling 16 bit DLL from VB4 16 bit in Win 95

6. Help: Problems with DBGrid in 16-bit VB4

7. Russian(Cyrillic): vb4 32-bit works, but vb4 16-bit doesn't

8. Please help: Problems with VB4.0/16 bit app on WinNT4.0

9. Anybody have info on connecting VB4 to Oracle via 16-bit ODBC

10. ODBC through VB4 16-bit (dbDriverNoPrompt)

11. ODBC problem with VB 4.0 16 bit

12. ODBC/Oracle 16 Bit Passthrough Problems


Powered by phpBB® Forum Software