+1 on the design lk
On Friday, February 24, 2017 at 10:22:32 AM UTC-5, Oskar Berggren wrote: > > 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] > <javascript:>>: > >> 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] >> <javascript:>> 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] >>> <javascript:>>: >>> >>>> 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] >>>> <javascript:>> 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] <javascript:>. >>>>> To post to this group, send email to [email protected] >>>>> <javascript:>. >>>>> 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] <javascript:> >>>> >>>> -- >>>> 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] <javascript:>. >>>> To post to this group, send email to [email protected] >>>> <javascript:>. >>>> 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] <javascript:>. >>> To post to this group, send email to [email protected] >>> <javascript:>. >>> 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] <javascript:> >> >> -- >> 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] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> 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.
