Mercurial > p > roundup > code
diff doc/upgrading.txt @ 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 | 99bd1d59a58e |
| children | 083e280165a8 |
line wrap: on
line diff
--- a/doc/upgrading.txt Wed May 16 09:42:36 2007 +0000 +++ b/doc/upgrading.txt Thu Jun 21 07:35:51 2007 +0000 @@ -32,6 +32,14 @@ + summary, content = parseContent(newvalues['content'], config=db.config) newvalues['summary'] = summary +In the latest version we have added some database indexes to the +SQL-backends (mysql, postgresql, sqlite) for speeding up building the +roundup-index for full-text search. We recommend that you create the +following database indexes on the database by hand:: + + CREATE INDEX words_by_id ON __words (_textid) + CREATE UNIQUE INDEX __textids_by_props ON __textids (_class, _itemid, _prop) + Migrating from 1.2.x to 1.3.0 =============================