I have a question about why Firebird writes / or changes so much data in the database file when you run a simple select query.
What data is it changing in the database?
Can this behaviour be modified /turned off via configuration?
When I run the select statement in IB Expert it tells me nothing has been written to disk
When I look at the firebird process I can see it writing data for every select query I run

Unfortunately our application runs a select query every 3 seconds to update a reservation chart.

On our production server when I look at how many bytes of data has been written over long period it has written gigabytes of data even though the databases are only megabytes in size.

I am working on Windows 2003 Server Firebird version 2.1 (Classic and Super Server)

We use a replication tool that works at block level and it is picking up huge amounts of data changes on the firebird database files.

Look forward to hearing your comments.