Confirmed users
764
edits
Firefox/Projects/Places DB Creation Scripts: Difference between revisions
Firefox/Projects/Places DB Creation Scripts (view source)
Revision as of 20:05, 25 February 2009
, 25 February 2009→Design
(→Design) |
(→Design) |
||
| Line 45: | Line 45: | ||
* http://mxr.mozilla.org/mozilla-central/source/toolkit/components/places/src/nsNavHistoryAutoComplete.cpp | * http://mxr.mozilla.org/mozilla-central/source/toolkit/components/places/src/nsNavHistoryAutoComplete.cpp | ||
** GetAutoCompleteBaseQuery() | ** GetAutoCompleteBaseQuery() http://mxr.mozilla.org/mozilla-central/source/toolkit/components/places/src/nsNavHistoryAutoComplete.cpp#190 | ||
** see BOOK_TAG_SQL - having a lot of tags will slow stuff down, however that might not be representative of "normal users" | ** see BOOK_TAG_SQL - having a lot of tags will slow stuff down, however that might not be representative of "normal users": http://mxr.mozilla.org/mozilla-central/source/toolkit/components/places/src/nsNavHistoryAutoComplete.cpp#109 | ||
** mDBAdaptiveQuery | ** mDBAdaptiveQuery http://mxr.mozilla.org/mozilla-central/source/toolkit/components/places/src/nsNavHistoryAutoComplete.cpp#485 | ||
** mDBKeywordQuery | ** mDBKeywordQuery http://mxr.mozilla.org/mozilla-central/source/toolkit/components/places/src/nsNavHistoryAutoComplete.cpp#507 | ||
** AutoCompleteProcessSearch() | ** AutoCompleteProcessSearch() http://mxr.mozilla.org/mozilla-central/source/toolkit/components/places/src/nsNavHistoryAutoComplete.cpp#1000 | ||
* This file (or these queries at least) are being rewritten in JS: see _processRow() in https://bug455555.bugzilla.mozilla.org/attachment.cgi?id=363641 | * This file (or these queries at least) are being rewritten in JS: see _processRow() in https://bug455555.bugzilla.mozilla.org/attachment.cgi?id=363641 | ||
Some notes on the above funcs and SQL: | Some notes on the above funcs and SQL: | ||
* GetAutoCompleteBaseQuery() is from table moz_places(_temp) x moz_favicons; where frecency != 0 | * GetAutoCompleteBaseQuery() is from table moz_places(_temp) x moz_favicons; where frecency != 0; orders by column 9 (guessing this is frecency column...) | ||
* BOOK_TAG_SQL defined in terms of SQL_STR_FRAGMENT_GET_BOOK_TAG http://mxr.mozilla.org/mozilla-central/source/toolkit/components/places/src/nsNavHistoryAutoComplete.cpp#94 | |||
* mDBAdaptiveQuery uses moz_inputhistory | |||
--- | --- | ||