]project-open[ : @This Wiki
Portrait

Welcome, Unregistered Visitor

Contact ·  Index · Login · Register
 

Contents

Remote Training
Support
SaaS Service

6 registered users
 in last 24 hours

]po[ Full-Text Search Tables

The ]po[ Full-Text Search Engine allows searching all important ]po[ objects for key words, considering the application specific permissions for each object type.

The ]po[ FTI delivers results within fractions of seconds (and permissions filtered results in very few seconds) thanks to the use of the PostgreSQL Full-Text Search Index.

 

­

Table

Cols

Rows

Description

[im_search_object_types]

3

7

Maintains a list of the object types indexed. This table is different from acs_object_types, because the ]po[ FTI can index objects that are not instances of OpenACS object.

[im_search_objects]

7

1030

Maintains a Full-Text Index for the text representation of every important object in ]po[. This table is kept up to date using triggers on each indexed object's tables.

[im_search_pg_file_biz_objects]

2

1912

Auxillary table for indexing file storage files. The table maintains the date of the last update of each file storage file. This is necessary, because re-indexing file storage files is an expensive operation that can considerably slow down overall system performance.


Please take a moment to complete this form to help us improve our service.

Note:
Please only provide feedback in regards to content this page shows. For support inquiries please refer either to the Community Support forum at Sourceforge or check out our 'Professional Support'

Did this page help you to achieve your goal?

 Yes  No  Don't know

Please provide us with comments to improve this page:

How useful is the information?

 1  2  3  4  5
Not
useful
      Extremely
useful
 
  

Explore

Installers
Demo Server
Modules & Functionality
Packages
Business Processes supported
FAQ's

Help

Getting started
User Manuals
Configuration Manuals
Community Support
Professional Support

News

News
Twitter
RSS Community / Sourceforge
Register for Newsletter

Get in touch

Contact
Register



Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 2.0 Generic License - Privacy Policy