At 13:56 21.02.2003 +1000, you wrote:

>Svein Erling Tysvaer wrote:
> > At 18:05 20.02.2003 +1100, you wrote:
> >
> > Transactions: Committing transactions take time, so when you handle a
> batch
> > of records, you may gain speed by having quite a few of them within the
> > same transaction (e.g. commit every 10000 insert/update/delete).
>
>This is reading only. Does the use of transaction affect reading?

Well, at least nothing that has anything to do with your current problem.

>Yep, as we get our tests done I'll try to get more specific questions. I have
>already posted the sql and the indexes. How do I post a plan?

E.g. grab IB_SQL (freeware from www.ibobjects.com) Insert your query into
the Cursor tab, prepare it and copy the resulting plan.

Set