Queries where there is a glob comparison on a string that could be
interpreted as a number always seem a bit slower than when comparing to a
string that can't be compared to a number.

So for example:
select f from t where f glob '137*'
is slower than:
select f from t where f glob 'abc*'

Is this there any explanation for this and is there any way round it?
Or can SQLite not be to blame here and is it something in my wrapper?

RBS



-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to