Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Session Module C/C++ Interface
(session.html)
... As with the output of the sqlite3session_changeset() and
sqlite3session_patchset() functions, all changes related to a single
table are grouped together in the output of this function. Tables appear
in the same order as for the very first changeset added to ...
|
|
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 ...
|
|
The Next-Generation Query Planner
(queryplanner-ng.html)
3.2. Complications
... If the query contains an ORDER BY clause or a GROUP BY clause or if
the query uses the DISTINCT keyword then it is advantageous to select a
path through the graph that causes rows to naturally appear in sorted ...
|
|
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 ...
|
Page generated by FTS5 in about 68.68 ms.