Cache handling question

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

In my app, I'm using an own SQL DataProvider.
I implemented DoRetrieveDayEvents and it works fine - so far.

Problem is, that my calendar uses a remote SQL database and every day event generates a new query, which is a lot of traffic.

It seems the the cache fetches ALL dates in the range of +-10 years which leads to over 6000 queries for one update!
But this can only be observed in Office2007 theme with MultiScheduleView.

I tried to disable the calendar cache in the data provider, but without success.
What is the correct way here?

using 13.0.0 / VS8

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Marco1 Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 16 January 2004 Location: Germany Status: Offline Points: 251	Post Options Post Reply Quote Marco1 Report Post Thanks(0) Quote Reply Topic: Cache handling question Posted: 11 May 2009 at 5:57am
	In my app, I'm using an own SQL DataProvider. I implemented DoRetrieveDayEvents and it works fine - so far. Problem is, that my calendar uses a remote SQL database and every day event generates a new query, which is a lot of traffic. It seems the the cache fetches ALL dates in the range of +-10 years which leads to over 6000 queries for one update! But this can only be observed in Office2007 theme with MultiScheduleView. I tried to disable the calendar cache in the data provider, but without success. What is the correct way here? using 13.0.0 / VS8