From: "Bud" <[EMAIL PROTECTED]>
Subject: Re: [Cached Queries]
> On 11/10/00, Alex penned:
> >i think they are cached according to the queryname. so if you name the query
> >with a sessionid you could have them cached per user.
> >and YES they will make the page faster for the end user.
> >i cache all static querys.
>
> They are cached by name, search parameters, and also by the query
> structure itself.
>
> So
>
> SELECT product_name
> FROM products
>
> and
>
> SELECT product_name FROM products
>
> would be read as 2 separate queries because the structure is
> different, even if they are named the same.
>
That's not true.
The two selects you wrote will not prevent cachedwithin usage.
There has to be a difference in sql that would produce different
rows and/or columns.
Pan
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
