WampServer
Apache, PHP, MySQL
on Windows
memory limit
Posted by:
niche
(---.neb.res.rr.com)
Date: March 07, 2013 06:27PM
RE: SQL JOIN.
I'm joining a table with 150.000 rows, with a table with 12,000 rows, with a table with 2 rows. My JOIN query never stops.
I reduced the size of my table with 150,000 rows to 500 rows and my JOIN query finishes after a second or two.
I'm guessing that I have some kind of memory limit.
What do you think? If it's a memory limit, which limits should I check?
I'm joining a table with 150.000 rows, with a table with 12,000 rows, with a table with 2 rows. My JOIN query never stops.
I reduced the size of my table with 150,000 rows to 500 rows and my JOIN query finishes after a second or two.
I'm guessing that I have some kind of memory limit.
What do you think? If it's a memory limit, which limits should I check?
Re: memory limit
Posted by:
RiggsFolly
(---.as13285.net)
Date: March 07, 2013 07:11PM
99% likely you have done something hinky in the query
Sorry, only registered users may post in this forum.
