I have a big table, 40k lines.
why can’t I get more than 200 records at once?
I have to scroll and scroll, or ask for the getMaxRecordIndex() several times to go ahead…
(I am not using the default navigator)
A returning discussing, many times answered when you search the forum.
BTW you can also do a foundsetcount…
yes, I found it, though the answer does not please me really.
transfering too many records is not servoy’s problem. I could at least understand that the default value is 200, but they should let the programmer set it the way he wants.
so I’ll use the sql way and use limits…
even filemaker does that, from a sql database through an odbc driver and it is an acceptable speed. even using php, I can pull 2000 lines from mysql in a acceptable time, so this limit to 200 seems quite old fashioned.
The same discussion popped up not long ago somewhere else.
I am pretty sure Servoy is aware (open door, how can they not) and will do something about it soon.
Having that said, 4.0 is around the door so I think all resources/time go that direction.
I tried the sql method getDataSetByQuery, a misery, slow and it does a dataset, but I don’t know how to display it… probably needs a loop to assign its data to row/column? too much work.
instead i did that:
while ( databaseManager.getFoundSetCount(foundset) > controller.getMaxRecordIndex() )
{
controller.loadAllRecords();
controller.setSelectedIndex(controller.getMaxRecordIndex());
}
magic, 4s to get 40000 lines. I make a global method with this!