From: Sam H. v. a. <we...@ma...> - 2007-08-25 18:30:40
|
Log Message: ----------- backport (jj): Add more indexing, small disk space expense and hopefully more speed. Tags: ---- rel-2-4-dev Modified Files: -------------- webwork2/bin: NPL-update Revision Data ------------- Index: NPL-update =================================================================== RCS file: /webwork/cvs/system/webwork2/bin/NPL-update,v retrieving revision 1.1.2.3 retrieving revision 1.1.2.4 diff -Lbin/NPL-update -Lbin/NPL-update -u -r1.1.2.3 -r1.1.2.4 --- bin/NPL-update +++ bin/NPL-update @@ -102,6 +102,8 @@ number int(3), name varchar(127) NOT NULL, page int(4), + KEY (textbook_id, name), + KEY (number), PRIMARY KEY (chapter_id) '], ['NPL-section', ' @@ -110,6 +112,8 @@ number int(3), name varchar(127) NOT NULL, page int(4), + KEY (chapter_id, name), + KEY (number), PRIMARY KEY section (section_id) '], ['NPL-problem', ' |