[imp] Performance Problems with imp/horde

[Julien MARCHAL]

Hi,
I haven't  try your patch but I think if I make this, the share feature
(kronolith, mnemo and nag) will not work after.
Someone could confirm this.

Thanks,

Marc Bentje <noreply at htp-tel.de> a écrit:

> Hello Folks,
>
> I gain some performance problems using
> horde / imp ... hmm the webmail-version ;)
>
> the performance steers down after a while ...
>
> nearly the same Problem like
>
> http://marc.theaimsgroup.com/?l=imp&m=112745110230786&w=2
>
> I've got
>
> ./lib/Horde/DataTree/sql.php: * $Horde:
> framework/DataTree/DataTree/sql.php,v 1.156.2.2 2005/01/03 12:18:58 jan
> Exp $
>
> a bit modified
>
> I commented out some of the full-table-scan 'features' of the
> horde.history ..
>
> these are the lines
>
>    191             // $query = sprintf('SELECT %s FROM %s WHERE (%s)
> AND group_uid = %s',
>    192                              // $count ? 'COUNT(*)' :
> 'datatree_id, datatree_name, datatree_parents, datatree_order',
>    193                              // $this->_params['table'],
>    194                              // $where,
>    195                              //
> $this->_db->quote($this->_params['group']));
>    196         } else {
>    197             // $query = sprintf('SELECT %s FROM %s WHERE
> group_uid = %s',
>    198                              // $count ? 'COUNT(*)' :
> 'datatree_id, datatree_name, datatree_parents, datatree_order',
>    199                              // $this->_params['table'],
>    200                              //
> $this->_db->quote($this->_params['group']));
>    201         }
>    202
>
>
>    247         // $query = sprintf('SELECT datatree_id,
> datatree_parents FROM %s' .
>    248                          // ' WHERE %sgroup_uid = %s' .
>    249                          // ' ORDER BY datatree_id',
>    250                          // $this->_params['table'],
>    251                          // $in,
>    252                          //
> $this->_db->quote($this->_params['group']));
>
>
>    276
>    277          //$query = sprintf('SELECT datatree_id, datatree_name,
> datatree_parents, datatree_order FROM %s' .
>    278                           //' WHERE datatree_id IN (%s)'.
>    279                           //' AND group_uid = %s ORDER BY
> datatree_id ',
>    280                           //$this->_params['table'],
>    281                           //implode(', ', $ids),
>    282
> //$this->_db->quote($this->_params['group']));
>    283
>
>
> now ... the webmail runs properly ... without any obvious errors ...
>
> can someone tell me whatfor the 'history' is for ??
>
> by now thanks a lot ...
>
> Marc
>
>
>
> --
> IMP mailing list - Join the hunt: http://horde.org/bounties/#imp
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe at lists.horde.org
>



-- 
Julien Marchal
Université Nancy 2 - CRI
Equipe système et réseaux
Tel : 03 83 39 64 91
Coordonnées :
http://www.univ-nancy2.fr/ANNUAIRE/PERS/detail_pres.php?uid=jmarchal