[Tickets #2298] RESOLVED: Move history to its own table

[bugs@bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=2298
-----------------------------------------------------------------------
 Ticket             | 2298
 Updated By         | leena.heino at uta.fi
 Summary            | Move history to its own table
 Queue              | Turba
 Version            | HEAD
 State              | Resolved
 Priority           | 1. Low
 Type               | Bug
 Owners             | Chuck Hagenbuch
-----------------------------------------------------------------------


leena.heino at uta.fi (2005-07-20 11:52) wrote:

>  As you saw in the datatree monster sql the query took 
> something like 54 seconds to complete. And this query is run every 
> time the user adds an address to the address book or creates a new 
> event or task or note.

I've now tested this with horde head and framework 3 versions. The task was
adding a single entry to address book or a task to calendar:
Horde framework 3 version with history in a datatree: 2 minutes.
Horde head version with history in a separate table: 2 seconds.