Recommendations for working with large data tables

Classic Servoy
1

Hi,

I’m new to servoy and am looking for some pointers for working with large databases.

I have a Product table with over 500,000 records. What will happen when the user tries to modify some of the records via Servoy? Will Servoy download all 500,000 records to the client?

Is there a way of having a form that can prompt for selection information before entering the Product form so I can retrieve a subset of the data to work with?

Thanks,
Lee.

2

radman:
I’m new to servoy and am looking for some pointers for working with large databases.
I have a Product table with over 500,000 records. What will happen when the user tries to modify some of the records via Servoy?

Hi Radman, welcome to SERVOY!
No problem!, usually if it’s not a problem for the DB engine is not a problem for Servoy, and half million records IS NOT a problem!

radman:
Will Servoy download all 500,000 records to the client?

Servoy usually load blocks of 200 records.

radman:
Is there a way of having a form that can prompt for selection information before entering the Product form so I can retrieve a subset of the data to work with?

Absolutely YES, may I suggest you to watch the flash videos that Servoy developed to help new users get started, can be found here:

http://www.servoy.com/generic.jsp?mt=39 … omy_id=579

there are also a few other additional Servoy resources at the bottom of that page.