2. ASPRunnerPro General questions
  3. Limit Search Results on List Page
This topic is locked

Limit Search Results on List Page

 		11/3/2008 6:35:03 AM
ASPRunnerPro General questions
P
 paulyap2k author

HI There,
Is there a way to limit search results to 1000 records on each search ?,
I have search the post and understand "limit" is not workable in SQL query page on ASPRunner Pro.
I cannot create view in mysql with "limit" as it will defeat the purpose on my search of 1 million records. I want to be able to return the latest 1000 records which is sorted by date.
Thanks for helping.
Best Regards

Paul
Sergey Kornilov admin 11/3/2008

LIMIT is not workable because ASPRunnerPro adds limit clause for you automatically.
This means even if your table contains millions of records ASPRunnerPro only retrieves as many records as required.
P
 		paulyap2k author 11/5/2008

HI Sergey,
Thanks for the reply. As often the results return are in hundred of thousands with many pages, the load time can take quite a while. Would it be possible to set parameter in ASPrunner Pro so that it takes in only returning say maximum of 50,000 records.
Regards

Paul

LIMIT is not workable because ASPRunnerPro adds limit clause for you automatically.

This means even if your table contains millions of records ASPRunnerPro only retrieves as many records as required.
Sergey Kornilov admin 11/5/2008

You probably misunderstood the following:
This means even if your table contains millions of records ASPRunnerPro only retrieves as many records as required.