[horde] Performance Problems with imp/horde
Marc Bentje
noreply at htp-tel.de
Sat Sep 24 05:33:57 PDT 2005
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
More information about the horde
mailing list