Provide a search method. The user puts in some query data, then only pull back records matching that query. For example, bring back customer number 24232. Or bring back all customers in Quezon. Or bring back all customers with lastname of Lim. You'll need to talk to your customers to find out what searches they would need.

>Hi Experts,
>
>I have a data entry form class that has a pageframe control with two pages, one showing a grid, the other showing current record contents of the "active record".
>
>This is just fine if I use DBFs as backend data, since it is mere file sharing. This does not augur well though if the same data entry form class is used since ALL rows from a MySQL server database will be fetched (which may run into 100s of thousands)
>
>My question is - what is the best practice for a Client-server data entry form:
>1. Get first X number of rows?
>2. Show no data at first then have a "new function" to view (in addtion to Edit, New, Delete) with certain filter conditions?
>3. I am leaning towards how Yahoo Mail UI does it - but how would you implement the "coordination" of fetching the right number of rows
> when user resizes the message header pane?
>
>Thanks In Advance
>Dennis