improved backlog replay performance
authorMarcus Eggenberger <egs@quassel-irc.org>
Sun, 2 Mar 2008 13:25:31 +0000 (13:25 +0000)
committerMarcus Eggenberger <egs@quassel-irc.org>
Sun, 2 Mar 2008 13:25:31 +0000 (13:25 +0000)
60 files changed:
src/core/SQL/SQLite/8/setup_999_version.sql [deleted file]
src/core/SQL/SQLite/9/delete_backlog_by_uid.sql [moved from src/core/SQL/SQLite/8/delete_backlog_by_uid.sql with 100% similarity]
src/core/SQL/SQLite/9/delete_backlog_for_buffer.sql [moved from src/core/SQL/SQLite/8/delete_backlog_for_buffer.sql with 100% similarity]
src/core/SQL/SQLite/9/delete_backlog_for_network.sql [moved from src/core/SQL/SQLite/8/delete_backlog_for_network.sql with 100% similarity]
src/core/SQL/SQLite/9/delete_buffer_for_bufferid.sql [moved from src/core/SQL/SQLite/8/delete_buffer_for_bufferid.sql with 100% similarity]
src/core/SQL/SQLite/9/delete_buffers_by_uid.sql [moved from src/core/SQL/SQLite/8/delete_buffers_by_uid.sql with 100% similarity]
src/core/SQL/SQLite/9/delete_buffers_for_network.sql [moved from src/core/SQL/SQLite/8/delete_buffers_for_network.sql with 100% similarity]
src/core/SQL/SQLite/9/delete_ircservers_for_network.sql [moved from src/core/SQL/SQLite/8/delete_ircservers_for_network.sql with 100% similarity]
src/core/SQL/SQLite/9/delete_network.sql [moved from src/core/SQL/SQLite/8/delete_network.sql with 100% similarity]
src/core/SQL/SQLite/9/delete_networks_by_uid.sql [moved from src/core/SQL/SQLite/8/delete_networks_by_uid.sql with 100% similarity]
src/core/SQL/SQLite/9/delete_quasseluser.sql [moved from src/core/SQL/SQLite/8/delete_quasseluser.sql with 100% similarity]
src/core/SQL/SQLite/9/insert_buffer.sql [moved from src/core/SQL/SQLite/8/insert_buffer.sql with 100% similarity]
src/core/SQL/SQLite/9/insert_message.sql [moved from src/core/SQL/SQLite/8/insert_message.sql with 100% similarity]
src/core/SQL/SQLite/9/insert_network.sql [moved from src/core/SQL/SQLite/8/insert_network.sql with 100% similarity]
src/core/SQL/SQLite/9/insert_quasseluser.sql [moved from src/core/SQL/SQLite/8/insert_quasseluser.sql with 100% similarity]
src/core/SQL/SQLite/9/insert_sender.sql [moved from src/core/SQL/SQLite/8/insert_sender.sql with 100% similarity]
src/core/SQL/SQLite/9/insert_server.sql [moved from src/core/SQL/SQLite/8/insert_server.sql with 100% similarity]
src/core/SQL/SQLite/9/select_authuser.sql [moved from src/core/SQL/SQLite/8/select_authuser.sql with 100% similarity]
src/core/SQL/SQLite/9/select_bufferByName.sql [moved from src/core/SQL/SQLite/8/select_bufferByName.sql with 100% similarity]
src/core/SQL/SQLite/9/select_bufferExists.sql [moved from src/core/SQL/SQLite/8/select_bufferExists.sql with 100% similarity]
src/core/SQL/SQLite/9/select_buffer_by_id.sql [moved from src/core/SQL/SQLite/8/select_buffer_by_id.sql with 100% similarity]
src/core/SQL/SQLite/9/select_buffer_lastseen_dates.sql [moved from src/core/SQL/SQLite/8/select_buffer_lastseen_dates.sql with 100% similarity]
src/core/SQL/SQLite/9/select_buffers.sql [moved from src/core/SQL/SQLite/8/select_buffers.sql with 100% similarity]
src/core/SQL/SQLite/9/select_connected_networks.sql [moved from src/core/SQL/SQLite/8/select_connected_networks.sql with 100% similarity]
src/core/SQL/SQLite/9/select_messageRange.sql [moved from src/core/SQL/SQLite/8/select_messageRange.sql with 100% similarity]
src/core/SQL/SQLite/9/select_messages.sql [moved from src/core/SQL/SQLite/8/select_messages.sql with 100% similarity]
src/core/SQL/SQLite/9/select_messagesOffset.sql [moved from src/core/SQL/SQLite/8/select_messagesOffset.sql with 100% similarity]
src/core/SQL/SQLite/9/select_messagesSince.sql [moved from src/core/SQL/SQLite/8/select_messagesSince.sql with 100% similarity]
src/core/SQL/SQLite/9/select_messagesSinceOffset.sql [moved from src/core/SQL/SQLite/8/select_messagesSinceOffset.sql with 100% similarity]
src/core/SQL/SQLite/9/select_networkExists.sql [moved from src/core/SQL/SQLite/8/select_networkExists.sql with 100% similarity]
src/core/SQL/SQLite/9/select_networks_for_user.sql [moved from src/core/SQL/SQLite/8/select_networks_for_user.sql with 100% similarity]
src/core/SQL/SQLite/9/select_persistent_channels.sql [moved from src/core/SQL/SQLite/8/select_persistent_channels.sql with 100% similarity]
src/core/SQL/SQLite/9/select_servers_for_network.sql [moved from src/core/SQL/SQLite/8/select_servers_for_network.sql with 100% similarity]
src/core/SQL/SQLite/9/select_userid.sql [moved from src/core/SQL/SQLite/8/select_userid.sql with 100% similarity]
src/core/SQL/SQLite/9/setup_000_quasseluser.sql [moved from src/core/SQL/SQLite/8/setup_000_quasseluser.sql with 100% similarity]
src/core/SQL/SQLite/9/setup_010_sender.sql [moved from src/core/SQL/SQLite/8/setup_010_sender.sql with 100% similarity]
src/core/SQL/SQLite/9/setup_020_network.sql [moved from src/core/SQL/SQLite/8/setup_020_network.sql with 100% similarity]
src/core/SQL/SQLite/9/setup_030_buffer.sql [moved from src/core/SQL/SQLite/8/setup_030_buffer.sql with 100% similarity]
src/core/SQL/SQLite/9/setup_040_buffer_idx.sql [moved from src/core/SQL/SQLite/8/setup_040_buffer_idx.sql with 100% similarity]
src/core/SQL/SQLite/9/setup_050_buffer_cname_idx.sql [moved from src/core/SQL/SQLite/8/setup_050_buffer_cname_idx.sql with 100% similarity]
src/core/SQL/SQLite/9/setup_060_backlog.sql [moved from src/core/SQL/SQLite/8/setup_060_backlog.sql with 100% similarity]
src/core/SQL/SQLite/9/setup_070_coreinfo.sql [moved from src/core/SQL/SQLite/8/setup_070_coreinfo.sql with 100% similarity]
src/core/SQL/SQLite/9/setup_080_ircservers.sql [moved from src/core/SQL/SQLite/8/setup_080_ircservers.sql with 100% similarity]
src/core/SQL/SQLite/9/setup_090_create_backlog_idx.sql [new file with mode: 0644]
src/core/SQL/SQLite/9/setup_100_create_backlog_idx2.sql [new file with mode: 0644]
src/core/SQL/SQLite/9/setup_110_create_buffer_idx.sql [new file with mode: 0644]
src/core/SQL/SQLite/9/setup_999_version.sql [new file with mode: 0644]
src/core/SQL/SQLite/9/update_buffer_lastseen.sql [moved from src/core/SQL/SQLite/8/update_buffer_lastseen.sql with 100% similarity]
src/core/SQL/SQLite/9/update_buffer_name.sql [moved from src/core/SQL/SQLite/8/update_buffer_name.sql with 100% similarity]
src/core/SQL/SQLite/9/update_buffer_persistent_channel.sql [moved from src/core/SQL/SQLite/8/update_buffer_persistent_channel.sql with 100% similarity]
src/core/SQL/SQLite/9/update_buffer_set_channel_key.sql [moved from src/core/SQL/SQLite/8/update_buffer_set_channel_key.sql with 100% similarity]
src/core/SQL/SQLite/9/update_network.sql [moved from src/core/SQL/SQLite/8/update_network.sql with 100% similarity]
src/core/SQL/SQLite/9/update_network_connected.sql [moved from src/core/SQL/SQLite/8/update_network_connected.sql with 100% similarity]
src/core/SQL/SQLite/9/update_username.sql [moved from src/core/SQL/SQLite/8/update_username.sql with 100% similarity]
src/core/SQL/SQLite/9/update_userpassword.sql [moved from src/core/SQL/SQLite/8/update_userpassword.sql with 100% similarity]
src/core/SQL/SQLite/9/upgrade_000_create_backlog_idx.sql [new file with mode: 0644]
src/core/SQL/SQLite/9/upgrade_010_create_backlog_idx2.sql [new file with mode: 0644]
src/core/SQL/SQLite/9/upgrade_020_create_buffer_idx.sql [new file with mode: 0644]
src/core/SQL/SQLite/9/upgrade_999_version.sql [new file with mode: 0644]
version.inc

diff --git a/src/core/SQL/SQLite/8/setup_999_version.sql b/src/core/SQL/SQLite/8/setup_999_version.sql
deleted file mode 100644 (file)
index a65213b..0000000
+++ /dev/null
@@ -1 +0,0 @@
-INSERT INTO coreinfo (key, value) VALUES ('schemaversion', '8')
diff --git a/src/core/SQL/SQLite/9/setup_090_create_backlog_idx.sql b/src/core/SQL/SQLite/9/setup_090_create_backlog_idx.sql
new file mode 100644 (file)
index 0000000..a91b59a
--- /dev/null
@@ -0,0 +1 @@
+CREATE INDEX backlog_bufferid_idx ON backlog(bufferid)
diff --git a/src/core/SQL/SQLite/9/setup_100_create_backlog_idx2.sql b/src/core/SQL/SQLite/9/setup_100_create_backlog_idx2.sql
new file mode 100644 (file)
index 0000000..b515624
--- /dev/null
@@ -0,0 +1 @@
+CREATE INDEX backlog_buffer_time_idx ON backlog (bufferid, time)
diff --git a/src/core/SQL/SQLite/9/setup_110_create_buffer_idx.sql b/src/core/SQL/SQLite/9/setup_110_create_buffer_idx.sql
new file mode 100644 (file)
index 0000000..cb55f1d
--- /dev/null
@@ -0,0 +1 @@
+CREATE INDEX buffer_user_idx ON buffer(userid)
diff --git a/src/core/SQL/SQLite/9/setup_999_version.sql b/src/core/SQL/SQLite/9/setup_999_version.sql
new file mode 100644 (file)
index 0000000..ab6551e
--- /dev/null
@@ -0,0 +1 @@
+INSERT INTO coreinfo (key, value) VALUES ('schemaversion', '9')
diff --git a/src/core/SQL/SQLite/9/upgrade_000_create_backlog_idx.sql b/src/core/SQL/SQLite/9/upgrade_000_create_backlog_idx.sql
new file mode 100644 (file)
index 0000000..a91b59a
--- /dev/null
@@ -0,0 +1 @@
+CREATE INDEX backlog_bufferid_idx ON backlog(bufferid)
diff --git a/src/core/SQL/SQLite/9/upgrade_010_create_backlog_idx2.sql b/src/core/SQL/SQLite/9/upgrade_010_create_backlog_idx2.sql
new file mode 100644 (file)
index 0000000..b515624
--- /dev/null
@@ -0,0 +1 @@
+CREATE INDEX backlog_buffer_time_idx ON backlog (bufferid, time)
diff --git a/src/core/SQL/SQLite/9/upgrade_020_create_buffer_idx.sql b/src/core/SQL/SQLite/9/upgrade_020_create_buffer_idx.sql
new file mode 100644 (file)
index 0000000..cb55f1d
--- /dev/null
@@ -0,0 +1 @@
+CREATE INDEX buffer_user_idx ON buffer(userid)
diff --git a/src/core/SQL/SQLite/9/upgrade_999_version.sql b/src/core/SQL/SQLite/9/upgrade_999_version.sql
new file mode 100644 (file)
index 0000000..bdeb8fe
--- /dev/null
@@ -0,0 +1,3 @@
+UPDATE coreinfo
+SET value = '9'
+WHERE key = 'schemaversion'
index d9fdf79..4ee7731 100644 (file)
@@ -5,7 +5,7 @@
 
   quasselVersion = "0.2.0-alpha3-pre";
   quasselDate = "2008-03-02";
-  quasselBuild = 609;
+  quasselBuild = 610;
 
   //! Minimum client build number the core needs
   clientBuildNeeded = 605;