git.annexia.org / cocanwiki.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: e674574) | patch
Added indexes to improve some selected common queries:
authorrich <rich>
Sat, 6 Nov 2004 16:34:25 +0000 (16:34 +0000)
committerrich <rich>
Sat, 6 Nov 2004 16:34:25 +0000 (16:34 +0000)
commit0986edd14961667f2aa0d3eca1f54562c6df9a6f
treebb10969a4ef2ca853eaa85e890e052a7cc516456tree | snapshot
parente674574406e733d9fbd2a1de9c07ed35cbb3aa85commit | diff
Added indexes to improve some selected common queries:

* usercookies_cookie_idx is used when locating the logged in user from
  their cookie (once per page if a user is logged in)

* pages_lc_title is used when looking up the URL for a link from the
  title, many times per page for some large pages.  This dramatically
  improves the performance of the front page of wiki.merjis.com

Also, hostnams_name_uq (typo) corrected to hostnames_name_uq.
cocanwiki.sql diff | blob | history
OCaml wiki software