[Chandler-dev] Re: [chandler-users] collection size after upgrade

[Grant Baillie]

On 7 Feb, 2008, at 11:30, Rick Rawson wrote:

>
> At Sheila's request a couple of days ago, I made special note of the  
> number of items in my collections: >5000
>
> After upgrading to Chandler 0.7.4 today, I started with a fresh  
> repository and imported a .chex file. I have poked around my  
> collections and I am convinced that I have not lost any data.  
> However, Chandler now reports that I have ~2500 items. Further,  
> Chandler seems to respond to my mouse clicks in a noticeably  
> snappier way than it did this morning with v0.7.3.
>

Hi, Rick

I'm not sure why the number of items changed. My only theory is that  
it is possible that in 0.7.3 we were exporting items for "redundant"  
occurrences (i.e. unmodified events in a recurring series), but we  
fixed that in 0.7.4. Do you have a lot of recurring events?

If you have the debug plugin installed, there is a menu (Tools ->  
Sharing -> Convert export file) that allows you to convert that .chex  
file into a text format. That would be one way to explore what's  
different (though the format still might seem like gobbledegook to  
you :).

BTW, reading back to your earlier email, I saw:

>> 3. items: 5176 (...if that's the right number; this is the value
>> reported when I "Export Collections and Settings..."

I believe that that is count is correct (depending on what you call an  
"item").

> What happened? What does Export Collections and Settings... followed  
> by Reload Collections and Settings... do, that purging does not do?  
> Would you predict that performance would be improved by starting  
> with a fresh repository and Reloading...?


In general, a reload should improve repository performance. The reason  
is that reload does not preserve item history, so there's less data  
stored in the repository, and therefore less time to find data on  
disk. This is similar to the performance gains for purge: the  
difference is that purge only removes all history prior to your last  
sync.

Hope this helps,

--Grant