maybe I have to cache the requests inside a database...
That's a must, but have in mind that this can produce overhead as you will have many records with varchar keys
is there an other way? I think I have to index the the web addresses to make it quick
I am a metal monkey!
Administrator Community Supporter?
Jedai Sword Master
Gender:
Posts: 5799
46391 credits Members referred : 3
« Reply #9 on: Jun 27, 2006, 12:53:29 pm »
You can create a table like this :
domain tld rank
Example row :
webdigity com 44.000
Of course the two first rows will be primary key, so the indexing will be much faster, and it will be able to handle many thousands records with a light server.
Of course the two first rows will be primary key, so the indexing will be much faster, and it will be able to handle many thousands records with a light server.
yes this is what i thought, but how about a table with more then 100.000 records?
I am a metal monkey!
Administrator Community Supporter?
Jedai Sword Master
Gender:
Posts: 5799
46391 credits Members referred : 3
« Reply #11 on: Jun 27, 2006, 01:03:48 pm »
Big tables will work much better with mysql 5, but anyway don't be afraid, as mysql is very well optimized.