Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Beginner
May 29, 1997

Can you recommend a hardware/software configuration for database?

Question:
We need to search a simple three-million-record database containing names, phone numbers, accounts and dates. We will enter a phone number and must fetch the complete record, about 12,000 such numbers, in approximately four hours. Can you recommend a hardware/software configuration?

Answer:
The most important part of your performance equation is database design. If the phone number is unique, as it should be, use it as a primary key, which will deliver optimal retrieval performance.

I have figured out that 12,000 rows in four hours works out to 3,000 rows per hour, which is 50 rows per minute. This type of retrieval should not be a problem, although I assume you are talking about multiple users, because I don't think it's possible that a user can input a telephone number in less than two seconds.

The configuration of the database server is dependent on the type of server database, which you did not specify. Consult with the database vendor for sizing and platform information for the database server.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date