Colligo Contributor OutLook Add-In For SharePoint

Colligo outlook addin for SharePoint is a great product, how microsoft just did’nt do it properly in the first place is a mystery, but hey Colligo’s gain.

I’ve had a few problems with large lists, realy large lists ,12000 plus. I know MS say don;t go over 5k but…. Anyhoo you can look to see how Colligo keeps the data in a SQLite DB locally.

To improve performance I tried adding my own indeces, unfortunately it did not like it at all. In the end we found a way to bring the list size down.

If you want to look at the data yerself get SQL Lite browser from here:

http://sqlitebrowser.sourceforge.net/

then open up the Collgio DB which is usualy here :

C:\Documents and Settings\{current user}\Local Settings\Application Data\ColligoOfflineClient\Storage5

Then you can browse and see the list lookups.