MySQL Forums
Forum List  »  Newbie

Re: Speed to lookup value
Posted by: Felix Geerinckx
Date: August 16, 2005 01:19PM

Jon Lawrance wrote:

> I am considering having a database of 8,000 IP addresses of search engine robots and other bots.
> If I put this in a MySQL database, how long would it take to lookup that IP address in the database
> to check whether it is a surfer or bot on the site? Any ideas?

After doing calculations based on the detailed hardware specs as well as on the detailed software configuration information you provided, I would say 13.5 milliseconds per lookup, excluding connection setup overhead.

--
felix
Please use BBCode to format your messages in this forum.

Options: ReplyQuote


Subject
Written By
Posted
August 16, 2005 10:49AM
Re: Speed to lookup value
August 16, 2005 01:19PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.