Performance testing

Classic Servoy
1

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

2

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.