[dev] Splitting datatree by application

[Ben Chavet]

I'm trying to split my datatree tables, such that each application has 
their own set.  By doing so, I'm hoping to see an increase in 
performance.

For example, I'd like to move all members of horde.shares.trean into 
trean_datatree and trean_datatree_attbributes tables.  trean_datatree 
is pretty straightforward, but trean_datatree_attributes is not.

Sadly, SQL is not my strong point, so if anyone could help me develop a 
series of SQL statements that would move (or copy) the data, I'd 
greatly appreciate it.

--Ben
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: PGP Digital Signature
Url : http://lists.horde.org/archives/dev/attachments/20051204/ff2b3cad/attachment.bin