I have a Servoy solution that gets some data from FileMaker 11 Server, by running SQL queries
I would now like to show the FileMaker Table in a Form. It does work, but is a bit slow
it seems that Servoy gets all the PK's, then loads all the fields. Since there are over 1 million records, this takes awhile ( not sure if this is limited to 200 records )
I did set the "onShow" property to start with an empty Found Set, but it did not help:
var fs = databaseManager.getFoundSet('filemaker','media');
forms.media_filemaker.controller.showRecords(fs);
and if I do a "Find" that fails, Servoy tries to load all records again !
1. is there any way to stop Servoy from asking for all the PK's ?
2. can I prevent a failed "Find" from loading all records ?
3. The form shows 5 columns, yet the Performance Log shows the query asks for ALL columns ? any way to control this ? ( this is a wide table )
greg