Re: [sqlite] Optimizing an insert/update

strings (string, count) select string, sum(count) from mytemp group by string; As a complement to the "insert or replace" it would be nice to have "insert or accumulate" for this kind of a job. However, that would go outside of the SQL standard. -- Lars Aronsson ([EMAI

Re: [sqlite] How long time to index this table

fore I try this on the full size German or English Wikipedia. But I might have to back down to the Estonian or Faroese Wikipedia to get an even smaller dataset. -- Lars Aronsson ([EMAIL PROTECTED]) Aronsson Datateknik - http://aronsson.se ___

[sqlite] How long time to index this table

? Is there a good way to find out what sqlite3 is doing? I know the "explain" command lists the byte code, but can it predict how long an operation will take? -- Lars Aronsson ([EMAIL PROTECTED]) Aronsson Datateknik - http://aronsson.se ___ sq

[sqlite] Innovative examples / user stories

so full transaction handling wasn't really needed. That shift in usage pattern opened up for a simpler and more affordable solution. Many other such technology shifts are described in an old book titled "The Innovator's Dilemma". -- Lars Aronsson ([EMAIL PROTECTED])