LAMP Server Performance Tips
I am running a web directory using WordPress which has a lot of categories, and I mean a lot. Around 26,000 to be precise. And it takes WordPress forever to finish processing certain requests. The homepage takes around 120 seconds to finish processing and then the data is sent over. I recently moved this to a different host which has 2 GB RAM. I am using BitNami LAMPStack.
I am wondering what it is that effects the time required to process a request? Apache, MySQL, PHP or all? I am hoping I can bring the amount of time it takes down significantly and I would appreciate if someone could maybe point me to the right direction? I have tried playing with apache configuration and mysql file(s).
And apache is using prefork and mod_php