On Fri, May 07, 2010 at 04:11:50PM +0300, Ion-Mihai Tetcu wrote: > On Fri, 7 May 2010 00:32:14 +0200 > Stevan Baji?? <ste...@bajic.ch> wrote: > > > > > > Btw, I'm stas on irc in #dspam. Lurking most of the time, maybe > > > > > I should ask there if somebody hangs on irc? > > > > > > > > > Ion-Mihai is hanging there. And he is sure already sharpening his > > > > Release Manager knife to kill me because I am purposing changes > > > > for DSPAM :) > > No, no :) I could kill you for "fix a bug" commit logs, but given that > you are the one that fixes them, I don't dare :) > > I should have the cattle-prod used on me for various reasons. (I'll > reply to your private mail about this later today, hopefully). > > > > Yep, had a chat this afternoon with ITetcu, he encouraged me to ask > > > on mailing list :) > > > > > Mailing list is often better because your question gets exposed to > > more users at once. And beside that the communication on the mailing > > list is mirrored and saved at many places. > > Indeed. Also mails then to be more clear (I misunderstood a bit what > Stas asked me on IRC). > Hi DSPAM community,
For myself, I really appreciate having the conversations about problems and solutions with DSPAM being carried out on the mailing list. It allows me to save a personal copy of key messages and provides a historical archive to search for answers. IRC conversations are only known to those who happened to be on-line at the time and then there is no record. Steve and Ion, I would like to thank you for all the hard work you have put into the DSPAM project. We are going to be upgrading our DSPAM infrastructure over the summer to version 3.9.0+ and hopefully switch from a MySQL backend to a PostgreSQL backend. As a start I have built 3.9.0 on a Solaris 8 box against PostgreSQL 8.4.2. My current project is to allow for an option to have the PostgreSQL driver use out-of-band binary transmission of query parameters. This will have two benefits. First, less CPU will be used since the atoi() calls will not be needed to send the data. Second, the size of the transmitted data will be reduced by 70% or more in the worst case of looking up the tokens. This is more important when the DSPAM DB is on a separate machine from the actual engine. The first cut will be using the libpqtypes.h library to do the work. Then I will do some comparisons between the binary transmission and the current non-binary transmission of the query parameters. Is this something that you would be interested in having folded back in to the DSPAM codebase? Regards, Ken ------------------------------------------------------------------------------ _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
