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.
