Performance testing

Questions, answers, tips and ideas on Servoy Client

Performance testing

Postby kschuster » Wed Jul 02, 2008 5:50 pm

I thinking about embarking on a significant development project. I'm trying to determine if Servoy is the right choice. My database of choice is MySQL. I would expect serveral million records being stored and queried.

Servoy would need to be able to display up to say 250,000 records in a grid. I'm sure there are a number of ways to go about this. Maybe caching the data locally and pulling into the grid as its scrolled thru.. Don't know yet.

I was wondering if anyone has developed a solution or done any performance testing with Servoy with this kind volume of data needing to be viewed

Thanks
kschuster
 
Posts: 53
Joined: Fri Mar 28, 2008 4:42 am
Location: Houston, TX

Postby agiletortoise » Wed Jul 02, 2008 7:49 pm

Servoy, by default, pages large datasets. When loading a foundset, it loads 200 records at a time, and then automatically loads the next 200, etc., as the user pages through the data.

There are ways to create in memory versions of the data as well, but loading 250,000 records into memory is likely never to be a good idea.

greg.
Greg Pierce
Agile Tortoise
SAN Developer
http://www.agiletortoise.com
User avatar
agiletortoise
 
Posts: 278
Joined: Wed Oct 12, 2005 3:26 pm
Location: Texas, USA


Return to Servoy Client

Who is online

Users browsing this forum: No registered users and 7 guests