Stored procedures can speed up your code by reducing trips to your database -- even if you only have one SQL statement to execute. Here's how to speed up your application (and how to simplify your ...

If I create an identical non-temporary table the on-disk data file is ~100MB (engine=myisam). I have tmp_table_size for MySQL set to 256MB and max_heap_table_size set to 512MB.