From: Thomas Eckardt/e. <Tho...@th...> - 2008-03-19 09:10:26
|
<FONT face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size=2><DIV><DIV><DIV>worth -> bad</DIV><DIV>carefull -> careful fixed!</DIV><DIV> </DIV><DIV>>which data bases do not handle the spamdb</DIV><DIV> </DIV><DIV>"Not handle" is not right, better say "Not propper import"!</DIV><DIV>For example MySQL !!! You can see this, if do an import for spamdb. You'll get a message for xxxx records found in file .... . All records are holded in a Perl hash, so they are unique! After import is done you'll get a message yyyy records imported. If the DB engine is working well, xxxx and yyyy should be equal - but they are not in most cases! That meens, some hashes has produced duplicate keys in the DB (that will be ignored), this should be not possible, because a Perl hash is always unique!</DIV><DIV>If you are using a professional DB engine like Oracle,Informix,DB2 or MS-SQL (some other may also)- this will not be happend.</DIV><DIV>I'm just using MySQL for production ASSP and there are 50 records droped while import (from 300.000) for spamdb. That does not matter! Why I'm using MySQL? - on the other MX for my domain, with a replicated database, ASSP V 1.3.3.8 is running - with "MySQL-only-Support" !!</DIV><DIV> </DIV><DIV>Thomas<BR></DIV><FONT color=#990099>---...@li... schrieb: -----<BR><BR></FONT><BLOCKQUOTE style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">An: "ASSP development mailing list" <ass...@li...><BR>Von: "Daniel K. Du Vall" <dd...@1p...><BR>Gesendet von: ass...@li...<BR>Datum: 19.03.2008 04:48<BR>Thema: [Assp-test] Proper use of words<BR><BR><DIV class=Section1><P class=MsoNormal>1.3.6 (6.12) <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></P><P class=MsoNormal>I am not sure what it trying to be said but this line in this version is not correct. <o:p></o:p></P><P class=MsoNormal><o:p> </o:p></P><P class=MsoNormal>First (carefull) should be (careful) <o:p></o:p></P><P class=MsoNormal>Second (worth things) I am not sure what is trying to be stated here. Could it be (bad things)? <o:p></o:p></P><P class=MsoNormal><o:p> </o:p></P><P class=MsoNormal><o:p> </o:p></P><P class=MsoNormal>Be carefull using databases for spamdb, some databases do worth things with the data in the pkey field! <o:p></o:p></P><P class=MsoNormal><o:p> </o:p></P><P class=MsoNormal>While I am on this any ideas which data bases do not handle the spamdb properly? <o:p></o:p></P><P class=MsoNormal><o:p> </o:p></P><P class=MsoNormal><o:p> </o:p></P><P class=MsoNormal>Daniel Du Vall <o:p></o:p></P></DIV><FONT face="Default Monospace,Courier New,Courier,monospace" size=2>-------------------------------------------------------------------------<BR>This SF.net email is sponsored by: Microsoft<BR>Defy all challenges. Microsoft(R) Visual Studio 2008.<BR><A href="http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/" target=blank>http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/</A></FONT><FONT face="Default Monospace,Courier New,Courier,monospace" size=2>_______________________________________________<BR>Assp-test mailing list<BR>Ass...@li...<BR><A href="https://lists.sourceforge.net/lists/listinfo/assp-test" target=blank>https://lists.sourceforge.net/lists/listinfo/assp-test</A><BR></FONT></BLOCKQUOTE><BR></DIV></DIV></FONT>DISCLAIMER:<BR> *******************************************************<BR> This email and any files transmitted with it may be confidential, legally privileged and protected in law and are intended solely for the use of the <BR> individual to whom it is addressed.<BR> This email was multiple times scanned for viruses. There should be no known virus in this email!<BR> |