Trying sequential SQL imports to avoid hitting timeouts
authorAlexander Ebert <ebert@woltlab.com>
Mon, 3 Jun 2013 01:13:51 +0000 (03:13 +0200)
committerAlexander Ebert <ebert@woltlab.com>
Mon, 3 Jun 2013 01:13:51 +0000 (03:13 +0200)
commit2fbf50460bad59c280c0c5d36e6894fbefd78e9c
tree3e4104661c24301056033ba4c8109e4a54f768da
parent2f79714d5b2c65f3dad7744556fc69fc4315b63b
Trying sequential SQL imports to avoid hitting timeouts

I've observed that adding the foreign keys is taking up ~70% of the entire time needed to import the SQL file. This work-around does not decrease the time, instead it splits it into big chunks processed in multiple requests.
wcfsetup/install/files/lib/system/WCFSetup.class.php
wcfsetup/install/files/lib/system/database/util/SQLParser.class.php
wcfsetup/setup/db/install.sql
wcfsetup/setup/template/stepNext.tpl