> -----Original Message-----
> I can confirm that firebird is allocating the virtual memory.
> I can see that in taskmanager. Firebird memory goes up and
> parallel I can see the pagefile growing up to 1.5GB.
> For sure I have a lot of record-versions, because I'm
> updating the same record very often. But I thought the old
> versions get killed after a select, that's why I tried to do
> a select every 100 updates.

OOI, do any of your selects include an order by? Also, to me, 200 columns
seems a lot, has the database been normalized so as to minimize the impact
of updates, and in turn record versions?

Rgds

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://sourceforge.net/projects/fbutils - FBUtils
http://sourceforge.net/projects/dnfbb - Web based, Firebird Powered Forum