You can use SQL to store your bayes and awl databases if you're running on Windows. Storing the database in SQL reportedly reduces cpu overhead and increases speed. You can likely use any database that has a DBD module and permits threads to share handles. ADO does not permit handle-sharing, so you may not use it. Others have successfully installed MySQL on Windows and used that. This how-to provides information on using Microsoft's data engine. It was tested with MSDE 2000.
- Install the MSDE database engine. You can get it on the SQL 2000 service pack 4 download page: http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en. You want the SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE file near the bottom of the page. Extract it and follow the installation instructions. 2. Create a new database. Create a new login. Give the login rights to the database. I use the tools that came with SQL Server 2000 to do this. I don't know that Microsoft still has the tools available for MSDE 2000 since they want you to use SQL Express 2005 now. I haven't tested SQL Express 2005 mainly because our environment uses SQL Server 2000. 3. Create the RPAD function 3. Edit c:/perl/site/lib/mail/spamassassin/bayesstore/SQL.pm. Find the line that says and change it to 3. Create the tables in the database. 4. Install the DBI and ODBC database modules. 4. Edit local.cf to change the settings for AWL 5. Edit local.cf to change the settings for bayes