Re[2]: Upgraded to SLIDE_1_0 - Poor Performance

[Lukasz Kowalczyk <lu...@jazzpolice.pl>]

Wednesday, September 11, 2002, 10:24:33 AM, you wrote:

LZ> Hi,
LZ> about performance in a JDBC Store, I wonder if a possible solution could be 
LZ> to put
LZ> some index or primary Key in the tabels.
LZ> For example  huge tables like Object or Property has no Primary Key.
LZ> has somebody considered this way?

I added a few indexes to my database and it looks like performance
went up (I didn't do any timing tests yet). SQL for indexes is
included below (postgresql).

create index idx_rc_uri_xnumber on revisioncontent (uri, xnumber);
create index idx_obj_uri on objects (uri);
create index idx_chld_uri on children (uri);
create index idx_lnks_linkto on links (linkto);
create index idx_lnks_link on links (link);
create index idx_perm_osar on permissions (object, subject, action, revisionnumber);
create index idx_perm_obj on permissions (object);
create index idx_lcks_id on locks (id);
create index idx_lcks_obj on locks (object);
create index idx_revs_uri on revisions (uri);
create index idx_wrkrev_uri on workingrevision (uri);
create index idx_ltstrev_uri on latestrevisions (uri);
create index idx_rev_uri on revision (uri);
create index idx_rev_uri_xnumber on revision (uri, xnumber);
create index idx_brnch_uri_xnumber on branches (uri, xnumber);
create index idx_lbl_uri_xnumber on label (uri, xnumber);
create index idx_prop_uri_xnumber on property (uri, xnumber);

-- 
Łukasz Kowalczyk


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>