486 reputation
37
bio website
location Germany
age 37
visits member for 1 year, 10 months
seen 13 hours ago

 


Jul
28
comment Query executes fast, but keeps the table locked for some time
See the last two sentences of the first paragraph.
Jul
28
comment Improving `GROUP BY` query performance in sqlite3
With a scrolling cursor, the link would not have an offset value but the column value at which to continue.
Jul
26
comment Improving `GROUP BY` query performance in sqlite3
The current offset is state.
Jul
25
answered Improving `GROUP BY` query performance in sqlite3
Jul
10
answered Query executes fast, but keeps the table locked for some time
Jun
20
comment SQLite and Write Ahead Logging: why so large files
That's what VACUUM is for.
Jun
20
answered SQLite and Write Ahead Logging: why so large files
Jun
11
answered Create a result for a line chart with dates
Jun
10
comment Create a result for a line chart with dates
This is possible, but how do you know which dates to include in the output table?
May
22
answered Joining three tables
Apr
30
answered First time using an Index - SQLite / Android
Apr
29
comment First time using an Index - SQLite / Android
Why are you using LIKE instead of GLOB? Do you need case insensitivity?
Apr
4
comment Why does SQlite return incorrect sum?
SQLite does not have NUMERIC or DECIMAL data types.
Apr
3
answered EAV-like table with both primary column pointing to the same foreign column
Mar
7
comment select all rows with a minimum value
@ypercube CTEs, views, and subqueries are flattened or implemented as coroutines, if possible. But a GROUP BY on a non-indexed column must be able to collect the data for all groups in parallel, so it requires some form of temporary table (in all databases).
Mar
7
comment select all rows with a minimum value
When executed, the result of the u query is stored in a temporary table, regardless of whether it's written as a CTE, a view, or inline as a subquery.
Mar
7
revised select all rows with a minimum value
added 47 characters in body
Mar
7
answered select all rows with a minimum value
Mar
7
comment select all rows with a minimum value
This will return all four records, because the num2 values are unique.
Jan
14
comment Performance difference search on INT or TEXT in SQLite 3
That depends on the size and the access patterns of your database.