On 17/10/2011, at 8:33 PM, Nick Gammon wrote:

> ...

> The following SQL:
> 
> ...

>  SELECT * FROM exits WHERE fromuid = '2E515665758C87202B281C7FC';
> --------
> 
> Takes over 2 seconds to execute (in particular, the SELECT statement).
> 

Further to the above, changing the column type from STRING to TEXT also fixes 
it.

However isn't over 2 seconds a bit much for evaluating a number, regardless of 
the column type?

- Nick

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to