Subject Re: Select + Update in a single SPROC?
Author hartertobak
Hi Helen,

> Well, reading this and your other posts, I observe that confusion
reigns supreme. You have introduced an "idcount" - so - did you
really want to COUNT the number of hits on the searchitem????
>
> If so, you're a bit lost...so answer that question and you will be
overwhelmed with correcto solutions.
>
> ./heLen
>

hehe, I´m not lost :)

You think just writing the requests in a table and do a "select count"
would be faster? If so, what´s the limitation? Will it get slower and
slower when the table grows up to 5 million records and above?

Yes, I want to log the hits on a searchitem.