Re: [sqlite] Slow SELECT query

[aba . elhaddi]

Let's see if we can make the 7pm one.

Eh
Sent via BlackBerry from T-Mobile

-Original Message-
From: wlof 

Date: Fri, 4 Sep 2009 07:52:43 
To: 
Subject: Re: [sqlite] Slow SELECT query




Sebastian Bermudez wrote:
> 
> 1)
> Ok, change the index to:
> CREATE INDEX IF NOT EXISTS log_idx ON log (timestamp)
> 
> column Id is not used for select...
> the Id column just is needed for delete operation.
> 
This seems to have done the trick. The SELECT query now takes ~15 ms. Much
better :)

I didn't think adding the id in the index would have such consequences! I
take it adding an index on id AND timestamp is definitely not the same thing
than adding an index on id AND adding an index on timestamp.

Thanks a lot for your help! It is much appreciated.


-- 
View this message in context: 
http://www.nabble.com/Slow-SELECT-query-tp25294597p25295851.html
Sent from the SQLite mailing list archive at Nabble.com.

___
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] The SQL Guide to SQLite

[aba . elhaddi]

Rick,
This a very comon way for citations in ACM and IEEE papers.
Others such as ESA use "Lname" year.

--A El Haddi
Sent via BlackBerry from T-Mobile

-Original Message-
From: "Rick Ratchford" 

Date: Sat, 18 Jul 2009 19:20:40 
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] The SQL Guide to SQLite


Perhaps its true that its common in academic papers. I wouldn't know as I've
never read one.

All I know is that this is a book. I have a vast library of technical books
and this is the ONLY one that uses this convention. Even my copy of "A New
Kind of Science" by Wolfram doesn't use this convention. :-b

So seeing it for the first time was very confusing. I flipped through the
last pages and didn't note the one page biblio. That's when I ran it through
'bing' before asking here.

Even doing a 'bing' on "square brackets" suggested they were placeholders
for other information during production. I think some kind of convention
explanation would have been appropriate at the beginning of this book like
most programming books provide rather than assuming everyone is familiar
with conventions used in "academic papers". 

Thanks. 
:-)
Rick

 
 

#>-Original Message-
#>From: sqlite-users-boun...@sqlite.org 
#>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Thomas Briggs
#>Sent: Saturday, July 18, 2009 6:53 PM
#>To: General Discussion of SQLite Database
#>Subject: Re: [sqlite] The SQL Guide to SQLite
#>
#>   That's pretty common in academic papers, actually.
#>
#>   -T
#>
#>
#>On 7/18/09, Rick Ratchford  wrote:
#>> Yes. You are correct. That is what they are.
#>>
#>> Thanks for pointing this out. It probably should have been 
#>made clear 
#>> at the beginning of the book since this is not common in 
#>the majority 
#>> of books I own purchased here in the US.
#>>
#>> Thanks again.
#>>
#>> Rick
#>>
#>>
#>> #>-Original Message-
#>> #>From: sqlite-users-boun...@sqlite.org 
#>> #>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of 
#>Igor Tandetnik
#>> #>Sent: Saturday, July 18, 2009 10:42 AM
#>> #>To: sqlite-users@sqlite.org
#>> #>Subject: Re: [sqlite] The SQL Guide to SQLite #> #>Rick Ratchford 
#>> wrote:
#>> #>> I just received my copy of the new book "The SQL Guide to 
#>> #>SQLite" by #>> Rick F. van der Lans.
#>> #>>
#>> #>> There are many references within the book that are 
#>#>contained in 
#>> square #>> brackets and some sort of keyword or code.
#>> #>>
#>> #>> Example: "...written about SQLite; see for example [NEWM05] and 
#>> #>> [OWEN06]."
#>> #>
#>> #>These are most likely citations. See if there's a 
#>#>bibliography (a 
#>> list of other books, articles and such) at #>the end of the 
#>book, each 
#>> reference identified by one of these codes.
#>> #>
#>> #>Igor Tandetnik
#>> #>
#>> #>
#>> #>
#>> #>___
#>> #>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
#>>
#>
#>--
#>Sent from my mobile device
#>___
#>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
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users