Skip to Content.
Sympa Menu

comanage-dev - [comanage-dev] CO693 - Navigation Links Table Definitions

Subject: COmanage Developers List

List archive

[comanage-dev] CO693 - Navigation Links Table Definitions


Chronological Thread 
  • From: Marie Huynh <>
  • To: Benn Oshrin <>, comanage-dev <>
  • Subject: [comanage-dev] CO693 - Navigation Links Table Definitions
  • Date: Wed, 18 Sep 2013 16:46:47 -0700

Is this what you mean?

Index: Config/Schema/schema.xml
===================================================================
--- Config/Schema/schema.xml (revision 606)
+++ Config/Schema/schema.xml (working copy)
@@ -911,8 +911,12 @@
     <field name="url" type="C" size="256" />
     <field name="ordr" type="I" />
     <field name="location" type="C" size="32" />
+    <field name="created" type="T" />
+    <field name="modified" type="T" />
     
-    <!-- XXX almost certainly need to create some indexes here -->
+    <index name="co_navigation_links_i1">
+      <col>co_id</col>
+    </index>
   </table>
 
   <table name="navigation_links">
@@ -927,7 +931,5 @@
     <field name="url" type="C" size="256" />
     <field name="ordr" type="I" />
     <field name="location" type="C" size="32" />
-    
-    <!-- XXX almost certainly need to create some indexes here -->


Every row of navigation_links is used for every page load so I expect the system to cache it in production and not need an index.  Does it not?  I also expect the co-level ones to be cached since they shouldn't change very often.

Marie



Archive powered by MHonArc 2.6.16.

Top of Page