Hi, Not sure why the talk about "trillions". Sure, that would be a problem too but it there is an int, the limit would be already at a bit more than 2 billion records, of course.
I don't see a problem with raising that to a 64-bit integer. Perhaps it should even be unsigned or is there a purpose with negative numbers here? Then again, paging by offset have several problems too. For example, it will cause duplicates or omissions if rows are added/removed in pages before the current page while paging. This can sometimes be alleviated by skipping records with a greater-than condition on id (or other column used for ordering). I doubt that a GUI for paging through billions or even millions of records would be useful. Let's say you have 10000 records per page (which is huge). With 1 billion records you now have 100000 pages. How is that useful to the user? Better work on build an amazing search interface instead so the user can actually find what they want. /Oskar 2017-02-24 11:47 GMT+00:00 Felipe Oriani <[email protected]>: > Ok, let me explain a scenario. > > We have some entities that have millions of records. The customer would > like to check a status of the entire system by charts. So, i have to count > records (by a distinct column) and provide these charts. On the other hand, > the customer want to see these records in a grid. I know I can provide > filters and limit the results on the grid by 1000 records por sample. Is it > a good pratice? Is there any common sense about tables where user need to > see the records and the tables in question has millions (or trillions) os > records? > > Obs: It is a web application. > > thank you guys! > > > > > > > On Thu, Feb 23, 2017 at 6:47 PM, Gunnar Liljas <[email protected]> > wrote: > >> What is the desired result? Paging through millions (trillions!) of >> records doesn't make much sense. >> >> /G >> >> 2017-02-23 22:01 GMT+01:00 Felipe Oriani <[email protected]>: >> >>> What is the best approach to solve a page like this (millions and >>> millions records)? >>> >>> On Thu, Feb 23, 2017 at 2:20 PM, Ricardo Peres <[email protected]> >>> wrote: >>> >>>> Why would you want to page over 1 trillion records? >>>> >>>> RP >>>> >>>> >>>> On Thursday, February 23, 2017 at 11:35:40 AM UTC, Laurel Jay Fadul >>>> wrote: >>>>> >>>>> When the rows grow up to 1 Trillion (int limit), Nhibernate will >>>>> unable to query those more than int indexes. IQuery.SetFirstResult >>>>> only support int parameter. Hope this will fix in the future. Thanks.. >>>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "nhusers" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to [email protected]. >>>> To post to this group, send email to [email protected]. >>>> Visit this group at https://groups.google.com/group/nhusers. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> >>> >>> -- >>> ______________________________________ >>> Felipe B Oriani >>> [email protected] >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "nhusers" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To post to this group, send email to [email protected]. >>> Visit this group at https://groups.google.com/group/nhusers. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "nhusers" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at https://groups.google.com/group/nhusers. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > ______________________________________ > Felipe B Oriani > [email protected] > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/nhusers. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/d/optout.
