One way to increase performance

Classic Servoy
1

I have a solution with many columns/fields in a row. I often need to use a method to either clear or assign values to 50 or more columns/fields. Until recently this was painfully slow. However, recently I noticed that when I clear the fields by assigning them the null value instead of the ‘’ value it markedly increases the rate at which the fields are cleared. I also noted that if I need to assign values to the columns/fields it is much faster to assign a value to a field that formerly was assigned null than a field that was formerly assigned ‘’. In my solution this makes a huge difference speeding things up about an order of magnitude. I now go out of my way to use null instead of ‘’ whenever possible.

John McCann

Servoy Client
Version R2 2.0-build 273
Java version 1.4.2_04-b05 (Windows XP)

2

Have you ever tried the getFoundSetUpdater?
This is much quicker!!!

Here is an example, which you can find in the method-editor too:

//1) update entire foundset
var fsUpdater = databaseManager.getFoundSetUpdater(foundset)
fsUpdater.setColumn('field1',null)
fsUpdater.setColumn('field2',"hello")
fsUpdater.performUpdate()

Hope this helps

3

I tried this and your method is much faster. I notedwhat might be a bug in the foundsetupdater and reported it.

Thanks for sharing your idea

John McCann