Re: [SQL] Implementing an regex filter

2007-08-08 Thread Paul Lambert
Enrico Weigelt wrote: Hi folks, Any hints for futher optimization appreciated :) thx It doesn't look like you have any indexes - I'd add one to at least articles.title and blacklist.title to start with and probably also user_results.article_id and articles.inode_id. -- Paul Lambert Dat

[SQL] Implementing an regex filter

2007-08-08 Thread Enrico Weigelt
Hi folks, I've coded an auction crawler, which queries several auction platforms for user-defined keywords. The results are then put into queues an sorted out from there. For example each auction query can be passed along with an maxprice value, which is put into the result records. Every few