• David Keeler's avatar
    Bug 1363569 - improve SQL queries in sdb_FindObjects* r=franziskus · 135560d2
    David Keeler authored
    Summary:
    When sqlite prepares statements, it appears to have an algorithm which is
    O(n * m), where n is the number of columns in the table and m is the number of
    columns selected in the query. Since the certificate database has about 115
    columns, when "SELECT * FROM ..." is used, it introduces significant overhead.
    Since sdb_FindObjects only uses the id column of the results of the query, the
    queries in sdb_FindObjectsInit can be changed to select only the id column
    rather than all of them.
    
    Reviewers: franziskus
    
    Reviewed By: franziskus
    
    Differential Revision: https://nss-review.dev.mozaws.net/D314
    
    --HG--
    extra : rebase_source : ed5bf33591d406b5dc062dc624a7d1bc3f018940
    extra : amend_source : aa310794fb10d253f4cd24c98799969e5ff9e98c
    135560d2
Name
Last commit
Last update
automation Loading commit data...
cmd Loading commit data...
coreconf Loading commit data...
cpputil Loading commit data...
doc Loading commit data...
fuzz Loading commit data...
gtests Loading commit data...
lib Loading commit data...
nss-tool Loading commit data...
pkg Loading commit data...
tests Loading commit data...
.clang-format Loading commit data...
.gitignore Loading commit data...
.hgignore Loading commit data...
.hgtags Loading commit data...
.taskcluster.yml Loading commit data...
COPYING Loading commit data...
Makefile Loading commit data...
build.sh Loading commit data...
exports.gyp Loading commit data...
help.txt Loading commit data...
manifest.mn Loading commit data...
nss.gyp Loading commit data...
readme.md Loading commit data...
trademarks.txt Loading commit data...