get first 50 rows from simplae query

get first 50 rows from simplae query

  
I have one page which is taking less time to load now i make a ajax call in side that method i am bringing the 500 records and on each record i am doing some manipulation and then sorting it and making a list now i want to bind that list with the table and doing the ajax refresh which is taking near by 10 seconds 

so my query is how to reduce that time?
JD, 

Can you post the code so we can take a look?

Cheers
Hi JD,

Did you try the max records property of the simple query?
It will limit the number of records fetched from the database, but if you depend on some kind of sorting after the query is done (that affects wich are the first 50) it probably won't do what you want.

Regards,
João Rosado
Mark Bayles wrote:
JD, 

Can you post the code so we can take a look?

Cheers
 
 Well i got to know the mistake. :)
and have resolve the issue i was facing.
Actually in single row i was keeping near by 5 to 8 Popup Editor which was taking time or else the records were coming within a fraction of seconds.

 Well i got to know the mistake. :)
and have resolve the issue i was facing.
Actually in single row i was keeping near by 5 to 8 Popup Editor which was taking time or else the records were coming within a fraction of seconds.
Thanks for your HELP :)
No problems JD :)