RE: [sqlite] sqlite too slow for me?

/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? > >

Re: [sqlite] sqlite too slow for me?

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:

Re: [sqlite] sqlite too slow for me?

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]> wrot

Re: [sqlite] sqlite too slow for me?

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 shou

Re: [sqlite] sqlite too slow for me?

--- [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 N

Re: [sqlite] sqlite too slow for me?

"=?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, co

Re: [sqlite] sqlite too slow for me?

Since col1 is always equal to 'foobar' in your data set, you want to discourage its use by the SQLite optimizer by using +col1 in the where clause. Any operation on a column in the where clause disqualifies it from be used in an index in SQLite. SELECT col2 FROM t WHERE +col1='foobar' AND co

Re: [sqlite] sqlite too slow for me?

"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 follo