Thread: [Lxr-commits] CVS: lxr initdb-mysql,1.5,1.6 initdb-postgres,1.2,1.3
Brought to you by:
ajlittoz
From: Malcolm B. <mb...@us...> - 2001-09-26 14:47:59
|
Update of /cvsroot/lxr/lxr In directory usw-pr-cvs1:/tmp/cvs-serv28284 Modified Files: initdb-mysql initdb-postgres Log Message: Dramatically speed up (>50 times) the speed of incremental indexing by creating an index to allow the fileid to be looked up fast from the filename. Ideally this index would include the revision as well, but this is not possible in MySQL because of limits (500 chars) on the index key. Tested on MySQL, but not on postgres. Fixes bug 465131 Index: initdb-mysql =================================================================== RCS file: /cvsroot/lxr/lxr/initdb-mysql,v retrieving revision 1.5 retrieving revision 1.6 diff -u -d -r1.5 -r1.6 --- initdb-mysql 2001/07/26 08:49:38 1.5 +++ initdb-mysql 2001/09/26 14:47:56 1.6 @@ -45,7 +45,7 @@ create table status (fileid int not null references files, - status int, + status tinyint not null, primary key (fileid) ); @@ -53,5 +53,6 @@ create index indexindex on indexes (symid) ; create unique index symbolindex on symbols (symname) ; create index useageindex on useage (symid) ; +create index filelookup on files (filename); grant all on lxr.* to lxr@localhost; Index: initdb-postgres =================================================================== RCS file: /cvsroot/lxr/lxr/initdb-postgres,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 --- initdb-postgres 2001/07/26 08:49:38 1.2 +++ initdb-postgres 2001/09/26 14:47:56 1.3 @@ -56,6 +56,7 @@ create index indexindex on indexes using btree (symid); create index symbolindex on symbols using btree (symname); create index usageindex on usage using btree (symid); +create index filelookup on files using btree (filename); grant select on files to public; grant select on symbols to public; |