[sqlite] Indexing for sums?

Hi all, If I have the following table: CREATE TABLE stem(sid integer primary key, x double, y double, dbh double); ... is there any way I can create an index for the following query? SELECT * FROM stem WHERE x + dbh > 20 Thanks! _Nik ___

Re: [sqlite] Speed of DROP INDEX

us=off. > > You might try pragma journal_mode = off. That might keep it from > creating a journal, but if you already tried using synchronous=off, my > guess is journal_mode=off won't run any faster. > > Jim > > On 3/18/09, Nikolas Stevenson-Molnar <steve...@evergreen.

Re: [sqlite] Speed of DROP INDEX

t; sequential I/O), then drop the index with synchronous=off in one of >> the copies (no journal I/O), then use vacuum if you want to really >> clean up the DB. If something goes wrong, you still have your backup >> copy. >> >> I haven't actually tried this; let us know if i

Re: [sqlite] Speed of DROP INDEX

ied this; let us know if it makes a big > difference. > > Jim > > On 3/17/09, Nikolas Stevenson-Molnar <steve...@evergreen.edu> wrote: >> Hi, >> >> I'm trying to drop an index on a table with about 8 million rows and >> it's taking a very long tim

[sqlite] Speed of DROP INDEX

Hi, I'm trying to drop an index on a table with about 8 million rows and it's taking a very long time. I can understand why building the index would take some time, but why dropping it? And is there any way to speed it up? Thanks! _Nik ___

Re: [sqlite] Installing SQLite

Mac OS X also comes with SQLite; just open up the Terminal app and perform: sqlite3 _Nik On Mar 3, 2009, at 7:50 AM, P Kishor wrote: > On Tue, Mar 3, 2009 at 9:48 AM, Dan M. Wall > wrote: >> >> I am an experienced Windows user and application developer. I am >>

[sqlite] Displaying Large Tables

I'm working on a simple SQLITE database browser (part of a larger program) and I'm running into problems displaying larger (~8 million rows) tables. I originally set out using OFFSET and LIMIT to grab the rows I need to display on screen at any given time, but realized that this becomes