comanage-dev - [comanage-dev] CO693 - Navigation Links Table Definitions
Subject: COmanage Developers List
List archive
- 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
- [comanage-dev] CO693 - Navigation Links Table Definitions, Marie Huynh, 09/18/2013
- [comanage-dev] Re: CO693 - Navigation Links Table Definitions, Benn Oshrin, 09/18/2013
- [comanage-dev] Re: CO693 - Navigation Links Table Definitions, Marie Huynh, 09/18/2013
- [comanage-dev] Re: CO693 - Navigation Links Table Definitions, Benn Oshrin, 09/18/2013
- [comanage-dev] Re: CO693 - Navigation Links Table Definitions, Marie Huynh, 09/18/2013
- [comanage-dev] Re: CO693 - Navigation Links Table Definitions, Benn Oshrin, 09/18/2013
Archive powered by MHonArc 2.6.16.