stevan are you shure about the compiled with intelcompiler`?

how does it react in virtualized enviroments? i guess there might it a bit 
harder :-)

recompiling might help but first tune the settings there you can gain a couple 
of tousand percent
depending what statements you use and which engine / transactions, tablescans 
and so on
even on data important



btw: just for everyone who dont know that.
you might find out that your mysqlbox creates a lot of disk-based tempoary 
tables specially with dpsam
DO NOT TUNE tmp_table_size higher it will not help you - BLOB and Textcolums 
are never ever saved in the memory

so if you have a very high traffic on your dspam and a lot of blobreading use a 
very fast hard disk array (cached raid 10 with battery of course)
for high performance systems - and be shure that your mysql partition has 
enough space left - sometimes you can run out of diskspace with a single sql 
statement
(ok not in dspam but dont wonder if that can happen on custom statements 
special with subselects and joing on big blob tables)

------------------------------------------------------------------------------
This SF.net email is sponsored by 

Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev 
_______________________________________________
Dspam-user mailing list
Dspam-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspam-user

Reply via email to