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
> by extending the Sqlite file by the size of the index, memory mapping
> that area and using it as the buffer. 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 th
order of magnitude could be expected.
>
> By making 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:
> >
> >
> >>
Actually, it already is a separate process launched on the server by the
web app. But since users can't use the system until the index is built,
I show them the progress of the indexing so at least they have something
to look at!
Thanks,
Stephen
Stephen Toney
Systems Planning
[EMAIL PROTECTED]
ma again, in which "value" 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]
ht
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 t
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 t
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
>
>
>
> O
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
?
Thanks!
--
Stephen Toney
Systems Planning
[EMAIL PROTECTED]
http://www.systemsplanning.com
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
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,
>
instead of UTF-8. Our
programs remove 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
---
d that the query plan 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-u
ions would be much appreciated!
Stephen Toney
Systems Planning
[EMAIL PROTECTED]
http://www.systemsplanning.com
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
14 matches
Mail list logo