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', '
|
