Paging query with ADODC and DataGrid

Hello, i´m creating a program where i make a query to a MySQL DataBase through a network.I´m using an ADODC control and a DataGrid. The problem is that it has 50000 registers and an amount of 50MB, and dates appear on the screen after 5 seconds which is too slow for the requirements that i need.
I care that the solution is make a paging query but i don´t know how do it.
Can anyone tell me how do it?
Thanks
martin11_arAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
dancebertConnect With a Mentor Commented:
Your are trying to solve a problem that wouldn't exist with good interface design.  A widely accepted rule of thumb is that most users can't handle more than 200 items in a grid or combo box.  The usual scenario is to create a search form where users select fields, relations and values (e.g. Sales Region = 9) then just return the data they asked for.  Not only will you get much faster reponse, the total load on the network, database and database server will be dramatically reduced.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.