Foundset size

Questions, answers, tips and ideas on Servoy Client

Foundset size

Postby joshuahysong » Mon Oct 03, 2011 9:58 pm

Quick question. Is it possible to increase the default number of rows that a foundset will load? We would like to load more than 200 rows when launching the form.

If so, how is this done and are there any consequences other than performance hits for doing so?

Thanks!
joshuahysong
 
Posts: 18
Joined: Thu Jul 21, 2011 7:04 pm

Re: Foundset size

Postby Harjo » Mon Oct 03, 2011 10:02 pm

Hi Joshua, you can load more than 200 records, by jumping yourself to recordIndex 199 or 200. or by loading the foundset, by a dataset with pk's
that will also drastically decrease performance.

But I'm curious, what is the reason why you wanna do that? can a client look at more than 200 records in a time, at once?
Harjo Kompagnie
ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
Harjo
 
Posts: 4321
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Re: Foundset size

Postby joshuahysong » Mon Oct 03, 2011 10:07 pm

Currently we are just curious how bad the performance drop will be versus the convenience of the user being able to scroll down a table view and not have to rescroll again once the next block of the foundset is loading.

I was hoping that there was a server option or setting hidden somewhere that would let you change the default # of rows without have to change the selected index to force it within the client.
joshuahysong
 
Posts: 18
Joined: Thu Jul 21, 2011 7:04 pm

Re: Foundset size

Postby Harjo » Mon Oct 03, 2011 10:42 pm

no there is no setting for that right now.

but you can try and see it by doing a query, and retrieve a pk dataset of about 10.000 records.
load that dataset into a foundset: foundset.loadRecords([vPK])

than you will see the performance degree
Harjo Kompagnie
ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
Harjo
 
Posts: 4321
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Re: Foundset size

Postby joshuahysong » Mon Oct 03, 2011 10:44 pm

We'll try that. Thanks!
joshuahysong
 
Posts: 18
Joined: Thu Jul 21, 2011 7:04 pm

Re: Foundset size

Postby rsieb » Tue Oct 04, 2011 1:15 am

Hi

Or you can use the table bean plugin and load it with a dataset rather than a foundset. This is much faster than using foundsets but you have to polish up on your sql.

Loads as many records as you want and you can scroll from one end of the list to the other in a split second. I have a table with 13K records that loads almost instantly, the users can scroll from one end of the table to the other without issue very rapidly.

Only works in smart client though.
Regards,
Rod Siebenhausen
Director - logic@work
rsieb
 
Posts: 6
Joined: Mon Aug 01, 2011 1:41 pm

Re: Foundset size

Postby jcompagner » Fri Oct 14, 2011 4:59 pm

Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8828
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Foundset size

Postby joshuahysong » Fri Oct 14, 2011 5:50 pm

Wow

I did not see that line entry in 5.2.8 so I added the line "servoy.foundset.pkChunkSize=2000" from your link to the properties file and it is fantastic!

Exactly what I was wanting and barely a noticeable performance hit.

Thanks!
joshuahysong
 
Posts: 18
Joined: Thu Jul 21, 2011 7:04 pm

Re: Foundset size

Postby rgansevles » Fri Oct 14, 2011 9:02 pm

joshuahysong,

Note that your memory usage may increase, this is a server-wide setting affecting all foundsets.

Rob
Rob Gansevles
Servoy
User avatar
rgansevles
 
Posts: 1927
Joined: Wed Nov 15, 2006 6:17 pm
Location: Amersfoort, NL

Re: Foundset size

Postby Harjo » Sat Oct 15, 2011 9:25 am

Wauw, totally missed this...... :shock:
Harjo Kompagnie
ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
Harjo
 
Posts: 4321
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands


Return to Servoy Client

Who is online

Users browsing this forum: No registered users and 9 guests