have an insert into that inserts 60 columns. The query
is generated by a program so I can't just copy it for you, but I can
provide it if will help.
HTH,
Stephen Toney
Systems Planning
[EMAIL PROTECTED]
http://www.systemsplanning.com
On Wed, 2007-05-09 at 23:32 +, [EMAIL PROTECTED] wrote
. When you are finished you unmap
the area and the index is complete. Using that method you perform no
writes and get a 20-50% speed improvement compared to using the write
API call.
Stephen Toney wrote:
I may work on such a program, if time permits. If successful I will
share it. It would
it an independent program it can be lean, mean and fast and
not touch the regular Sqlite library.
Stephen Toney wrote:
On Wed, 2007-03-28 at 08:23 -0600, Dennis Cote wrote:
It might make sense to create a separate standalone utility program
(like sqlite3_analyzer) that reuses some
users
waiting that long.
By comparison, building separate indexes on the two fields in the multi-
column index took only 2-3 minutes. Why would it be so much longer for a
multi-column index?
Thanks for any ideas!
--
Stephen Toney
Systems Planning
[EMAIL PROTECTED]
http://www.systemsplanning.com
reply. Is there
something wrong with my postings? Or is this just not an interesting
topic?
Many thanks,
Stephen
On Tue, 2007-03-27 at 11:15 -0400, Joel Cochran wrote:
Did you create the index before or after populating the database?
--
Joel Cochran
On 3/27/07, Stephen Toney [EMAIL
perfectly willing to assume it's me, but I'd like to learn why. Or if
it's SQLite, then my timing observations are of some value.
Best,
Stephen
On Tue, 2007-03-27 at 18:20 +0100, Martin Jenkins wrote:
Stephen Toney wrote:
Meta-question: this is the second time I've asked this question. The
first
On Tue, 2007-03-27 at 11:53 -0600, Dennis Cote wrote:
Stephen Toney wrote:
Meta-question: this is the second time I've asked this question. The
first was about a month ago and got not a single reply. Is there
something wrong with my postings? Or is this just not an interesting
topic
is a string of max 15 chars:
CREATE TABLE keyword (key, contyp int, imagecount int, searchcat int,
value, nextword, sec, ipr, fldseq int);
CREATE INDEX valuekey on keyword (value, key);
Thanks!
Stephen
Stephen Toney
Systems Planning
[EMAIL PROTECTED]
http://www.systemsplanning.com
the progress of the indexing so at least they have something
to look at!
Thanks,
Stephen
Stephen Toney
Systems Planning
[EMAIL PROTECTED]
http://www.systemsplanning.com
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
?
Thanks!
--
Stephen Toney
Systems Planning
[EMAIL PROTECTED]
http://www.systemsplanning.com
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
appreciated!
Stephen Toney
Systems Planning
[EMAIL PROTECTED]
http://www.systemsplanning.com
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
produced is better. Don't assume this to be
good advice without trying it. :)
-Tom
-Original Message-
From: Stephen Toney [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 01, 2007 7:00 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] Performance problem
Dear experts
these before indexing.
I am considering FTS for another project though. I appreciate the
suggestion!
Stephen
--
Stephen Toney
Systems Planning
[EMAIL PROTECTED]
http://www.systemsplanning.com
-
To unsubscribe, send email
Richard,
Thanks for the additional info. I'll look into the multi-column index
idea. Sounds as if it might be the solution.
Stephen
On Thu, 2007-03-01 at 14:42 +, [EMAIL PROTECTED] wrote:
Stephen Toney [EMAIL PROTECTED] wrote:
Thanks, Igor, Richard, and Tom,
Why doesn't SQLite use
14 matches
Mail list logo