Re: [sqlite] SQLite sorting/searching algorithm

[Gerry Snyder]

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 this answear. And thank you for
> suggestion with ANALYZE command. This maybe be useful. I'll try to get
> familiar with it and use it when/if I'll have some time.
> Dnia 25 marca 2014 18:55 Simon Slavin 
> napisał(a):
> 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 use a particular algorithm
> to do those things. SQLite decides how to obey your instructions itself.
> The best thing you can do is to CREATE an INDEX ideally suited to your
> SELECT command.
> If your database is large and you are concerned about how long your
> operations may take you might like to execute the ANALYZE command after you
> have INSERTed your data in the database and CREATEd your INDEX(es):
> ;
> Hope this helps.
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> --
> Pozdrawiam, MP.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite sorting/searching algorithm

[michal . pilszak]

"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 familiar 
with it and use it when/if I'll have some time.
Dnia 25 marca 2014 18:55 Simon Slavin  napisał(a):
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 use a particular algorithm to do those 
things. SQLite decides how to obey your instructions itself. The best thing you 
can do is to CREATE an INDEX ideally suited to your SELECT command.
If your database is large and you are concerned about how long your operations 
may take you might like to execute the ANALYZE command after you have INSERTed 
your data in the database and CREATEd your INDEX(es):
;
Hope this helps.
Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Pozdrawiam, MP.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite sorting/searching algorithm

[Simon Slavin]

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 use a particular algorithm to do those 
things.  SQLite decides how to obey your instructions itself.  The best thing 
you can do is to CREATE an INDEX ideally suited to your SELECT command.

If your database is large and you are concerned about how long your operations 
may take you might like to execute the ANALYZE command after you have INSERTed 
your data in the database and CREATEd your INDEX(es):



Hope this helps.

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

Re: [sqlite] SQLite sorting/searching algorithm

[michal . pilszak]

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" constructions, "WHERE", and others. I admit I don't 
know them well, just enough to use them once in my app.But my real question is 
about the algorithm. Is there any parameter I can set to select another 
algorithm (e.g. another algorithm of ORDER BY) and check its efficiency?
Thank you for your reply.  
Dnia 25 marca 2014 17:20 Simon Slavin  napisał(a):
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 different type of sorting or searching?
SQLite implements most of the SQL92 language for dealing with databases. Any 
book or web page aimed at SQL beginners will start you off learning enough 
about what's possible to answer both of those questions.
If you have a specific question about how a particular SQL capability is 
implemented, don't hesitate to post again.
Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Pozdrawiam, MP.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite sorting/searching algorithm

[Simon Slavin]

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 different type of sorting or searching?

SQLite implements most of the SQL92 language for dealing with databases.  Any 
book or web page aimed at SQL beginners will start you off learning enough 
about what's possible to answer both of those questions.

If you have a specific question about how a particular SQL capability is 
implemented, don't hesitate to post again.

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

[sqlite] SQLite sorting/searching algorithm

[michal . pilszak]

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.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users