Subject How to retrive information without increasing transaction count
Author GOVINDKRISHNA
Hello,

Using IBO. I had some performance problems. From lurking on this list realised it probably because of OAT. Solved the problem. OAT and next transaction are sort of advancing hand in hand

Now the transactions are moving ahead in my database pretty quickly and i realised because I am READING some information from the database regularly.

What is the easiest way to execute something like select count(*) from table without "consuming a transaction".

This should return the latest committed information to the database.

Thanks
GK