Look at COLLATE in the ORDER BY clause.
Gerry
On Mar 25, 2014 11:32 AM, "michal.pilszak" wrote:
> "you cannot tell SQLite to use a particular algorithm to do those things"
> that's exactly what I wanted to know. So, I won't waste my time on looking
> for impossible on Internet. Thank you for thi
"you cannot tell SQLite to use a particular algorithm to do those things"
that's exactly what I wanted to know. So, I won't waste my time on looking for
impossible on Internet. Thank you for this answear. And thank you for
suggestion with ANALYZE command. This maybe be useful. I'll try to get fa
On 25 Mar 2014, at 5:48pm, michal.pilszak wrote:
> Is there any parameter I can set to select another algorithm (e.g. another
> algorithm of ORDER BY) and check its efficiency?
You can tell SQLite to search for different rows or order them in a different
order. But you cannot tell SQLite to
I see my second question is not constructed well. I forgot one word at the end
of phrase.
Let me repeat: 2. Secondly, I'm using SQLite in my Android app, and I was
wondering is there any (easy) way to select a different type of sorting or
searching ALGORITHM?
I know there are "ORDER BY" constru
On 25 Mar 2014, at 4:02pm, michal.pilszak wrote:
> Hello, I've got a few questions: 1. Firstly, I was wondering what are the
> types of sorting and searching algorithms used in SQLite?2. Secondly, I'm
> using SQLite in my Android app, and I was wondering is there any (easy) way
> to select a
Hello, I've got a few questions: 1. Firstly, I was wondering what are the types
of sorting and searching algorithms used in SQLite?2. Secondly, I'm using
SQLite in my Android app, and I was wondering is there any (easy) way to select
a different type of sorting or searching?
--
Greets, MP.
_
6 matches
Mail list logo