comparison 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
comparison
equal deleted inserted replaced
3857:54c10d188b8b 3858:bb30bbfc7cdd
29 return 29 return
30 30
31 - summary, content = parseContent(newvalues['content'], 1, 1) 31 - summary, content = parseContent(newvalues['content'], 1, 1)
32 + summary, content = parseContent(newvalues['content'], config=db.config) 32 + summary, content = parseContent(newvalues['content'], config=db.config)
33 newvalues['summary'] = summary 33 newvalues['summary'] = summary
34
35 In the latest version we have added some database indexes to the
36 SQL-backends (mysql, postgresql, sqlite) for speeding up building the
37 roundup-index for full-text search. We recommend that you create the
38 following database indexes on the database by hand::
39
40 CREATE INDEX words_by_id ON __words (_textid)
41 CREATE UNIQUE INDEX __textids_by_props ON __textids (_class, _itemid, _prop)
34 42
35 Migrating from 1.2.x to 1.3.0 43 Migrating from 1.2.x to 1.3.0
36 ============================= 44 =============================
37 45
38 1.3.0 Web interface changes 46 1.3.0 Web interface changes

Roundup Issue Tracker: http://roundup-tracker.org/