gunnar wrote: > the sqlite client is stuck with the following stack traces
According to these stack traces, the client is not stuck but is busy searching and reading data from the database. What is the EXPLAIN QUERY PLAN output for this query? > Disk is not busy And the CPU? Regards, Clemens