, and then queried and interrogated multiple
times. So I am most concerned with read speed and not with writing or
updating.
On Wed, Aug 7, 2013 at 6:44 PM, Richard Hipp d...@sqlite.org wrote:
On Wed, Aug 7, 2013 at 2:54 PM, Christopher W. Steenwyk
csteen...@gmail.com
wrote:
Hi,
I
I just uploaded the output from sqlite3_analyze to dropbox.
On Thu, Aug 8, 2013 at 9:40 AM, Christopher W. Steenwyk csteen...@gmail.com
wrote:
Here is the data from stat1:
tbl, idx, stat
metrics, metrics_idx, 68682102 2 2 2
metrics, metrics_frame_idx, 68682102 2
metrics
Hi,
I have been working on a large database and its queries now for several
weeks and just can't figure out why my query is so slow. I've attached the
schema, my query, and the results of EXPLAIN QUERY from sqliteman.
A few notes about this database:
Its approximately 10GB in size, but I have it
...@gmail.comwrote:
On Aug 7, 2013, at 8:54 PM, Christopher W. Steenwyk csteen...@gmail.com
wrote:
The attached query takes over 6 days to run.
“Patience – A minor form of despair, disguised as a virtue.”
Also… attachments are stripped out by the mailing list. You may want to
try to inline them
Hi,
I have been struggling with a problem and was hoping I could get some
insight.
I have a rather large database (11 GB) that has two tables (one with
approximately 500,000 rows and another with approximately 50,000,000 rows).
In this database I am performing a query that joins these two
(*) from parte;
62468241
CPU Time: user 33.214076 sys 2.160135
sqlite select count(*) from parte where nome match 'castelo';
3834
CPU Time: user 0.004000 sys 0.00
good luck... :)
t+
On Fri, Jun 28, 2013 at 9:54 AM, Christopher W. Steenwyk
csteen...@gmail.com wrote:
Hi,
I
