Jonas Eckerman wrote:
> Justin Mason wrote:
>> by the way, a nice, working plugin that does this would be quite useful

> Since it was so straight-forward I made a small plugin that collects the raw 
> tokens in a SQL table.

An extra note:

I do not consider my plugin "nice" since it uses DBI in such an unoptimized 
way. I'm not very good at database programming, and this was a quick hack.

It really should use a prepared statement since it will perform the same 
operation a number of times for every learnt message. It probably should use 
the DELAYED keyword When used with MySQL and MyISAM tables. It should be made 
faster using INSERT with fallback to UPDATE (for the atime) rather than REPLACE 
INTO.

I might do those fixes. Or maybe you'll do them.

Regards
/Jonas

-- 
Jonas Eckerman, FSDB & Fruktträdet
http://whatever.frukt.org/
http://www.fsdb.org/
http://www.frukt.org/

Reply via email to