Subject | Re: Select + Update in a single SPROC? |
---|---|
Author | hartertobak |
Post date | 2007-11-23T14:32:42Z |
Hi Helen,
really want to COUNT the number of hits on the searchitem????
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.
> Well, reading this and your other posts, I observe that confusionreigns supreme. You have introduced an "idcount" - so - did you
really want to COUNT the number of hits on the searchitem????
>overwhelmed with correcto solutions.
> If so, you're a bit lost...so answer that question and you will be
>hehe, I´m not lost :)
> ./heLen
>
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.