diff options
| author | Thorbjørn Lindeijer <thorbjorn@lindeijer.nl> | 2012-12-15 22:44:06 +0100 |
|---|---|---|
| committer | Thorbjørn Lindeijer <thorbjorn@lindeijer.nl> | 2012-12-15 22:44:06 +0100 |
| commit | 2cc9562fd2ee8c57e835fdd5291184c830ef8e23 (patch) | |
| tree | 145e26f86c9e969ee8a096e9d53fb3bf6a7cace1 /src/sql | |
| parent | b2741a6c49eafb9f19f9cd6625836d85d31980b3 (diff) | |
| download | manaserv-2cc9562fd2ee8c57e835fdd5291184c830ef8e23.tar.gz manaserv-2cc9562fd2ee8c57e835fdd5291184c830ef8e23.tar.xz manaserv-2cc9562fd2ee8c57e835fdd5291184c830ef8e23.zip | |
Create database using a single transaction
Takes the time required to do initial database creation down from
16 to 0.2 seconds on the Raspberry Pi.
Diffstat (limited to 'src/sql')
| -rw-r--r-- | src/sql/sqlite/createTables.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/src/sql/sqlite/createTables.sql b/src/sql/sqlite/createTables.sql index 06dbd19..d845e84 100644 --- a/src/sql/sqlite/createTables.sql +++ b/src/sql/sqlite/createTables.sql @@ -18,6 +18,8 @@ -- along with The Mana Server. If not, see <http://www.gnu.org/licenses/>. -- +BEGIN; + ----------------------------------------------------------------------------- -- Tables ----------------------------------------------------------------------------- @@ -480,3 +482,5 @@ INSERT INTO mana_transaction_codes VALUES ( 51, 'Command RESTART_THIS', 'Com INSERT INTO mana_transaction_codes VALUES ( 52, 'Command RESTART_ALL', 'Commands' ); INSERT INTO mana_transaction_codes VALUES ( 53, 'Command ATTRIBUTE', 'Commands' ); INSERT INTO mana_transaction_codes VALUES ( 54, 'Command KICK', 'Commands' ); + +END; |