databaseManager.addTableFilterParam Performance Penalty?

Classic Servoy
1

Hi,

We’re using databaseManager.addTableFilterParam to filter a single record from ~40 of a 60 table database (we’ve found it’s a powerful and handy feature), but are concerned re: any performance penalty there might be using it for the Client?

Can anyone describe how databaseManager.addTableFilterParam is implemented “under the hood” so to speak? Are extra queries performed/required, etc.?

Thanks.

JDW

2

No extra queries are performed. The filters are simply added to the base statement that is sent to the database. In general with filters your app should be even faster than without!

3

Well, that certainly sounds good. Thanks for the feature and the reply. Cheers. JDW.