[sqlite] Information Schema Views

2004-03-22 Thread Greg Obleshchuk
Hello All, I have created a new wiki page off the main wiki page called Information Schema. Here is the link http://www.sqlite.org/cvstrac/wiki?p=InformationSchema The SQL standard INFORMATION_SCHEMA views are a standard way of retrieving schema information from any SQL standardised database.

Re: [sqlite] Does anybodu have tried TWS (http://www.hwaci.com/sw/tws)

2004-03-22 Thread D. Richard Hipp
borivoj wrote: Hello everybody, I would like to know is there anybody other willing to share experiences in TWS - all-in-one web server, tcl and sqlite combination provided by Richard on http://www.hwaci.com/sw/tws Since I am mostly on windows I've managed to find windows version of TWS,

[sqlite] Does anybodu have tried TWS (http://www.hwaci.com/sw/tws)

2004-03-22 Thread borivoj
Hello everybody, I would like to know is there anybody other willing to share experiences in TWS - all-in-one web server, tcl and sqlite combination provided by Richard on http://www.hwaci.com/sw/tws Since I am mostly on windows I've managed to find windows version of TWS, tested it and it

Re: [sqlite] sqlite not sharing page cache across processes?

2004-03-22 Thread Mark D. Anderson
On Mon, 22 Mar 2004 14:35:23 -0500, "Doug Currie" <[EMAIL PROTECTED]> said: > It has no way of knowing (save diffing the db) that "there have been > no write transactions." well, that should in principle be easy to accomplish, shouldn't it? For example by having any writer increment a counter

[sqlite] Feature of "FROM" clause

2004-03-22 Thread Simon Berthiaume
Hi, given the following tables: CREATE TABLE table_1(id INTEGER PRIMARY KEY,column VARCHAR(64)); CREATE TABLE table_2(id INTEGER PRIMARY KEY,column VARCHAR(64)); I realized that the following query isn't valid in SQLite: SELECT * FROM (

Re: [sqlite] Precompiled queries forcing db syncs?

2004-03-22 Thread Dan Thill
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 In short, when I switch to precompiled queries, according to gprof, it looks like the DB is being synched after every call, even though I've issued PRAGMA synchronous=OFF. As a result, using precompiled queries is an order of magnitude slower. Make

Re: [sqlite] sqlite not sharing page cache across processes?

2004-03-22 Thread D. Richard Hipp
Mark D. Anderson wrote: > Have you measured what improvement would be obtained by using readonly mmap() > for readers, rather read()? SQLite supports files that are larger than 4GB. I don't think you can mmap() a file that big on a machine with a 32-bit address space. -- D. Richard Hipp -- [EMAIL

Re: [sqlite] sqlite not sharing page cache across processes?

2004-03-22 Thread Doug Currie
Monday, March 22, 2004, 1:46:00 PM, Mark wrote: >> I have run experiments to see how much faster SQLite might >> work if it didn't invalidate its cache so quickly. The >> answer is about 15%. So it is probably worth looking into >> someday. Note that such a change will be backwards but >> not

Re: [sqlite] sqlite not sharing page cache across processes?

2004-03-22 Thread D. Richard Hipp
Mark D. Anderson wrote: My reading of the code has the readers flushing their cache often, and not using the journal at all to maintain consistency. My reading has the reader start with nothing in the cache, lock the database with a read lock, perform as many SQL queries as are in the single

[sqlite] sqlite on vxworks or vrtx?

2004-03-22 Thread Brett Granger
Hi, I'm new to this list, and have been given a task to investigate various alternatives for databases on embedded systems. I like what I have seen of sqlite so far! On the sqlite.org wiki under "when to use sqlite", there is the following: "# Embedded devices and applications Because an

RE: [sqlite] Precompiled queries forcing db syncs?

2004-03-22 Thread Williams, Ken
> -Original Message- > From: Dan Thill [mailto:[EMAIL PROTECTED] > Sent: Monday, March 22, 2004 10:34 AM > To: [EMAIL PROTECTED] > Subject: [sqlite] Precompiled queries forcing db syncs? > > In short, when I switch to precompiled queries, according to gprof, it > looks like the DB is

[sqlite] Precompiled queries forcing db syncs?

2004-03-22 Thread Dan Thill
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'm running into a problem using the experimental precompiled query API. Yes, I know it's experimental, but this is pretty serious, and no one on this list, or google has posted anything similar. In short, when I switch to precompiled queries,

Re: [sqlite] Performance problem

2004-03-22 Thread Hugh Gibson
> SQLite only uses a single index per table on any give query. > This is unlikely to change. Would it be able to use a multi-column query on ipnode + author? Hugh > Shi Elektronische Medien GmbH, Peter Spiske wrote: > > > > the following simple query is very slow: > > SELECT title FROM t1