Good day!

I have this query that produces 5000 list of items in 10 columns in list view. I found that it slowly load the items at about 30 seconds. Im planning to divide the result @ 1000 per list. Moving the list per 1000 by using adodc control. How to implement this way?

Thank you!

By using the "LIMIT" function in Sql...

SELECT * FROM  YourTableName LIMIT 0 , 30

The 0 is where it will start from to how many records to show. If you want to move to the next 30 records, it will look like...

SELECT * FROM  YourTableName LIMIT 30 , 60