Subject Re: Facing Problems in executing the Select query
Author rambabu_piridi
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...>
wrote:
>
> > 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
>
Thanks for your post. But could you please elaborate a little more?
We are not very clear about this...
bipasha