RE: [sqlite] www.sqlite.com has disappeared

disappeared The address is www.sqlite.org. Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message- From: Ken Cooper [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 06, 2004 1:38 AM To: [EMAIL PROTECTED] Subject: [sqlite] www.sqlite.com has disappeared

[sqlite] www.sqlite.com has disappeared

Anyone else experiencing this?

[sqlite] Performance of using Intersect; sanity check for newbie

I'm implementing a simple full text search in a sqlite database, using an additional table for the indexed words, associated record ids, and word offsets. A typical query will have multiple keywords, plus some additional fields specified. CREATE TABLE words (word TEXT, recordid INTEGER,

RE: [sqlite] Efficient select for multiple ids

The '.'s below should be ellipses. -Original Message- From: Ken Cooper [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 15, 2004 1:56 PM To: [EMAIL PROTECTED] Subject: [sqlite] Efficient select for multiple ids I am implementing a virtualized listview on the result of a query

[sqlite] Efficient select for multiple ids

I am implementing a virtualized listview on the result of a query by first retrieving all unique ids for each row in the query result, then on demand looking up additional information based on the ids in small chunks, say 20 at a time. I was thinking the best way to approach this second query was