rt into mystrings (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 Arons
erimentation base before 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
0 4 30600 103084 5864 273607200 220 2233 394 149 5 1 13 81
With half of the CPU work remaining to be done, but only 5% (and
falling) of the available CPU power devoted to this, the job will
take very long.
--
Lars Aronsson ([EMAIL PROTECTED])
Aronsson Datateknik - http://a
se PRAGMA cache_size?
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
_
way (look, no DBA!), 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 A
5 matches
Mail list logo