Re: Performance

On 24/04/15 08:26, absolutely_free@libero.it wrote:

My question is: is better to use SQLite instead of MySQL? Should I prefer dbox format?

Thank you in advance for your opinion!

 While 10k accounts is not a few accounts, i wouldn't call that a 

LOT of accounts neither. Assuming that the query cache is active on MySQL, probably almost all your queries are being answered directly from the cache and, if not that, your tables shouldnt be that big and after a few queries should be all in cache memory of the Linux system. Your I/O costs on the MySQL should be very very very low, o i really doubt that MySQL is being part of your problem here.

 Unless, of course, that you have other heavy databases running on 

the MySQL instance your mail system is using...

--

Atenciosamente / Sincerily,
Leonardo Rodrigues
Solutti Tecnologia
http://www.solutti.com.br

Minha armadilha de SPAM, NÃO mandem email
gertrudes@solutti.com.br
My SPAMTRAP, do not email it