• Adrian Negreanu's avatar
    sqlite3: speedup the SELECTs · d7f9bbed
    Adrian Negreanu authored
    The uniqueness of rows is maintained by first doing a select.
    In case the item is not found, it's INSERTed.
    
    This is done for files, refids, params and includes, data
    that is not unique by itself, like cross-references for example.
    In other words, you can have many memberdefs in one file,
    but you can only have one cross-reference between two functions
    since the reference location is unique.
    
    So, when SELECTing files and refids, use the file name and refids
    as primary key since that's the fastest way to do it.
    
    Also 'OR REPLACE' not necessary in 'INSERT OR REPLACE'.
    Signed-off-by: 's avatarAdrian Negreanu <adrian.m.negreanu@intel.com>
    d7f9bbed
Name
Last commit
Last update
addon Loading commit data...
doc Loading commit data...
examples Loading commit data...
jquery Loading commit data...
libmd5 Loading commit data...
packages/rpm Loading commit data...
qtools Loading commit data...
src Loading commit data...
testing Loading commit data...
tmake Loading commit data...
winbuild Loading commit data...
.gitignore Loading commit data...
.travis.yml Loading commit data...
Doxyfile Loading commit data...
INSTALL Loading commit data...
LANGUAGE.HOWTO Loading commit data...
LICENSE Loading commit data...
Makefile.in Loading commit data...
Makefile.win_make.in Loading commit data...
Makefile.win_nmake.in Loading commit data...
PLATFORMS Loading commit data...
README.md Loading commit data...
configure Loading commit data...
configure.bin Loading commit data...