[kronolith] kronolith - performance and memory usage

[Didi Rieder]

Hi,

maybe this is not related to Olivers question, but anyway...
I already wrote once to the list that kronolith (using the sql driver with a
mysql back end) is loading very slow, but I didn't include any data.

Now that I turned on DEBUG in Horde's logging I saw that by just clicking at the
Calendar icon to open the calendar kronolith performs 492 sql queries!!

488 of them are of the following type:

Mar 04 22:58:54 HORDE [debug] [kronolith] SQL Query by
Category_sql::getCategoryData(): SELECT category_data FROM horde_categories
WHERE category_id = 491 [on line 502 of
"/usr/local/apache/htdocs/horde/lib/Category/sql.php"]

(488 is also the number of horde_categories)

and the 4 others are the following:

Mar 04 22:58:53 HORDE [debug] [kronolith] SQL Query by Category_sql::_load():
SELECT category_id, category_name, category_parents, category_order FROM
horde_categories WHERE group_uid = 'horde.shares.kronolith' [on line 132 of
"/usr/local/apache/htdocs/horde/lib/Category/sql.php"]

Mar 04 22:58:58 HORDE [debug] [kronolith] SQL Query by Category_sql::_load():
SELECT category_id, category_name, category_parents, category_order FROM
horde_categories WHERE group_uid = 'horde.shares.kronolith' [on line 132 of
"/usr/local/apache/htdocs/horde/lib/Category/sql.php"]
Mar 04 22:59:00 HORDE [debug] [kronolith] SQL Query by Category_sql::_load():
SELECT category_id, category_name, category_parents, category_order FROM
horde_categories WHERE group_uid = 'horde.shares.kronolith' [on line 132 of
"/usr/local/apache/htdocs/horde/lib/Category/sql.php"]
Mar 04 22:59:02 HORDE [debug] [kronolith] SQL Query by Category_sql::_load():
SELECT category_id, category_name, category_parents, category_order FROM
horde_categories WHERE group_uid = 'horde.shares.kronolith' [on line 132 of
"/usr/local/apache/htdocs/horde/lib/Category/sql.php"]

This scares me, because if the number of categories raises lets say to 5000,
kronolith will perform 5000 queries, jut to open the calender.

Is there anything I may have missed in my config? (CVS HEAD Mar. 1. 03)

horde/config/conf.php
$conf['category']['driver'] = 'sql';
// $conf['category']['params'] = array();

horde/kronolith/config/conf.php
$conf['calendar']['driver'] = 'sql';
$conf['calendar']['params'] = array_merge($conf['sql'], array('table' =>
'kronolith_events'));

Thanks

      Didi

-- 
-------------------------
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: 185 bytes
Desc: PGP Digital Signature
Url : http://lists.horde.org/archives/kronolith/attachments/20030304/f44fb234/attachment.bin