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 WHERE
-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,
-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 being
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
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
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 forwards
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
-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
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
(
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 held
in
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
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,
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.
13 matches
Mail list logo