Mercurial > p > roundup > code
comparison roundup/backends/back_sqlite.py @ 3858:bb30bbfc7cdd
Indexing fixes.
- Add new rdbms-indexes to the tables for the full-text index. These
speed up adding new entries and finding old ones to remove.
- Remove getprops method from FileClass in backends/rdbms_common: This
forced indexing for the content property even if the user decided to
turn it off for a FileClass instance.
| author | Ralf Schlatterbeck <schlatterbeck@users.sourceforge.net> |
|---|---|
| date | Thu, 21 Jun 2007 07:35:51 +0000 |
| parents | f5ddd1639a15 |
| children | 59d02edfaa9c |
comparison
equal
deleted
inserted
replaced
| 3857:54c10d188b8b | 3858:bb30bbfc7cdd |
|---|---|
| 1 # $Id: back_sqlite.py,v 1.50 2006-12-19 03:01:37 richard Exp $ | 1 # $Id: back_sqlite.py,v 1.51 2007-06-21 07:35:50 schlatterbeck Exp $ |
| 2 '''Implements a backend for SQLite. | 2 '''Implements a backend for SQLite. |
| 3 | 3 |
| 4 See https://pysqlite.sourceforge.net/ for pysqlite info | 4 See https://pysqlite.sourceforge.net/ for pysqlite info |
| 5 | 5 |
| 6 | 6 |
| 142 self.sql('CREATE TABLE __textids (_class varchar, ' | 142 self.sql('CREATE TABLE __textids (_class varchar, ' |
| 143 '_itemid varchar, _prop varchar, _textid integer primary key) ') | 143 '_itemid varchar, _prop varchar, _textid integer primary key) ') |
| 144 self.sql('CREATE TABLE __words (_word varchar, ' | 144 self.sql('CREATE TABLE __words (_word varchar, ' |
| 145 '_textid integer)') | 145 '_textid integer)') |
| 146 self.sql('CREATE INDEX words_word_ids ON __words(_word)') | 146 self.sql('CREATE INDEX words_word_ids ON __words(_word)') |
| 147 self.sql('CREATE INDEX words_by_id ON __words (_textid)') | |
| 148 self.sql('CREATE UNIQUE INDEX __textids_by_props ON ' | |
| 149 '__textids (_class, _itemid, _prop)') | |
| 147 sql = 'insert into ids (name, num) values (%s,%s)'%(self.arg, self.arg) | 150 sql = 'insert into ids (name, num) values (%s,%s)'%(self.arg, self.arg) |
| 148 self.sql(sql, ('__textids', 1)) | 151 self.sql(sql, ('__textids', 1)) |
| 149 | 152 |
| 150 def add_new_columns_v2(self): | 153 def add_new_columns_v2(self): |
| 151 # update existing tables to have the new actor column | 154 # update existing tables to have the new actor column |