[imp] 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 imp mailing list