MySQL using alot of disk space ???

Hi,

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.

Cheers

You probably aren't doing the join correctly. Post your query.