| [news.eclipse.platform.swt] Re: Huge table, records, scrolling, etc. |
Joe Smith wrote: > > "Haris Peco" <snpe@xxxxxxxxxx> wrote in message > news:dj142u$onu$1@xxxxxxxxxxxxxxxxxxx >> Joe Smith wrote: >> >> It is simple get number of row in scrollable result and it is quick >> (for good databases) - go to last record and get row number >> with hibernate I do next : > > Generally, fetching hundreds or evevn thousands are ok with most dbmss. > But with huge tables, not that quick! and what when table have 1000000 or more rows - it is real possibility. more important - we don't know how much rows have in table For performance : it is the best when i have 50-100 rows in memory and rest grab from database