diff options
author | Jamie McCracken <jamiemcc@src.gnome.org> | 2007-01-20 00:31:07 +0000 |
---|---|---|
committer | Jamie McCracken <jamiemcc@src.gnome.org> | 2007-01-20 00:31:07 +0000 |
commit | c72a8fdef1d668ed5df32fe92283acc5b2fc5235 (patch) | |
tree | 40ff569fdc5e18f1f5604707f46c4303402e756c | |
parent | 5c0428636e0ce179977c5073c80a1ddf990657a4 (diff) | |
download | tracker-c72a8fdef1d668ed5df32fe92283acc5b2fc5235.tar.gz |
updates
svn path=/trunk/; revision=403
-rw-r--r-- | ChangeLog | 10 | ||||
-rw-r--r-- | data/sqlite-stored-procs.sql | 2 | ||||
-rw-r--r-- | data/sqlite-tracker.sql | 2 |
3 files changed, 13 insertions, 1 deletions
@@ -1,3 +1,13 @@ +2007-01-19 Jamie McCracken <jamiemcc at gnome org> + + * changed mmap back to shared as optimisation would destroy the index + * made indexing super fast + * smoothed out indexing so that it (virtually) never slows the system down + * made default full throttle (turbo) + * Added new high speed index flusher + * Improved word descriminator + + 2007-01-14 Jamie McCracken <jamiemcc at gnome org> * added throttling param to control speed of indexing (--throttle) diff --git a/data/sqlite-stored-procs.sql b/data/sqlite-stored-procs.sql index 4684900b5..e6e6c948e 100644 --- a/data/sqlite-stored-procs.sql +++ b/data/sqlite-stored-procs.sql @@ -86,7 +86,7 @@ DeleteDirectory5 DELETE FROM ServiceMetaDataDisplay WHERE ServiceID in (select DeleteDirectory6 DELETE FROM ServiceNumericMetaData WHERE ServiceID in (select ID FROM Services F where (F.Path = ?) OR (F.Path glob ?)); DeleteDirectory7 DELETE FROM ServiceBlobMetaData WHERE ServiceID in (select ID FROM Services F where (F.Path = ?) OR (F.Path glob ?)); DeleteDirectory8 DELETE FROM ServiceMetaDataDisplay WHERE ServiceID in (select ID FROM Services F where (F.Path = ?) OR (F.Path glob ?)); -DeleteDirectory9 DELETE FROM ServiceWords WHERE ServiceID in (select ID FROM Services F where (F.Path = ?) OR (F.Path glob ?)); + SaveFileContents REPLACE into ServiceContents (ServiceID, Content, ContainsWordScores) values (?,?,?); DeleteFileContents DELETE FROM ServiceContents where ServiceID = ?; diff --git a/data/sqlite-tracker.sql b/data/sqlite-tracker.sql index 35ef18e28..70ae31743 100644 --- a/data/sqlite-tracker.sql +++ b/data/sqlite-tracker.sql @@ -542,3 +542,5 @@ CREATE TABLE VFolders primary key (Path, Name) ); + +ANALYZE; |