Subject | How to retrive information without increasing transaction count |
---|---|
Author | GOVINDKRISHNA |
Post date | 2003-07-11T04:05:23Z |
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
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