Asp.Net cache question.

[J.W.]

Hi, all,

I understand that sql 2005 has better cache (push instead of poll) than sql
2000. However, it also impose the limitation on the query you can cache,
such as, you have to use "SELECT dbo.Customer" instead of "SELECT Customer".
I don't have time to go through all the tables right now, and I want to know
whether it's OK that I still use the old poll way to do cache (sql 2000 way)
in sql2005 environment.

Thanks,
J.W.

 

[Hans Kesting]

J.W. used his keyboard to write :

Hi, all,

I understand that sql 2005 has better cache (push instead of poll) than sql
2000. However, it also impose the limitation on the query you can cache, such
as, you have to use "SELECT dbo.Customer" instead of "SELECT Customer". I
don't have time to go through all the tables right now, and I want to know
whether it's OK that I still use the old poll way to do cache (sql 2000 way)
in sql2005 environment.

Thanks,
J.W.

As this is a sqlserver-specific question that has nothing to do with
asp.net, maybe you will get a better response in a sqlserver newsgroup.

Hans Kesting