Hello:

I thought I read a post a while back that indicated that a sensitive query actually was
faster than an insensitive one.  Unfortunately, I can't find the post again to confirm this.

Anyone else have any thoughts on this?

Dale

Dale,

<< I thought I read a post a while back that indicated that a sensitive
query actually was faster than an insensitive one.  Unfortunately, I can't
find the post again to confirm this. >>

In most cases, yes, a sensitive query is much faster than an insensitive
query.  The only time this may not hold true is when selecting just a few
rows out of hundreds of thousands, or millions, of rows.  In such a case it
may be faster to generate an insensitive result set instead.  However, this
is something that I hope to address at some point.

--
Tim Young
Elevate Software
www.elevatesoft.com

<<However, this is something that I hope to address at some point.>>

That would be great.  Many of my queries involve joins and sorting which render them
insensitive.  These queries operate on the main portion of my database, so good
performance of insensitive queries would be a definite plus for me.

Dale

Dale


Unfortunately for you I think Tim was talking about the sensitive result set being slower in some cases not making insensitive result sets faster. I'm pretty sure he'll work on making insensitive result sets faster as well though.

Roy Lambert

Dale,

<< That would be great.  Many of my queries involve joins and sorting which
render them insensitive.  These queries operate on the main portion of my
database, so good performance of insensitive queries would be a definite
plus for me. >>

Roy is correct, I was referring to the performance of sensitive result sets.
My apologies for the confusion.  However, as Roy indicated also, I am
constantly working on improving the performance of insensitive result sets
also.  You can see an I/O summary in the execution plans for insensitive
result sets now that indicates how much I/O EDB had to use in dealing with
the result set.  It is helpful in determining if a particular query is using
a lot of I/O just to build the result set, and if you see such a creature,
let me know and I'll take a look and see what I can improve on.

--
Tim Young
Elevate Software
www.elevatesoft.com