Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have an ASP Calendar, which shows elements from the list. If I try to bind the elements to the list, there are a lot of elements for example 35 429 elements. It takes up to 4 minutes to load this webpart after refresh.

I put Callendar on Ajax and Update Panel. When it reads once the calendar change fast, until next refresh.

Please tell me how make it faster?

Maybe I should work with paging in a calendar, to read from list faster?

Please how can I query faster, becouse 4 minutes are not acceptable, and in short time I will have to put 360 000 elements, which will probably take up to 40 minutes to load...

Please help.

share|improve this question
1  
Why would you need to show 360 000 elements to a user... that's not usefull. Maybe try working with paging? –  Ruben Herman Nov 19 '12 at 8:18
    
But how add pagging to the ASP Calendar ? –  Grzegorz Z Nov 19 '12 at 18:17
    
Is this 2007 or 2010? –  David Lozzi Nov 19 '12 at 19:33
    
It's a 2010 version. –  Grzegorz Z Nov 19 '12 at 23:28
add comment

1 Answer 1

360,000 items is unmanageable for a human to sit there and read, especially in a calendar view. What's your end goal or requirements for this? Do you really need all of them there or are you looking for some reporting/summarization of the data?

Writing the items to the page will be slow because there's a lot of data to process AND the resulting HTML output is going to be large. So regardless of improving the code behind it to improve the speed, the client still has to download, what I would imagine, is a relatively large HTML file (speaking in average web page sizes).

Where are your items living? Are they in a SharePoint list or SQL?

share|improve this answer
    
Because I have one list's with ranges DataStart, and Data Stop and secound list with describing in details first list. Element by element. And i present it's list on calendar. So it maybe will have got 360 000 element's in year. The item's Living on a List, because I think I will must use a infopath to describe elements. Please help, how to add pagging to a ASP Calendar. –  Grzegorz Z Nov 19 '12 at 23:32
    
At Sharepoint List –  Grzegorz Z Nov 30 '12 at 14:53
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.