That was an excelent question! Any answer from Bruno? Thanks António
2011/1/18 Johann Spies <johann.sp...@gmail.com> > I started this thread: > > > On 17 December 2010 12:11, Johann Spies <johann.sp...@gmail.com> wrote: > >> >> * I have tested it this morning on a table with more just over 8200 >> entries and it took 70-90 seconds on Firefox and 30-35 secondes no Chrome >> to reload the page from localhost. That is not usable. Plugin_wiki's >> jqgrid does this in less than a second. >> It seems that it loads the whole table and does not make use of paging >> while executing the query. >> >> > After the plugin was updated and I returned from holiday, I did the same > test today: > > Firefox - about 45 seconds > Chrome - about 37 seconds. > > So there is an improvement on Firefox, but not on Chrome. > > But it still too slow to use on larger datasets without some other > pagination help - which is a pity. I have tried to get it to load a table > of 135000 entries but gave up after a long time. > > Unfortunately my knowlege of javascript is almost zero so I do not know > whether it is possible to get the javascript to handle the sql-queries in a > way that does not need to load all the data into memory. > > > Regards > Johann > -- > May grace and peace be yours in abundance through the full knowledge of > God and of Jesus our Lord! His divine power has given us everything we need > for life and godliness through the full knowledge of the one who called us > by his own glory and excellence. > 2 Pet. 1:2b,3a > >