Re: [sqlite] sqlite puzzle

[JP]

Thanks all.  Actually I was just looking for the position of a single 
name.  Based on your feedback, this one works to get the results:

SELECT count(*) FROM clients WHERE name<'foo';
but its performance is directly proportional to the position of the name 
in the table.  For example, searching for Zach takes longer than 
searching for Abigail.  It seems it is not using any index, but rather 
doing a record by record sweep on the 'count'.

jp