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.
Thanks.