next »

[koro]

There was something wrong , to my surprise,   not with the inserts but with selects.

I was fetching  one seed keyword per one SELECT query with order by.
Then i changed to select 10 keywords and looped it with the same functions i used to fetch one. Speed jumped 15 fold.

The site that i'm scrapping choked with that speed  so i actually slowed down the loops with sleep function.


@perkiset - i didnt use triggers.

@lamontagne- nice trick with memory

Thank you for your answers.