Subject | Facing Problems in executing the Select query |
---|---|
Author | sarvani.cherukumilli@wipro.com |
Post date | 2007-09-03T18:22:40Z |
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
[Non-text portions of this message have been removed]
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
[Non-text portions of this message have been removed]