Tim

I know the difference about live result set and canned result set very well.

Sometimes when selecting data from table with more than 1M records is faster
to choose canned result instead of live result.

My doubt is: Is there any way to follow as a rule when I have to choose
canned result instead of live ?

Eduardo

Eduardo,

<< My doubt is: Is there any way to follow as a rule when I have to choose
canned result instead of live ? >>

Selecting just a few rows from a very large table will almost always be
faster with a canned result set than a live result set, especially if there
is an ORDER BY clause that uses an available index.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks