Goto last record in huge foundset (> 100000 records)

Classic Servoy
1

I have a situation where a table has > 100.000 records.
Servoy loads these records with blocks of 200 (where is the setting where you can increment this value?)
So the first 200 records are shown initially.

I have a button on my form ‘Go to Last record’
When pressing this button Servoy goes to record 200 and the next block of 200 records are loaded.

I don’t want record 201-400 loaded, but records 99.800-100.000
You can solve this by scripting by setting the controller.selectedIndex() to size of the locally retrieved foundset size.
This will work, but it loads all 100.000 records into the client and you see refresh of the screen when each block of 200 records is loaded.

That is not necessary, because I just want records 99.800-100.000

I could reverse the sortorder, but in that case record 100.000 is on top of the form in stead of the bottom of the form (I’m using tableview)

Is there a way that I can tell Servoy to load records 99.800-100.000 and of course when record 99.800 is selected, then records 99.600 - 99.799 should be retrieved from server.

2

Hi Martin,

You can’t search for these last 200 records ?

3

or if you order asc sort it desc (or the other way around)

going to the last record in such a foundset is not really a good idea.

4

ROCLASI:
Hi Martin,

You can’t search for these last 200 records ?

No because I want to scroll backwards also

5

jcompagner:
or if you order asc sort it desc (or the other way around)

That makes the last record shown as first record and it should be shown as last record

6

martinh:

jcompagner:
or if you order asc sort it desc (or the other way around)

That makes the last record shown as first record and it should be shown as last record

why?

If you tell the users in the UI that this list is now reversed then why isnt that clear enough?

Going to the last record on a >100.000 foundset is really not a good idea because we have to load in all pk’s of that foundset to get to the latest one.