Jochen Schroer wrote: > Hi Paul, > > this multiple cenversations decrease the oerformance of body search > again, because at the meoment the search process has to load every > messagepart of every message the performance is not really good. > I'm thinking a little bit about a universal solution, but I have now > idea up to now. > (for me with postgresql I can add a new messagetext table, fill them > with a trigger an d search with simple selects on this table, but that > is no universal solution for postgresql, mysql and sqlite) > > do you have think about a solution where you save the message twice if a > mail is inserted into the system? > One time in the existing format and additional in another table with > converted (UTF8?) content that you can use for search?
I've designed a solution to address this problem. Check the wiki: http://www.dbmail.org/dokuwiki/doku.php?id=bodysearch Basically, you can't use indexed searches on blobs. So the idea is to store only the /words/ from each attachment in separate records. Once that is done, those records /can/ be searched. Even non-indexed searches directly on the database (i.e. using HAVING) would probably be an improvement over the current situation. If you have a better idea, please share. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
