Adding "set autocommit=0;" at the beginning and a "commit;" after every
table dump will get the load time down to 15 seconds.
Changing the single inserts to multiple inserts will get the load time
down to 8 seconds.
I liked the nice "clean" look of the sample database -- It removed as
many beginner-obstacles as possible. However, both of these
optimisations are in the certification study etc, and are encouraged.
It could be argued that we should practice what we preach :-)
Just my two cents.
- Morgan
(usually mor...@mysql.com)
5 messages in com.mysql.lists.communityRe: Sakila 0.5, Now With Data Goodness!