Jump to content

DBGrid with big DataSet


skafy

Recommended Posts

First I don't see the use of browsing 100k+ records in a DBGrid. I don't think the result is relevant for anything.

Why don't you try some quey that returns a relevant result set, like 100+ records that mean something.

Some other solution would be a query like "select first 100 skip <n*100>  from ........ order by id" , save the position

in some varible and with some buttons go forward or backward as needed recalculating the "n".

  • Upvote 1
Link to comment
Share on other sites

  • 3 weeks later...

If I would then fetch 100 - 1000 records, then I should I implement logics for next page and last page. But how would I then filter and sort records. Now I use FDQuery.Filter and FDQuery.Indexes for sort.

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
×
×
  • Create New...