Mercurial > pylearn
diff bin/dbdict-run-job @ 645:d8af9c8a4bbb
Changed database schema to be more efficient:
* got rid of link table
* use indexes for keyval.name, and for ids used in LEFT OUTER JOIN statement
(keyval.dict_id and trial.id)
* rewrote sql code for view (much simpler now!) to join on the foreign key
Validated that the results are the same as the icml09 results.
TODO: port icml09 & test4 results to "icml09full" table under the current schema
author | desjagui@atchoum.iro.umontreal.ca |
---|---|
date | Mon, 02 Feb 2009 17:41:54 -0500 |
parents | 798607a058bd |
children |