SQLite is/can-be extremely slow with inserts/updates. It uses a temporary file for each write operation. It also waits for the OS to complete the insert/update. … Thats all assuming you can even get it working.
-- Jeremy McSpadden Flux Labs, Inc | http://www.fluxlabs.net<http://www.fluxlabs.net/> | Endless Solutions Office : 850-250-5590x101<tel:850-250-5590;101> | Cell : 850-890-2543<tel:850-890-2543> | Fax : 850-254-2955<tel:850-254-2955> On Mar 19, 2013, at 2:22 PM, Walter Hurry <walterhu...@gmail.com<mailto:walterhu...@gmail.com>> wrote: I am experimenting with using SQLite for my Bayes db. However when I start spamd, it reports the following in /var/log/maillog: bayes: tok_get_all: SQL error: no such function: RPAD This is correct, in that SQLite does not support RPAD. I believe this call is in SQL.pm (part of Mail::SpamAssassin::BayesStore). Is it possible to hack that module in any way to work around the issue? Sorry if this is too simple a question; whilst I am familiar with SQL, I know nothing of perl. In case it matters, this is SA 3.3.2
