Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#1 Speed up mysql performance

Bugfix
closed-accepted
Malcolm Box
DB backends (8)
7
2001-05-23
2001-05-22
Malcolm Box
No

The following patch re-instates some indexes on the
mysql db schema that substantially speed up the ident
searches. While these will slow genxref a little, it's
unlikely to seriously impact the time.

--- initdb-mysql Tue Sep 5 04:26:27 2000
+++ /home/malcolm/lxr/initdb-mysql Mon Apr 2
17:24:41 2001
@@ -50,8 +50,8 @@
);

-/* create index indexindex on indexes (symid) */
-/* create unique index symbolindex on symbols
(symname) */
-/* create index useageindex on useage (symid) */
+create index indexindex on indexes (symid)
+create index useageindex on useage (symid)
+create unique index symname on symbols (symname)

grant all on lxr.* to lxr@localhost;

Discussion

  • Malcolm Box
    Malcolm Box
    2001-05-23

    • status: open --> closed-accepted
     
  • Malcolm Box
    Malcolm Box
    2001-05-23

    Logged In: YES
    user_id=215386

    Patch applied to CVS