--- In [email protected], bongp <[EMAIL PROTECTED]> wrote: > > Hi To all, > > I'm using mysql 4.0 and delphi 6. I have a program with a grid showing > data content of my table. Since my table can contain a ten of thousands > of records how i can fetch them and show on my grid in such a way that > the first 1000 records will be fetch first, and when the user scroll on > this records and comes to the last (1000th record) it will again fetch > the next 1001 to 2000 records and so on. And how about scrolling up, > it's a bit tricky on my part how my program would handle this, taking > into consideration that the user can scroll up and down the records. I > know it's not practical to load them since it will eat up all the > resources and it will greatly slows down the system. > > Your advise is much appreciated. Thanks and advance. > > bong >
Surely you are not serious. Giving your users 10s of thousands of rows is giving them a haystack so they can find the needle. Find what the user wants, filter to just that and return 10 rows - that's what client server databases are all about. Mick ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Groups gets a make over. See the new email design. http://us.click.yahoo.com/XISQkA/lOaOAA/yQLSAA/i7folB/TM --------------------------------------------------------------------~-> ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
