subject:"\[sqlite\] Performance measurement"

Re: [sqlite] Performance measurement

2013-10-30 Thread Simon Slavin

On 30 Oct 2013, at 3:00am, RSmith wrote: > Secondly, A query that seemingly requires no sorting sometimes give quite a > large figure for the Sort-Ops, what is it about this that I am not > understanding? You may find that adding the information given by EXPLAIN QUERY

[sqlite] Performance measurement

2013-10-29 Thread RSmith

Hi all, I would like to gain more knowledge on the performance measurments and (more specifically) their possible implications and maybe some Database theory to boot. The figures of interest are the statement quantitative values which return simple counters such as Table scans, Virtual