Subject RE: [firebird-support] Facing Problems in executing the Select query
Author Alan McDonald
> Hi All,
>
> We are using Firebird 1.5.3 for our application. We are
> using a SELECT query which fetches data from four different tables. If
> this query is executed for about 10,000 times, we observed that the
> number of IO write operations on the Firebird service is much larger
> than the number of IO read operations. Does the number of executions
> of a query affect the number of IO read/ write operations?
>
>
>
> Thanks,
> Sarvani

everything is happening within the context of a transaction.
The transaction IDs have to written
Alan