[sqlite] ASK SQLite algoritm to chose Index

2016-02-29 Thread Christoforus Surjoputro
ginal Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users- > bounces at mailinglists.sqlite.org] On Behalf Of Keith Medcalf > Sent: Sunday, 28 February, 2016 09:52 > To: SQLite mailing list > Subject: Re: [sqlite] ASK SQLite algoritm to chose

[sqlite] ASK SQLite algoritm to chose Index

2016-02-28 Thread Simon Slavin
On Sunday, 28 February, 2016 09:17, Christoforus Surjoputro said: > So you think that it better use autoindex instead of my own index for > matching email and password from user input and database? How about sqlite > queryplanner docs tell that said "To get the maximum performance out of a >

[sqlite] ASK SQLite algoritm to chose Index

2016-02-28 Thread Christoforus Surjoputro
Thanks for reply? Simon. So you think that it better use autoindex instead of my own index for matching email and password from user input and database? How about sqlite queryplanner docs tell that said "To get the maximum performance out of a query with multiple AND-connectedterms in the WHERE

[sqlite] ASK SQLite algoritm to chose Index

2016-02-28 Thread Keith Medcalf
s-bounces at mailinglists.sqlite.org [mailto:sqlite-users- > bounces at mailinglists.sqlite.org] On Behalf Of Keith Medcalf > Sent: Sunday, 28 February, 2016 09:52 > To: SQLite mailing list > Subject: Re: [sqlite] ASK SQLite algoritm to chose Index > > > On Sunday,

[sqlite] ASK SQLite algoritm to chose Index

2016-02-28 Thread Keith Medcalf
On Sunday, 28 February, 2016 09:17, Christoforus Surjoputro said: > Thanks for reply? Simon. > So you think that it better use autoindex instead of my own index for > matching email and password from user input and database? How about sqlite > queryplanner docs tell that said "To get the

[sqlite] ASK SQLite algoritm to chose Index

2016-02-28 Thread Simon Slavin
On 28 Feb 2016, at 5:57am, Scott Robison wrote: > So the link appears to be: > http://stackoverflow.com/questions/35625812/sqlite-use-autoindex-instead-my-own-index And that allows us to provide an explanation. Here's the setup: sqlite> CREATE TABLE user(id INTEGER PRIMARY KEY,email TEXT NOT

[sqlite] ASK SQLite algoritm to chose Index

2016-02-28 Thread Simon Slavin
On 28 Feb 2016, at 5:47am, Keith Medcalf wrote: > I do not see a link ... do you see a link? I saw no link. The OP may not actually be posting to this mailing list. He may be using a web interface which does the posting for him. And the web interface may be faulty and not posting the link

[sqlite] ASK SQLite algoritm to chose Index

2016-02-28 Thread Christoforus Surjoputro
t > Subject: Re: [sqlite] ASK SQLite algoritm to chose Index > > Hi Simon. > I've post it in stackoverflow link I gave before. About run ANALYZE, > SQLite still choose their own index instead Index that I've made. Thank > you. > > >? ? On Saturday, February 27, 2016 12:49 A

[sqlite] ASK SQLite algoritm to chose Index

2016-02-27 Thread Scott Robison
And here is a copy of my answer posted at stackoverflow (which assumes the context of the question): A see a few problems here. 1. The first SQL statement (CREATE TABLE ...) is malformed due to an extra comma between the last column and the closing parenthesis. 2. The third SQL

[sqlite] ASK SQLite algoritm to chose Index

2016-02-27 Thread Scott Robison
On Sat, Feb 27, 2016 at 10:49 PM, Simon Slavin wrote: > > On 28 Feb 2016, at 5:47am, Keith Medcalf wrote: > > > I do not see a link ... do you see a link? > > I saw no link. > > The OP may not actually be posting to this mailing list. He may be using > a web interface which does the posting

[sqlite] ASK SQLite algoritm to chose Index

2016-02-27 Thread Keith Medcalf
te mailing list > Subject: Re: [sqlite] ASK SQLite algoritm to chose Index > > This i the link: SQLite use autoindex instead my own index > | ? | > | ? | | ? | ? | ? | ? | ? | > | SQLite use autoindex instead my own indexI've problem with SQLite > autoindex in UNIQUE table. I've

[sqlite] ASK SQLite algoritm to chose Index

2016-02-27 Thread Christoforus Surjoputro
Hi Simon. I've post it in stackoverflow link I gave before. About run ANALYZE, SQLite still choose their own index instead Index that I've made. Thank you. On Saturday, February 27, 2016 12:49 AM, Simon Slavin wrote: On 26 Feb 2016, at 5:45pm, Christoforus Surjoputro wrote: > I've

[sqlite] ASK SQLite algoritm to chose Index

2016-02-27 Thread Keith Medcalf
sqlite-users- > bounces at mailinglists.sqlite.org] On Behalf Of Christoforus Surjoputro > Sent: Saturday, 27 February, 2016 09:47 > To: SQLite mailing list > Subject: Re: [sqlite] ASK SQLite algoritm to chose Index > > Hi Simon. > I've post it in stackoverflow link I gav

[sqlite] ASK SQLite algoritm to chose Index

2016-02-26 Thread Simon Slavin
On 26 Feb 2016, at 5:45pm, Christoforus Surjoputro wrote: > I've problem with sqlite choosing index that I think I have better index to > use. I've ask here but still didn't get why this happen? Did sqlite choose > the best index to use or choose the last entered index? SQLite doesn't know

[sqlite] ASK SQLite algoritm to chose Index

2016-02-26 Thread Christoforus Surjoputro
I've problem with sqlite choosing index that I think I have better index to use. I've ask?here but still didn't get why this happen? Did sqlite choose the best index to use or choose the last entered index? | ? | | ? | | ? | ? | ? | ? | ? | | SQLite use autoindex instead my own indexI've