Member Avatar for PinoyDev

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!

  • 2 Contributors
  • 1 Reply
  • 67 Views
  • 4 Hours Discussion Span
  • Latest Post Latest Post by AndreRet
Member Avatar for AndreRet

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
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.