I am not an Oracle person - just an application developer - but my DBA is
seriously overworked and I am hoping someone can give me some clues to a
performance problem I am having. I have a select that joins together 4
tables that each contain about 150000 - 300000 records. The select only
returns about 55 records, however. The problem is that when I run the select
anywhere (my app, SQP-Plus, ODBC Test) I get almost instantanious response at
first but then after it has gottn most of the data, it chokes for over a
minute before it gets the last few records. The problem is that I am trying
to create a disconnected recordset in a VB component running in MTS. With a
disconnected recordset, it gets all the data at once so my performance is
horrible. Can anyone point me in the right direction?
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed May 05 1999 - 09:01:33 CDT
