After quite a few tests, unless I am wrong, the way servoy generates it sql commands slows down a lot of operations when working on big foundsets.
The only reason for this is probably the mechanism which is used to be able to rollback records changes.
To overcome this, I am now making all big inserts and updates using the raw sql plugin to make direct changes in the db. and the speed difference is enormous.
example: modifying 2 field on 100k lines takes ages with the controller, minutes with the foundset even using transactions and a few sesonds using direct sql update.
I know this may create problems if other users would use the db at the same time, but in my case, this is done in a temp table and it is then pushed to a "shared" table.
so the feature request would be: could we have a mode which make direct changes but still using the servoy language instead of having to embed sql queries, a kind of flag which would bypass all the rollback mechanism, even if tihs means to put all users in hold mode in the given table?