|
Home > Archive > Microsoft Content Management Server > September 2006 > Postingcollection size
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Postingcollection size
|
|
| dg2000r 2006-09-12, 1:21 pm |
| Hi Stefan
We have a control that displays the 4 most recent news headlines within a
channel that has been working ok for 2 years now. However, we are now
migrating to another server location and it has become clear that this
control is causing very slow response times. The problem appears to be that
the posting collection that we create brings back all postings in the channel
when we actually only need the most recent few postings.
We currentky use:
PostingCollection ourCollection = ourChannel.Postings;
And then loop through the top 4 postings to output them as required.
Is there a more efficient way of accessing a small number of postings from
within a given channel that we should be using instead of this method?
Thanks
Dave
| |
| Stefan [MSFT] 2006-09-16, 1:34 pm |
| Hi Dave,
how many postings are in this channel?
Are you using a sort method to sort the items in the PostingCollection so
that you only have to access 4 postings and don't have to iterate through
all of them?
Cheers,
Stefan
--
This posting is provided "AS IS" with no warranties, and confers no rights
"dg2000r" <dg2000r@discussions.microsoft.com> wrote in message
news:72BC1B98-F98C-47FB-975C-9C669ED03760@microsoft.com...
> Hi Stefan
>
> We have a control that displays the 4 most recent news headlines within a
> channel that has been working ok for 2 years now. However, we are now
> migrating to another server location and it has become clear that this
> control is causing very slow response times. The problem appears to be
> that
> the posting collection that we create brings back all postings in the
> channel
> when we actually only need the most recent few postings.
>
> We currentky use:
> PostingCollection ourCollection = ourChannel.Postings;
>
> And then loop through the top 4 postings to output them as required.
>
> Is there a more efficient way of accessing a small number of postings from
> within a given channel that we should be using instead of this method?
>
> Thanks
>
> Dave
| |
| dg2000r 2006-09-16, 1:34 pm |
| Hi
There must be something like 400 postings in that channel now. I currently
use a SortByStartDate(false) and then loop through the first 4 items to
display them.
I've tried commenting out various parts of the code and tested access times
and it appears to be that the slow part of the process is creating and
sorting the PostingCollection (rather than the looping & rendering). Is there
any way to create a posting collection that doesn't bring back every item in
a channel?
Thanks
Dave
"Stefan [MSFT]" wrote:
> Hi Dave,
>
> how many postings are in this channel?
> Are you using a sort method to sort the items in the PostingCollection so
> that you only have to access 4 postings and don't have to iterate through
> all of them?
>
> Cheers,
> Stefan
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
>
>
> "dg2000r" <dg2000r@discussions.microsoft.com> wrote in message
> news:72BC1B98-F98C-47FB-975C-9C669ED03760@microsoft.com...
>
>
>
| |
| Stefan [MSFT] 2006-09-16, 1:34 pm |
| Hi Dave,
this is not supported from a performance perspective.
The performance will go done significantly if the number of items in a
contain is beyond 300.
Best is to stay below 300.
See here for details:
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
"dg2000r" <dg2000r@discussions.microsoft.com> wrote in message
news:05595B86-3808-4307-B40D-59C0463E0D47@microsoft.com...[vbcol=seagreen]
> Hi
>
> There must be something like 400 postings in that channel now. I currently
> use a SortByStartDate(false) and then loop through the first 4 items to
> display them.
>
> I've tried commenting out various parts of the code and tested access
> times
> and it appears to be that the slow part of the process is creating and
> sorting the PostingCollection (rather than the looping & rendering). Is
> there
> any way to create a posting collection that doesn't bring back every item
> in
> a channel?
>
> Thanks
>
> Dave
>
> "Stefan [MSFT]" wrote:
>
| |
| j.madgwick@wiganmbc.gov.uk 2006-09-22, 1:18 pm |
| Hi Dave,
We had a similar predicament in our News channel so we implemented are
archive-type solution. Basically, every month we run a script that
creates a sub-channel for two months ago (called [monthYear]) and moves
all of the postings created in that month into that sub-channel. This
way, the main News Channel only contains Postings added this month and
the previous - keeping the quantity of Posting in the root News
channel down.
Cheers,
John.
|
|
|
|
|