[prev in list] [next in list] [prev in thread] [next in thread] 

List:       spamassassin-devel
Subject:    [Bug 6710] sa-learn --restore with MySQL is horrible slow
From:       bugzilla-daemon () bugzilla ! spamassassin ! org
Date:       2016-02-22 23:45:41
Message-ID: bug-6710-26-VadKD8L6Eu () https ! bz ! apache ! org/SpamAssassin/
[Download RAW message or body]

https://bz.apache.org/SpamAssassin/show_bug.cgi?id=6710

Ivan Filippov <ivan.v.f@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |ivan.v.f@gmail.com

--- Comment #1 from Ivan Filippov <ivan.v.f@gmail.com> ---
This affects any component using Mail::SpamAssassin::BayesStore::SQL.  The
INSERTs and UPDATEs could be batched in transactions to speed this up.

I'm using 3.4.0 with a MariaDB Galera cluster (3 intercontinental members). 
I've tested differently sized scan targets via bayes and just standard database
operations.  INSERTing 400 simple records one at a time (with autocommit) takes
around 80 seconds, entering 400 of the same records within a transaction takes
less than 1 second.

-- 
You are receiving this mail because:
You are the assignee for the bug.
[prev in list] [next in list] [prev in thread] [next in thread]