Differences between revisions 2 and 3
Revision 2 as of 2004-11-15 14:20:24
Size: 643
Editor: dslcustomer
Comment: fix external link
Revision 3 as of 2009-09-20 22:02:35
Size: 645
Editor: localhost
Comment: converted to 1.6 markup
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
The [http://jakarta.apache.org/slide/howto-j2eestore.html JDBC Howto] on the official site explains how The [[http://jakarta.apache.org/slide/howto-j2eestore.html|JDBC Howto]] on the official site explains how

The JDBC Howto on the official site explains how to setup the database. However it does not describe, how to tune it.

At least, you should create indices on some SQL tables. For Postgres these SQL statements can be used:

CREATE INDEX children_uri ON children(uri);
CREATE INDEX latestrevisions_uri ON latestrevisions(uri);
CREATE INDEX links_to ON links(linkto);
CREATE INDEX links_from ON links(link); 
CREATE INDEX permissions_object ON permissions(object);
CREATE INDEX revision_uri ON revision(uri);
CREATE INDEX property_revision ON property(uri,xnumber);

JdbcStoreSetup (last edited 2009-09-20 22:02:35 by localhost)