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

Login with username, password and session length


Pages: [1]
  Print  
Author Topic: Big Number of Queries or something. how to fix  (Read 441 times)
Keebler
Rookie
**
Offline Offline

Posts: 18


View Profile
« on: August 22, 2009, 11:13:56 AM »



I just have a basic index...

id:keyword

and then one with

id:url

I think its going through and checking for duplicates every time I enter a new keyword or something. but it makes me sad so i want to fix it.

Any database indexing recommendations? or how to query this stuff better?
Logged

No links in signatures please
Keebler
Rookie
**
Offline Offline

Posts: 18


View Profile
« Reply #1 on: August 22, 2009, 11:16:05 AM »

the database/script is a spider.
Logged

No links in signatures please
Pages: [1]
  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!