June 16th, 2000, 01:53 PM
I have a MySQL database with 25 tables running on Apache. One of my tables (shopper table) has close to 300,000 records and I use this table quit frequently for queries. I came across a problem using a query to access my shopper table and another table (this table has around 15,000 records) to pull the necessary information. The problem is that when I run this query it runs for a long period of time then the database crashes (with no query result). Can MySQL handle only a certain amount of records before it becomes overburdened? Also, I am using PHP 3 to run this query. Thanks.
June 16th, 2000, 04:31 PM
"I came across a problem using a query to access my shopper table and another table (this table has around 15,000 records)..."
Can we assume you are joining the two tables? How are you joining them (post your query). If you aren't doing the join right you'll end up with a temp table of 45G records!
June 19th, 2000, 08:47 AM
June 19th, 2000, 09:13 AM
June 21st, 2000, 11:17 PM
Yeah, with big tables like that a bad JOIN can be a major problem... And use EXPLAIN to make sure you have your indexes set up right...