> > > Yes, only the query is being looped in this 10,000 loop.
> > > We are not starting & committing the transaction explicitly,
> since
> > > it is only a select query.
> > > To measure the I/O activity we are checking the I/O read/ write
> > > values against the firebird service (fbservice.exe) in task
> manager
> > > while the query is in execution.
> > >
> > > Bipasha
> >
> > so:
> > 1 transaction (even though before you said each query had its own
> > transaction)
> > 10,000 select statements which are not prepared once and
> parametised, but
> > prepared 10,000 times as well, yes?
> > Does the select query have a limiting where clause?
> > or an order by clause on an unindexed field?
> >
> > (BTW use GFIX to set FW on a database)
> > Alan
> >
>
>
> We are not using any prepared statements.
> There is a where clause. The query woud be something like this:
> SELECT col1, col2, col3 etc. from table1 t1 where t1.col4 = (SELECT
> col1', col2', col3' from table2 t2 where t2.col4' = xyz and t2.col5'
> = abc)
> But there is no order by or group by clause.
>
> bipasha

I don't think this query would work.
How does this part work?

> where t1.col4 = (SELECT
> col1', col2', col3' from table2 t2 where t2.col4' = xyz and t2.col5'
> = abc)

Alan