[horde] Database performance problem with Horde3/IMP4 with large user base

[Robert Atkinson]

I'm going to try to get some time tonight to populate and test
some of this. I know my company is going to have 2-3k in users within 6 
months. If I need to help make changes now, it's better to get a huge head 
start.
 I know that the mysql cluster database may help with this, but I feel it's 
maybe only a band-aid.
 

 On 9/8/05, Kevin M. Myer <kevin_myer at iu13.org> wrote: 
> 
> Quoting Luc Germain <Luc.Germain at USherbrooke.ca>:
> 
> > We use mysql MySQL 4.1.10a on a Xeon 3GHz w/ 2GB memory running RedHat
> > Enterprise 4.
> >
> > On this server (doing nothing else), one request like the one shown take
> > about .2 sec to be executed. Our horde_datatree table contains more han
> > 10000 entries, and the horde_datatree_attribute also more than 10000
> > entries.
> 
> My horde_datatree table has over 40,000 entries and the
> horde_datatree_attribute
> table has over 160,000, but we're below 100 active users currently. So
> its not
> so much the number of entries (likely) as it is the number of simultaneous
> lookups against the existing entries that is causing performance issues 
> for
> you. Or it could be that the info should be cached by Horde, but there's a
> cache call failing somewhere [thats only speculation of a possible 
> scenario].
> 
> Kevin
> --
> Kevin M. Myer
> Senior Systems Administrator
> Lancaster-Lebanon Intermediate Unit 13 http://www.iu13.org
> 
> 
> --
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>