| Stefan [MSFT] 2005-02-28, 5:53 pm |
| Hi,
do you mean you had 1700 postings in one single channel?
That might be the reason!
Never store more than 200-300 items in a single channel.
See here:
http://download.microsoft.com/downl...6a/MCMS+2002+-+(complete)+FAQ.htm#4009EC9B-3902-4625-93EB-B6F5777BDDF2
Cheers,
Stefan.
--
This posting is provided "AS IS" with no warranties, and confers no rights
Book: Building Websites Using MCMS: http://tinyurl.com/56jt8
----------------------
<bep@10.10.10.10> wrote in message
news:D404549D-361B-4809-80A3-B06A20337AB4@microsoft.com...
> Just noting more observed behaviour to this thread for completeness. And I
> will eventually post the solution.
>
> I deleted all of the 1700 odd postings from the channel that I am
displaying
> (channel rendering), and the SQL queries are down to about 10 odd.
>
> It appears that it IS asking one posting at a time if the user has access
to
> it. For all I know, this is normal MCMS behaviour. Not a good way to do
it,
> but maybe it does...
>
> Also, when loading the page over and over again, I notice that a random
page
> load will be very quick, and not do the 2000 odd SQL queries. It is very
> random though, no pattern. It could be something to do with MCMS caching,
but
> I have no caching set on for this page. And it does result in a couple of
SQL[vbcol=seagreen]
> queries, so it is not client side cacheing, or proxies.
>
> David
>
> "Stefan [MSFT]" wrote:
>
questions.[vbcol=seagreen]
rights[vbcol=seagreen]
I[vbcol=seagreen]
and[vbcol=seagreen]
queries[vbcol=seagreen]
first[vbcol=seagreen]
just[vbcol=seagreen]
time,[vbcol=seagreen]
page[vbcol=seagreen]
the[vbcol=seagreen]
Two[vbcol=seagreen]
if I[vbcol=seagreen]
each[vbcol=seagreen]
would[vbcol=seagreen]
Even[vbcol=seagreen]
this[vbcol=seagreen]
the[vbcol=seagreen]
it?[vbcol=seagreen]
could[vbcol=seagreen]
no[vbcol=seagreen]
it[vbcol=seagreen]
a[vbcol=seagreen]
between[vbcol=seagreen]
ASPX[vbcol=seagreen]
causes[vbcol=seagreen]
|