Post
Topic
Board Services
Re: Website Preview: BITADS.NET. Now Pay-Per-Day!
by
Matoking
on 25/09/2013, 13:58:08 UTC
Site got really slow after that huge series site showed up.
My host was having some internet issues, which should be resolved now. Although some of the SQL calls do seem to be getting a little slow so I will work modifying these to speed them up.
Here's some performance tips I've found useful when running BitBin.

You should also look into implementing Memcache if you haven't done so already. I tried it out and it increased my site performance considerably when some SQL calls can be skipped entirely.
http://memcached.org/

You could also try fine-tuning your MySQL/MariaDB settings if you're using either one of them using this script. It should be noted they are only guidelines, but should be useful in figuring out which settings need to be adjusted.
https://github.com/major/MySQLTuner-perl

Then there's Xcache for PHP which acts as an opcode cache. I also switched to nginx recently, which uses far less RAM and handles multiple parallel users far better than Apache.