On 17 Mar 2017, at 5:30pm, Rob Willett <rob.sql...@robertwillett.com> wrote:

> echo "select * from Disruptions where status = 2 OR status = 6;" | sqlite3 
> tfl.sqlite > /dev/null
> twice and each run as 12 mins. So we were twice as quick, which is nice.

Do you actually need all columns ?  If not, then specifying the columns you 
need can lead to a further speedup.  It might be enough just to specify the 
columns you need, but you can achieve further increases in speed by making a 
covering index.  If speed for this SELECT is sufficiently important to you, and 
you don’t actually need all columns, post again and we’ll explain further.

sqlite-users mailing list

Reply via email to