[turba] unefficient use of mysql on turba ?

Jan Schneider jan at horde.org
Fri Aug 29 16:34:44 PDT 2003


Zitat von Jean-Michel Besnard <besnard at tekkno.net>:

> since I got hundreds of entries in my adressbook (mysql source) I have
> noticed that both 'browse' and 'search' are getting really slow.
>
> I have finally figured out that loads of sql queries are being made to
> the mysql server for each request.
>
> Actually, if I have 1000 entries in my adressbook then 1000 queries such
> as "select firstname,lastname,..... where id=1234422321333" will be
> carried.
>
> I don't understand why an SQL query is needed for each object while IMHO
> a single query should be able to do the job.
>
> This is the case in a cvs checkout from december and in a recent cvs
> checkout (couple of days ago).

This is fixed now in CVS.

Jan.

--
http://www.horde.org - The Horde Project
http://www.ammma.de - discover your knowledge
http://www.tip4all.de - Deine private Tippgemeinschaft


More information about the turba mailing list