Tim Mattison wrote: > My primary concerns: > - Are there any reasons why we need to only look at the first 255 > characters of the header name? > - Are there any reasons why we would be looking for the <secretstuff> > string in the middle of a header value?
I'd have to see the IMAP command involved. Iirc, it looks like a IMAP SEARCH command. What do you mean by 'moving messages between IMAP'. Imapsync, perhaps? >From memory: yes, imap search requires substring matching, non-case sensitive (charset depending). Limiting the search to the first 255 characters is a hack to try and use a substring index CREATE INDEX dbmail_headervalue_3 ON dbmail_headervalue(substring(headervalue,0,255)); in order to avoid full table scans on the headervalue column. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ Dbmail-dev mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
