I've created a PHP web application in Dreamweaver, which uses a MySQL database, containing 14 tables.

On one page, I use an SQL query to select data from 10 of the tables in the database.

However, when I try to preview the page in a browser, a PHP warning stating that the MySQL engine has run out of memory.

Is there a way of increasing the Memory Cache of the engine, or a way to optimize the performance?

I am testing locally and will be hosted on our existing internal server, for internal users only. The internal server has the same Apache, PHP and MySQL set up as my local installation.

I don't know how to adjust the settings to increase the memory size, cache or idle time (if this is the problem).

I'm also not sure how to backup my SQL database to upload, along with my PHP code, to something like RapidShare for you guys to take a look at.

I hope someone can help on this as it will help me out tremendously!

Cheers

Samuel

You would give us a better idea of how you are querying the tables. Perhaps there is something you are doing that is taking up memory when it isn't needed.

are your tables indexed? are you making efficient queries where you are using JOINs or UNIONs?

that's the problem, the joins weren't done properly, and he was getting humoungous cross join effects

see this thread on that other forum