7;) or (uni_11 not like '6%' and
uni_11 not like '-1%')) order by system, id
This returns 29 columns. I claim no credit for such a rotten data model
that requires a query like this -- it was converted from a spreadsheet.
In another app we have an insert into that inserts 60 c
ter
> 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 t
er 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:
> >
> >
> &g
worry about locking or journaling etc.
That would solve my problem too (thread: "CREATE INDEX performance" on
indexing a 5.8-million record table). I'd love something like that!
--
Stephen Toney
Systems Planning
[EMAIL PROTECTED]
htt
> unseen by the user?
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
Syst
ing.
(The schema 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
[EMAI
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 screwy. I'm
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 i
ingle 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
>
>
>
&
can't see 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.syst
lumn index?
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
---
aid index and
> checked 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
he result is just as bad
-- the server times out.
Any suggestions would be much appreciated!
Stephen Toney
Systems Planning
[EMAIL PROTECTED]
http://www.systemsplanning.com
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
15 matches
Mail list logo