The advice from Dr. Richard Hipp did the trick. I added a multi column index
and now the query takes less than a tenth of a seconds. Thanks a lot for the
help you guys!
I was going to send this acknowledgement by replying to the message by Dr.
Hipp, but for some reason I didn't receive it, so I'll
> -Original Message-
> From: Williams, Ken [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 02, 2004 4:57 PM
> To: SQLite-Users (E-mail)
> Subject: [sqlite] Using multiple indexes?
>
>
> Hi,
>
> Is SQLite currently capable of using more than one index in a
> query? I'm
> adding ind
Hi,
Is SQLite currently capable of using more than one index in a query? I'm
adding indexes to a table, trying to optimize a query, and I only ever see
one index in the "EXPLAIN" output.
-Ken
-
To unsubscribe, e-mail: [EMAIL
> -Original Message-
> From: Matt Sergeant [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 02, 2004 4:26 AM
> To: Williams, Ken
> Cc: SQLite-Users (E-mail)
> Subject: Re: [sqlite] Error on commit
>
>
> On 29 Jan 2004, at 18:23, Williams, Ken wrote:
>
> >create_new_sqlite_databas
Hi!
I would like to include the preprocessed C files in my wxWindows
project. As wxWindows is C++ only, I am forced to use the c++ compiler
in DevCpp (Windows 2000). My problem is while Sqlite compiles with the c
compiler, it does not with c++ compiler. The main problems are:
1) comparision betwe
Rickard Andersson wrote:
I'm having some performance problems with queries looking like the
following:
SELECT DISTINCT p.poster_id AS has_posted, t.id, t.subject, t.poster,
t.posted, t.last_post, t.last_post_id, t.last_poster, t.num_views,
t.num_replies, t.closed, t.sticky, t.moved_to
FROM topics A
On 29 Jan 2004, at 18:23, Williams, Ken wrote:
create_new_sqlite_database();
$dbh->do("BEGIN");
add_lots_of_rows_to_lots_of_tables();
$dbh->do("COMMIT");
Change to:
create_new_sqlite_database();
$dbh->{AutoCommit} = 0;
add_lots_of_rows_to_lots_of_tables();
$dbh->commit;
# Op
7 matches
Mail list logo