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
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
>
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
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,
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
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
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
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
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
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
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
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-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
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
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
15 matches
Mail list logo