This topic is locked

Retrieval of Oracle records is very slow

12/19/2006 11:21:13 AM
ASPRunnerPro General questions
B
bdegnan author

I am pulling records from an Oracle 8 database. There are 12,000 records in the database. When first starting the ASPRunner application, it seems like the application is trying to pull all 12,000 records. It is very slow (5-10 minutes) to get to the first page or may timeout. When I narrow the selection using advanced search, the response is fairly fast. There are about 30 fields in the table, some with a fair amount of text. I am only pulling a few, smaller fields on the list page. However, it is still slow.
Is there a way to get it to only select enough records to fill a page? Or is there something else that I am missing here?
Thanks!

Sergey Kornilov admin 12/19/2006

Some Oracle ODBC drivers work this way.
I recommend you to use "No records on the first page" option.

B
bdegnan author 12/19/2006

Some Oracle ODBC drivers work this way.

I recommend you to use "No records on the first page" option.


Thank you! I was not aware of this option. Sounds like just what I need.