SLOW DATA LOAD

[MarcLara]

I have a VB app that loads data to a listview from an Oracle 7.3.4 database. Whenever I try to load 46K worth of records to the listview it is very slow, running approximately 7-10 minutes. However, a 17K load only takes about 3-4 seconds.
By the way, I cannot do anything to the VB app because I do not have the code (Third party app). However, we have other networks that are running the same VB app and Oracle database and they do not seem to have any problem. Each network has their own Oracle database.
I have tried increasing tablespace, rollback segments, and datafiles with no luck. Is there anything else I can do to increase the performance?

 

[jimbopalmer]

Just a stab in the dark, but it kinda feels like a sort area size thing I tried to remain child-like, all I acheived was childish.

 

[MarcLara]

Jim,
I thought about that too. Like I mentioned earlier, its a third party app and other similar databases, on other networks, are not having the same problem. I have tried adjusting the paging file to see if that helps, no luck. I tried changing the Temp datafile, It returned no data after doing so. So, I had to put the original one back. For some reason, it looks like it doesn't have enough resources in the database itself to process the operation. The computer resources itself (memory, hard drive space) is plenty.
The sort area size that you mentioned, is that something that can be done on the database?
Thanks