SQLite FTS3 and FTS4 Extensions
(fts3.html)
Overview
... Users input a term, or series
of terms, perhaps connected by a binary operator or grouped together into a
phrase, and the full-text query system finds the set of documents that best
matches those terms considering the operators and ...
|
35% Faster Than The Filesystem
(fasterthanfs.html)
2. How These Measurements Are Made
... This
option proves, yet again, that to get the most performance out of
SQLite, you should group as much database interaction as possible within
a single transaction.
There are many other testing options, which can be seen by running
the ...
|
SQLite As An Application File Format
(appfileformat.html)
... SQLite is transactional, meaning that multiple changes can be grouped
together such that either all or none of them occur, and so that the
changes can be rolled back if a problem is found prior to commit.
This allows an ...
|
Many Small Queries Are Efficient In SQLite
(np1queryprob.html)
4. The Need For Over 200 SQL Statements Per Webpage
... The first group of queries in the log are extracting display options
from the "config" and "global_config" tables of the Fossil database.
Then there is a single complex query that extracts a list of all elements
to be displayed on ...
|
SQLite Older News
(oldnews.html)
... This release also includes a new sorter that is able to use multiple
threads to help with large sort operations. (Sort operations are
sometimes required to implement ORDER BY and/or GROUP BY clauses and
are almost always required for ...
|
SQLite Frequently Asked Questions
(faq.html)
... But if you
surround multiple INSERT statements with BEGIN...COMMIT then all the
inserts are grouped into a single transaction. The time needed to commit
the transaction is amortized over all the enclosed insert statements and
so the time per ...
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.3. The xBestIndex Method
... This information
derives mainly from the WHERE clause and ORDER BY or GROUP BY clauses
of the query, but also from any ON or USING clauses if the query is a
join. The information that the SQLite core provides to ...
|
The Virtual Database Engine of SQLite
(vdbe.html)
... This template will be expanded considerably as we consider
additional complications such as joins, compound selects, using
indices to speed the search, sorting, and aggregate functions
with and without GROUP BY and HAVING clauses.
But the same basic ideas will ...
|
SQLite Changes From Version 3.4.2 To 3.5.0
(34to35.html)
... An SQLITE_OPEN_TRANSIENT_DB holds a database table that
SQLite creates automatically in order to evaluate a subquery or
ORDER BY or GROUP BY clause. Both TEMP_DB and TRANSIENT_DB databases
are private and are deleted automatically. TEMP_DB databases last
for the duration ...
|
The Tcl interface to the SQLite library
(tclsqlite.html)
... The transaction command can be used to group together several SQLite
commands in a safe way. You can always start transactions manually using
BEGIN, of
course. But if an error occurs so that the COMMIT or ROLLBACK are never
run ...
|
Page generated by FTS5 in about 43.23 ms.