I have a question for every body...
SQLite was very slow for my inserts (like 5 inserts), with out
sincronization
but when i put BEGIN; before start with my inserts is was faster... like
1000 times more... :D why is that?
On 6/28/06, Cesar David Rodas Maldonado [EMAIL PROTECTED] wrote:
/speed.html
P.S. I'm sure someone else will give a better explanation.
-Original Message-
From: Cesar David Rodas Maldonado [mailto:[EMAIL PROTECTED]
Sent: 29 June 2006 16:12
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] sqlite too slow for me?
I have a question for every
First, thank you all for the answers.
UNIQUE(col1, col4, col5, col2),
Adding this would surely make the query run faster -- provided that
SQLite chooses the right index. But I also use the UNIQUE(col1, col4,
col5) constraint to ensure the uniqueness of these three columns. So
instead I
I dont know a lot about MySQL... but mysql is not so faster as you think...
I have in my computer the mysql 5 is good, but sqlite is so faster too!!!
but MySQL has a query cache so i think the cache make it seems more
faster than sqlite...
On 6/27/06, Péter Szabó [EMAIL PROTECTED]
=?ISO-8859-1?Q?P=E9ter_Szab=F3?= [EMAIL PROTECTED] wrote:
My schema is the following:
CREATE TABLE t (
col1 text NOT NULL,
col2 integer NOT NULL,
col3 integer NOT NULL,
col4 text NOT NULL,
col5 text NOT NULL,
PRIMARY KEY(col1, col2, col3, col4, col5),
--- [EMAIL PROTECTED] wrote:
=?ISO-8859-1?Q?P=E9ter_Szab=F3?= [EMAIL PROTECTED] wrote:
My schema is the following:
CREATE TABLE t (
col1 text NOT NULL,
col2 integer NOT NULL,
col3 integer NOT NULL,
col4 text NOT NULL,
col5 text NOT NULL,
PRIMARY
P?ter Szab? [EMAIL PROTECTED] wrote:
Dear SQLite Developers,
I am seeking help for optimizing my SQLite SQL query, which seems to
be running unreasonably slow. The query is:
SELECT col2 FROM t WHERE col1='foobar' AND
col4='foobarfoobarfoobarfoob';
My schema is the following: