[trean] Ideas for Trean

[Mike Cochrane]

Just another thought... although it was a fun experiment... 

how keen are people to keep everything stored in categories? with groups, perms,
and shares allready stored in this i would be keen to move trean into an sql
backend. 

The main reason for this is the size of the objects being stored. If we stay
with categories:
 for each request of a bookmark there will be: a shares query, groups query,
could of perms queries and a bookmarks query. 
The first 3 are returning very small objects (<1000 characters) the last one is
returning a very large (15K+ characters here)  object representing all the
bookmarks in the whole category.

It makes it very hard to keep the category_data column a nice fast VARCHAR type
if you need to be able to put objects that large in it.

If it was moved to an sql backend then each bookmark would be a separate row
with smaller, quicker to access field lengths.


This is another thing i'm happy to take suggestions and thoughts one... 

- Mike :-)