1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 1999
    Norfolk, UK
    Rep Power

    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.

  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Niagara Falls (On the wrong side of the gorge)
    Rep Power
    You probably aren't doing the join correctly. Post your query.

Similar Threads

  1. Replies: 0
    Last Post: September 15th, 2003, 04:51 PM
  2. Replies: 0
    Last Post: August 24th, 2003, 09:51 AM
  3. Replies: 0
    Last Post: June 22nd, 2003, 02:54 PM
  4. Replies: 0
    Last Post: June 22nd, 2003, 06:07 AM
  5. Replies: 0
    Last Post: December 18th, 2000, 12:59 PM

IMN logo majestic logo threadwatch logo seochat tools logo