Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

BDE-Oracle speed, rowset size?

Status
Not open for further replies.

abbath8

Programmer
Sep 20, 2003
40
HU
I have an Oracle database and I connect to it via BDE. There is a complex query and I wanted to speed it up. I modified the default rowset size (20) to a higher value and I noticed a little improvement. But over 175 I have an error message "Insufficient memory". Now the query is not quick enough and I have to do something else. Please somebody tell me why is that limit in the rowset size option. And tell me plz some hints, how to speed up a BDE-Oracle connection/query...

Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top