June 16th, 2000, 10:17 AM
I have a table with 4500 records (name, address etc) and I am doing a table join with a categories table (60) records and a link table (links an address record id to a category id).
When doing a query accross the whole lot I am getting errors like - table SQLdbs is Full.
I've tried setting the SQL_BIG_TABLES=1 but this just seems to use the remaining 3Gb on hard disk and then breaks.
Does MySQL really need that much space for the query ?? or am I doing something very strange ?
Surely MySQL should be able to handle tables with 100,000s records.
Any help would be much appreciated.
June 16th, 2000, 11:37 AM
You probably aren't doing the join correctly. Post your query.