Database caching on a shared host
- by tau
Anyone have any ideas how to increase MySQL performance on a shared host?
My question has less to do with overall database performance and more to do with simply retrieving user-submitted data.
Currently my database will create caches at timed intervals, and then the PHP will selectively access the static files it needs. This has given me a noticeable performance boost, but I am worried about a time in which I have so much data that having to read in big files in PHP will actually be slower.
I am just looking for ideas for shared hosting solutions; I am not going to get my own server anytime soon. Thanks!