6327f6e56fb4615024546cae265f117c2c151320 tdreszer Fri May 31 17:27:33 2013 -0700 Three changes to attempt to recover from mysql performace degradation (ref #10910). 1. Added index to val. 2. Replaced subqueries with joins. 3. Replaced ORDER BY query with in code sort. diff --git src/hg/lib/metaDb.as src/hg/lib/metaDb.as index 81358ba..64d57aa 100644 --- src/hg/lib/metaDb.as +++ src/hg/lib/metaDb.as @@ -1,8 +1,7 @@ table metaDb "This contains metadata for a table, file or other predeclared object type." ( string obj; "Object name or ID." string var; "Metadata variable name." -string varType; "txt | binary" -lstring val; "Metadata value." +string val; "Metadata value." )