http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 28 May 2026 05:30:44 +0000 Mon, 30 Apr 2012 00:43:53 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=19173 http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ http://forum.codejock.com/forum_posts.asp?TID=19173&PID=68138&title=speeding-up-calendar#68138 Author: belkaze
Subject: 19173
Posted: 30 April 2012 at 12:43am

Going to SQLEX is a better solution compared to MS Access in regards to efficiency and speed. But to those who stick with MS ACCESS will only have to options delete events or to upgrade the ACCESS to a RDBMS. SQLEX is free and the use of triggers allows further options in functionality at the back end e.g. reports]]> Mon, 30 Apr 2012 00:43:53 +0000 http://forum.codejock.com/forum_posts.asp?TID=19173&PID=68138&title=speeding-up-calendar#68138 http://forum.codejock.com/forum_posts.asp?TID=19173&PID=68135&title=speeding-up-calendar#68135 Author: Boris
Subject: 19173
Posted: 28 April 2012 at 10:23am

belkaze. I now have over 20,000 records and it performs admirably proving you don't use Access+more than 5 users.  I have moved over to SQL Server Express and the difference is amazing. As SQLEX is free its a bit of a no brainer as long as you have the time to change a bit of your code around. Before I moved I found that the Access itself was beginning to groan a bit so it may not be down to the CJ control.

]]> Sat, 28 Apr 2012 10:23:40 +0000 http://forum.codejock.com/forum_posts.asp?TID=19173&PID=68135&title=speeding-up-calendar#68135 http://forum.codejock.com/forum_posts.asp?TID=19173&PID=68120&title=speeding-up-calendar#68120 Author: belkaze
Subject: 19173
Posted: 27 April 2012 at 12:03am

Found the same problem, I believe it does not retrieve that many records efficiently. Gonna have to back up the data and start clearing the up the events table]]> Fri, 27 Apr 2012 00:03:00 +0000 http://forum.codejock.com/forum_posts.asp?TID=19173&PID=68120&title=speeding-up-calendar#68120 http://forum.codejock.com/forum_posts.asp?TID=19173&PID=66872&title=speeding-up-calendar#66872 Author: Boris
Subject: 19173
Posted: 20 November 2011 at 8:01am

Me too. I have found the interface sticks and locks up the user experience. This has only just started to happen in the last couple of months. 11151 events in the event table.]]> Sun, 20 Nov 2011 08:01:24 +0000 http://forum.codejock.com/forum_posts.asp?TID=19173&PID=66872&title=speeding-up-calendar#66872 http://forum.codejock.com/forum_posts.asp?TID=19173&PID=66806&title=speeding-up-calendar#66806 Author: dexatron
Subject: 19173
Posted: 12 November 2011 at 7:34am

Hi,

I am loading about 6000 appointments into the calendar using CreateEventEx (Some customers will have more entries than this)

My calendar is slowing to a crawl on a high performance i7 computer. (Codejock version 15.1.3)
It takes about 25 seconds to load the calendar and about 10 seconds to scroll between months in monthview.

Is there any way to speed up the calendar with many events?

Thanks for all your hard work, Greg!


]]> Sat, 12 Nov 2011 07:34:49 +0000 http://forum.codejock.com/forum_posts.asp?TID=19173&PID=66806&title=speeding-up-calendar#66806