"Aaron Stone" <[EMAIL PROTECTED]> schrieb: > > I've been thinking about this for a while, and especially with the query > time escalation code, have found that the queries which do full header > searches are incredibly slow (for the obvious reason that they cannot use > the index). I did not have a look at the query times for a long time, but i like to provide you some feedback, which searches we are doing in eGroupWare very often and which don't seem to be as fast as i like to have.
FeLaMiMail(the eGroupWare imap client) is working directly on the imap server. It has only a session cache to store latest search/sort results. This allows us to skip forward and back in the messagelist without the need to search/sort the folder again. By default we have no search filter active. Which means we just sort by date for example. After we have the sort result, we are fetching the needed headers for the messages to display. This is more less ok. But we also have a quicksearch field. If you enter something in this quicksearch filed, we are searching for this string in the from or to address(depending if we are in the sent folder or not) and in the subject field. Last time i had a look at the sql queries, i discovered that dbmail was asking to times for the from/to address field and then again for the subject field. Using this kind of quicksearch takes twice the time of search for only the from/to address or the subject. I'll try to do some timing, to be able to compare if the newer search is faster then the older. >From the webbased app "point of view" it would be nice if dbmail could be optimized to handle this kind of queries as quick as possible. Just to let you know. -- Lars Kneschke Metaways Infosystems GmbH Pickhuben 2-4, D-20457 Hamburg eGroupWare Support: http://www.egroupware-support.net OfficeSpot.Net Collaboration Server: http://cs.officespot.net E-Mail: mailto:[EMAIL PROTECTED] Web: http://www.metaways.de Tel: +49 (0)40 317031-21 Fax: +49 (0)40 317031-921 Mobile: +49 (0)175 9304324 Metaways Infosystems GmbH - Sitz: D-22967 Tremsbüttel Handelsregister: Amtsgericht Ahrensburg HRB 4508 Geschäftsführung: Hermann Thaele, Lüder-H.Thaele _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev
