Maximum hits at a time.

fernandodonster

I would like to develop a big site with php and mysql/postgres.
Which is the best database perform well?
I expect 3500 hits at a time.
thanks inadvance.

leatherback

I am certainly not an expert on this topic, but.. MySQL is ok for medium sites. Very large sites I think postgre is more suited.

What do you mean with 3500 hits 'at a time'. You mean that you expect 3500 simultaneous visitors? That would mean.. ehm..
say 10 mins per visit => 21K per hour, half a million visitors per day?

Really curious what you are developing. Willing to share the general idea of what you are selling?

Some of my sites draw 50-100K visitors a month. I use page caching on my server, and the database only has trouble dealing with visitor tracking, which I have switched of, as 50K records per month added make for heavy queries (The site grew more than expected, and I did not write the stats properly).

From your question, I'd say you are not a specialist in databases / database run websites. If you can really expect that sort of traffic, I would seriously consider hiring a professional for doing your website construction, as small optimizations can have massive effects.

nrg_alpha

fernandodonster wrote:
I would like to develop a big site with php and mysql/postgres.
Which is the best database perform well?
I expect 3500 hits at a time.
thanks inadvance.

You probably mean 3500 visitors at a time.

There is a confusion with the term 'hits'..

Many people beleive a hit represents a visitor.

This is false.

A hit is any element of a web page that is successfully downloaded by the visitor's web browser. So if you have a home page with say 6 images in it, and you successfully download the entire page, this counts as 7 hits (the main (x)html document, and the 6 separate images).

So the next time you visit a website where it has say 1,865,227 hits listed as a hit counter.. it's rubbish...I can easily make a site with each page containing over 100
tiny images.. thus my hit count by a modest amount of visitors would go through the roof.. thus making the site look more popular that it really is.

Cheers,

NRG

P.S As for what kind of site you are building.. let me guess.... pron :p

fernandodonster

I would like make a big site with php, mysql/postgres for a big private organization with open source .Its is a intranet.Main purpose is to enter data simultaneously from company's 3500 unit.
i expect 3500 visitors would visit at a time.
whether the database will respond slowly???

bretticus

Ah Intranet, so you mean the most ppl that could ever get on at one time is 3500. Don't sweat it, use MySQL.

knowj

MySQL is perfectly capable of handling that amount of traffic.

What is more of an issue is the methods, engines you use. Research into the different engines etc... also the methods you use.

I was recently advised to use http://uk3.php.net/function.mysql-pconnect to help increase performance but i always the mysqli class.

read:
http://www.mysql.com/why-mysql/benchmarks/