[sqlite] Re: speeding up a query

Posting an update to my problem. I have a solution that seems to work. I am posting my solution here just in case someone can suggest methods for further gains in efficiency. To recap the problem -- 1. 210k polys, 5.25 million points. 2. For each point, update its attribute (name)) with that of

Re: [sqlite] speeding up a query

On 8/26/06, Pablo Santacruz <[EMAIL PROTECTED]> wrote: Try something like this: CREATE INDEX ix_polys ON polys (xmin, ymin, xmax, ymax); SELECT name FROM polys WHERE EXISTS (SELECT x FROM points WHERE point_id = 1 AND xmin < x AND ymin < y AND xmax > x AND ymax > y); In your query you do 4

Re: [sqlite] REPLACE command usage

Thanks guys. That did exactly what I wanted! Igor Tandetnik wrote: > > rockdawg <[EMAIL PROTECTED]> wrote: >> Here are some entries: >> >> smb://MSHOME;kevin:@Movie-server/D/Gladiator/VIDEO_TS >> smb://MSHOME;kevin:@Movie-server/D/Rocky/VIDEO_TS >>

Re: [sqlite] Does ODBC of sqlite support delete function?

--- Wensui Liu <[EMAIL PROTECTED]> wrote: > I use SAS, a statistical computing language, to link to a sqlite > database through ODBC. > When I tried to delete rows from a table, it says the delete function > is not supported. Does ODBC support delete function? Christian Werner's SQLite ODBC

Re: [sqlite] VB DLL and sqlite 3

I am sure this is asked fairly frequently but I couldn't find anything (recent) in the archives. Is there an updated version of the PSUTILS script to work with SQLite 3? If not, is there a "convert from 2.8 to 3" guide that can be understood by a VB developer with a little C understanding? :) I

Re: [sqlite] Error handling.

On 8/27/06, Anders Aagaard <[EMAIL PROTECTED]> wrote: Jay Sprenkle wrote: > On 8/26/06, Anders Aagaard <[EMAIL PROTECTED]> wrote: >> Hi >> >> Is there any way to handle the different error messages from sqlite >> without doing strcmp? For example SQLITE_CONSTRAINT? > > will the conflict

Re: [sqlite] Error handling.

Jay Sprenkle wrote: On 8/26/06, Anders Aagaard <[EMAIL PROTECTED]> wrote: Hi Is there any way to handle the different error messages from sqlite without doing strcmp? For example SQLITE_CONSTRAINT? will the conflict handling options do what you need? http://www.sqlite.org/lang_conflict.html

Re: [sqlite] Error handling.

On 8/26/06, Anders Aagaard <[EMAIL PROTECTED]> wrote: Hi Is there any way to handle the different error messages from sqlite without doing strcmp? For example SQLITE_CONSTRAINT? will the conflict handling options do what you need? http://www.sqlite.org/lang_conflict.html -- SqliteImporter

Re: [sqlite] VB DLL and sqlite 3

On 8/26/06, Dean Earley <[EMAIL PROTECTED]> wrote: Hi all. I am sure this is asked fairly frequently but I couldn't find anything (recent) in the archives. Is there an updated version of the PSUTILS script to work with SQLite 3? If not, is there a "convert from 2.8 to 3" guide that can be

[sqlite] sqlite shared-cache mode usage

Good morning all, I'm in the design stage of a project and had a question about sqlite shared-cache mode. The new version of firefox will use mozStorage, which is based on sqlite using shared-cache mode. I want other programs to be able read/write to the database but I was told this might be a