Re: How efficiently update frequency of words?

[Andrzej Borucki]

My solution - two SQL queries
First update existing:

UPDATE words
INNER JOIN bwords
ON words.word = bwords.word and
words.pos = bwords.pos
SET words.count = words.count+bwords.count


second, add new words:

INSERT INTO words ( word, pos, count)
SELECT word, pos, count
FROM bwords b
WHERE
NOT EXISTS (SELECT * FROM words w
WHERE b.word = w.word and b.pos = w.pos)

Both must be in one transaction