SQL write buffering

[haxor]

It looks like every time a client returns a value, there is a single write to the sql database. Am I correct on this?

If I am, would it be possible to set up some kind of user configurable buffering of incoming data? You could buffer by time or by number of data items. Then you could do one large write to the sql database and help performance considerably.

[Alexei]

This can be done, but it will require rewrite of certain functions. For example, trigger expressions (think of functions max, min, etc) rely heavily on data stored in the database. The cache layer will not be trivial.