http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 21 Apr 2026 01:42:37 +0000 Wed, 31 Jan 2007 13:33:35 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=6255 http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ http://forum.codejock.com/forum_posts.asp?TID=6255&PID=19961&title=updating-recurrence-patterns-db-performance#19961 Author: zotteLORRE
Subject: 6255
Posted: 31 January 2007 at 1:33pm

Thank you very much! With this final, little issue resolved, I've managed to complete my project for 99% now.

As a junior developer, I can say that implementing the calendarcontrol was really fun, and that Codejock support is very good.

It's a real quality component, and worth the buy!

Greets.
]]> Wed, 31 Jan 2007 13:33:35 +0000 http://forum.codejock.com/forum_posts.asp?TID=6255&PID=19961&title=updating-recurrence-patterns-db-performance#19961 http://forum.codejock.com/forum_posts.asp?TID=6255&PID=19958&title=updating-recurrence-patterns-db-performance#19958 Author: sserge
Subject: 6255
Posted: 31 January 2007 at 1:15pm

Regarding your first note about DoReadRPattern...
This was fixed in version 10.4. - using Internal cache added.
 
Regarding a second problem about update exceptions...
This is an expected behaviour. Recurrence pattern update works as a full update.
I think we can optimize simething on this in DataProvider later.
 
As a workaround you can use BeforeEditOperation notification to remember currently editing event.
In DoUpdateEvent check whether a currently editing event is a recurrence exception, and skip other exceptions updates.

--
WBR,
Serge
]]> Wed, 31 Jan 2007 13:15:21 +0000 http://forum.codejock.com/forum_posts.asp?TID=6255&PID=19958&title=updating-recurrence-patterns-db-performance#19958 http://forum.codejock.com/forum_posts.asp?TID=6255&PID=19829&title=updating-recurrence-patterns-db-performance#19829 Author: zotteLORRE
Subject: 6255
Posted: 29 January 2007 at 5:07am

Hi,


I've got my CalendarControl app with custom event handlers (for MySQL)  up-and-running for some time now .

In the beginning (when there was little data to exchange between database and app) performance was smooth.

After a while, CalendarControl.DoReadRPattern event slowed the app down, because of lots of recurrence patterns to retrieve from DB. But problem was resolved implementing caching for the DoReadRPattern event.

But still, when updating a recurrence pattern exception will cause a lot of overhead.

Apparently after the main recurrence pattern gets updated, all of the related events / recurrence exceptions will be forced to be updated (in my case, it will generate about 60 UPDATE queries ).

Is this the normal behaviour? I'm trying to figure out how to update only the event / recurrence exception which got modified instead of all of the related events.

If somebody's got any tips, workarounds, ...

Thanks in advance!
]]> Mon, 29 Jan 2007 05:07:13 +0000 http://forum.codejock.com/forum_posts.asp?TID=6255&PID=19829&title=updating-recurrence-patterns-db-performance#19829