I have a system which gets requests at 25 transactions per second. On receiving a request, the system does a lookup in its database (which consists of 100,000 entries) to get the required information.
A request comes ever 1/25 seconds and for each request log2(100,000) entries in the db are looked up. Therefore in each second 25* log2(100,000) = (415) entries are looked up/compared.
I want to find out: what kind of a processor do I need to support this speed. I want to know how to perform the calculations? Say in case of X records in db and Y TPS..i would need a 3Ghz quad core processor .
Could you please help? I am not sure how'd I go about doing this.

Right, as if the CPU load could be figured out from the (lack of) information given!!!!


What DB Server?
What type of structure?
What storage engine?

plus a dozen other things that will have a bearing on the CPU requirements.

and oddly enough the request rate is NOT really one of them.

The database recovery speed is what will affect or be affected by the request volume.

and provided the structure and indexes are well designed 25 requests per second is nothing.

Well I think most of the modern processor would do it .. and 3GHz processor is suffficient to perform wat ever I understand from your post

I think most of the modern processor would do it .. and 3GHz processor is suffficient to perform wat ever I understand from your post

Heck, on a correctly designed db, even an old p4 1Ghz should be enough.
No need for a monster for that kind of requirements...

Ah! the copy and paste sig spammers are getting really lazy now, at one time they would at least scroll up the page a little.

hahah Chris you must have alot fun patrolling on here. I don't even understand why they do that