Small. Fast. Reliable.
Choose any three.

Search results 21..30 of 38 for: Group

Books About SQLite
(books.html)
 ... databases aren't just for the IS group any more. You can build database-backed applications for the desktop, Web, embedded systems, or operating systems without linking to heavy-duty client-server databases such as Oracle and MySQL. This book ... 
Row Values
(rowvalue.html)
3.5. Clarity of presentation  ... But the second form is made easier for humans to read by grouping the query parameters together into a single row value rather than scattering them across the WHERE clause.
The SQLite Zipfile Module
(zipfile.html)
3.1. Table-Valued Function (read-only access)  ... This identifies the type of record (file, directory or symbolic link), and the associated user/group/all permissions. mtime UTC timestamp, in seconds since the UNIX epoch (an integer). sz Size of associated data in bytes after it has been ... 
 ... 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 ... 
 ... statement The number of columns in the result set of a SELECT statement The number of terms in a GROUP BY or ORDER BY clause The number of values in an INSERT statement The default setting for SQLITE_MAX_COLUMN is 2000 ... 
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 ... 
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 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 ... 
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 ... 

1234

Page generated by FTS5 in about 68.55 ms.