The Cache: Technology Expert's Forum
 
*
Welcome, Guest. Please login or register. February 12, 2012, 05:22:17 PM

Login with username, password and session length


Pages: 1 [2]
  Print  
Author Topic: Better DB design for keyword Harvester.  (Read 1166 times)
koro
n00b
*
Offline Offline

Posts: 6


View Profile
« Reply #15 on: November 18, 2009, 01:51:36 PM »



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.Smiley

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.
« Last Edit: November 18, 2009, 02:02:07 PM by koro » Logged

No links in signatures please
Pages: 1 [2]
  Print  
 
Jump to:  

Perkiset's Place Home   Best of The Cache   phpMyIDE: MySQL Stored Procedures, Functions & Triggers
Politics @ Perkiset's   Pinkhat's Perspective   
cache
mart
coder
programmers
ajax
php
javascript
Powered by MySQL Powered by PHP Powered by SMF 1.1.2 | SMF © 2006-2007, Simple Machines LLC
Seo4Smf v0.2 © Webmaster's Talks


Valid XHTML 1.0! Valid CSS!