[dev] datatree performance issue on large installations

Didi Rieder adrieder at sbox.tugraz.at
Thu May 18 06:16:43 PDT 2006


Hi,

I just wanted to kindly ask if anything mentioned in this message:  
<http://article.gmane.org/gmane.comp.horde.devel/13404> is already  
done, or if those plans still exist?

I still have to do execute

  delete horde_datatree,horde_datatree_attributes
  from
  horde_datatree,horde_datatree_attributes
  where
  horde_datatree.group_uid = 'horde.shares.kronolith' and
  horde_datatree_attributes.datatree_id = horde_datatree.datatree_id;

and

  delete horde_datatree,horde_datatree_attributes
  from
  horde_datatree,horde_datatree_attributes
  where
  horde_datatree.group_uid = 'horde.shares.nag' and
  horde_datatree_attributes.datatree_id = horde_datatree.datatree_id;

every 5 minutes, in order not to run into database performance  
problems discussed already in  
<http://thread.gmane.org/gmane.comp.horde.devel/13348/>


Thanks
    Didi

-- 
-------------------------
Didi Rieder
adrieder at sbox.tugraz.at
PGPKey ID: 3431D0B0
-------------------------

-- 
-------------------------
Didi Rieder
adrieder at sbox.tugraz.at
PGPKey ID: 3431D0B0
-------------------------

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


More information about the dev mailing list