I’m new to PHP, but I recently installed a prewritten PHP script designed for interactive stories. Installation and customization went well and the database grew very quickly.
My problem is that my host told me this script is bogging down the server’s memory. Doh! They switched the script to another server, so I’m hoping that will take care of the problem. However, I expect the DB to grow much larger in size and am wondering if the problem will just be repeated.
Does this problem sound like it's due to too many connections from too much user traffic? (Not using pconnect, btw.)
Would it be that the queries/code used in script are flawed?
Or possibly it's just the nature of the data stored (i.e., hundreds of long stories)?
Sorry for the general nature of this question, but I'm having trouble understanding why this particular DB uses up so much memory, as opposed to other PHP DBs (including a forum and a gallery) that work fine with just as much site traffic and data.
