On Wed, May 03, 2006 at 12:10:38PM +0100, Alan Brown wrote: > On Wed, 3 May 2006, Christoph Haas wrote: > > >>That won't help, but proper indexing should speed things up. > > > >Au contraire. In this case the indexing is slowing down the import. > >Importing the pure data is taking a few minutes only while creating the > >indexes is taking a day. > > Doh, of course... > > Are you using commit statements to make the import one transaction rather > than thousands of individual ones?
I'm using mainly the default options of 'mysqldump' to create the file I import. The SQL file seems to be optimized a bit already since before creating the `File` rows it runs /* DISABLED KEYS */ and after that /* ENABLE KEYS */. IMHO that should speed up things a little because the index will not be regenerated after every INSERT statement. Kindly Christoph ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
