Solved

DB Record Capacity vs Speed

Posted on 2003-12-12
4
254 Views
Last Modified: 2010-04-07
If I was looking to build a database driven website which needed the capacity to hold up to 70,000 records which database do you think should go on the back end and which code would you favour to interact (ASP,PHP,CF other). The only consideration would be speed.
0
Comment
Question by:rbc33
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 10

Accepted Solution

by:
KenAdney earned 125 total points
ID: 9930114
IMHO, I'd go with PHP & and a SQL database but I suspect that the primary consideration for speed is offloading the database onto a seperate server & processing the SQL commands there rather than doing it all on one server.
0
 
LVL 1

Expert Comment

by:Perpetual
ID: 9931515
Rbc33,

I second KenAdney Linux/Apache/MySQL/PhP (or the windows equivalent) is the way to go.

You could alternatively use a combination of perl/embperl to do what the PhP would do, built a database a while back for a client, 100 000+ records with continuous read / write.  It was actually a chat server interface for a porn company.  Very very low server load and very very quick access (could handle 5000+ simultaneous connections, I think they had a couple dedicated T3s or something :)

cheers,

eric.
0
 

Author Comment

by:rbc33
ID: 9937436
I have accepted the first answer although I appreciate the technical detail given in the second. I would like to know more about how offloading the database speeds things up and how to get the data cross servers. I appreciate this is beyond the scope of the original question.
0
 
LVL 10

Expert Comment

by:KenAdney
ID: 9959025
Sorry it took a while to get back to this...

Most simply put, your web page simply refers to the database on another server, either with or without the data source name (http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q165/8/66.ASP&NoWebContent=1).  

For instance, here's how ASP can access an SQL database on another server:

DataConn.Open "Provider=sqloledb;" & _
                   "Data Source=servername;" & _
                   "Initial Catalog=database name;" & _
                   "User Id=me;" & _
                   "Password=mypassword;"

Now when you run the SQL statement to retrieve or update data, the actual processing happens on a different physical server and your web page only acts to send (or get) the data from the end user.  All that processing searching for records happens away from the web server.

Does that help?
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
The purpose of this video is to demonstrate how to add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…
The purpose of this video is to demonstrate how to integrate Mailchimp with Facebook. This will be demonstrated using a Windows 8 PC. Mailchimp and Facebook will be used. Log into your Mailchimp account. : Click on your name. Go to Account Setti…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question