-
Committer:
Markus Korn
-
Date:
2010-11-16 20:10:35 UTC
-
mfrom:
(1628.1.10 db_schema_3)
-
Revision ID:
thekorn@gmx.de-20101116201035-b2l5km5jeg5emiqr
This branch introduces a new db schema (version 3) and bundles a few
performance related fixes:
* renamed event_view.subj_origin to event_view.subj_origin_uri and
event_view.subj_origin_id to event_view.subj_origin, this makes
"subj_origin" point to an id in the uri table, and "subj_origin_uri" the
resolved value. Also we are not using the redundant "SELECT id FROM uri
WHERE uri.id=event.subj_origin" query anymore. (LP: #673452)
* removed event_view.subj_uri_id and added event.subj_id, both values are
in fact the same, but we again sting on another "SELECT" query in the
event_view.
* Optimization in FindEvent queries: we are not ordering and grouping by
resolved values anymore, we are doing it on integer ids, which is much
faster (LP: #673394)