It makes no sense to make a fulltext on the data column in the mimeparts
table, because most of the data is base64 encoded and/or is a attachment..
We may need a second table that only holds the (decoded) message part
(text/plain html/plain (maybe with removed html)). This table could have a
Am 06.03.2015 um 10:11 schrieb Andrea Brancatelli:
> There's already some Oracle-specific code in the codebase, it's, just
> one query, it could be implemented with a specific code for Full Text
> capable/not capable DBMS.
>
I don't have a problme with it myself ^^ someone just has to maintain
th
There's already some Oracle-specific code in the codebase, it's, just
one query, it could be implemented with a specific code for Full Text
capable/not capable DBMS.
Il 06/03/15 07:48, Thomas Raschbacher ha scritto:
Am 05.03.2015 um 17:28 schrieb Jure Pečar:
On Wed, 4 Mar 2015 13:21:04 +0100
Is there really somebody that uses DBMail with SQLite??? Does this make
sense?
Am 06.03.15 um 07:48 schrieb Thomas Raschbacher:
Am 05.03.2015 um 17:28 schrieb Jure Pečar:
On Wed, 4 Mar 2015 13:21:04 +0100
Jure Pečar wrote:
SELECT DISTINCT m.message_idnr FROM dbmail_mimeparts p
LEFT
Am 05.03.2015 um 17:28 schrieb Jure Pečar:
> On Wed, 4 Mar 2015 13:21:04 +0100
> Jure Pečar wrote:
>
>> SELECT DISTINCT m.message_idnr FROM dbmail_mimeparts p
>> LEFT JOIN dbmail_partlists l ON p.id=l.part_id
>> LEFT JOIN dbmail_physmessage s ON l.physmessage_id=s.id
>> LEFT JOI
On Wed, 4 Mar 2015 13:21:04 +0100
Jure Pečar wrote:
> SELECT DISTINCT m.message_idnr FROM dbmail_mimeparts p
> LEFT JOIN dbmail_partlists l ON p.id=l.part_id
> LEFT JOIN dbmail_physmessage s ON l.physmessage_id=s.id
> LEFT JOIN dbmail_messages m ON m.physmessage_id=s.id
>
I've found that the imap search will always fail and timeout. It has never
worked for me in any version. Whenever I've wanted to find a message, I've
had to write my own query and search for it manually.
--Curtis
On Mar 4, 2015 8:14 AM, "Andrea Brancatelli"
wrote:
> We put our MySQL tmp path
We put our MySQL tmp path on an SSD and that improved the situation a
lot, but we have the same problem.
My (poor man) opinion is that using MySQL 5.6 fulltext capabilities is
the only solution...
Il 04/03/15 13:21, Jure Pečar ha scritto:
Hello,
I see sudden spikes of load on our dbmail mys
