Link to home
Start Free TrialLog in
Avatar of brettr
brettr

asked on

MySQL good for lots of traffic?

I want to use something cheaper than MS SQL Server as a database to handle what may turn into a fairly large volume of traffic.  Basically, my app will behave the same as a Twitter feed.  People submit messages to our server and receive messages based on a query.  I'd like new messages to appear fairly quickly (few seconds).

Using MySQL or some similar database will allow me to move across hosting providers easily and without the expense of a Windows Server or MS SQL Server.  Does MySQL handle large volumes of traffic well?

Does connecting to it through PHP perform well?
Avatar of Aneesh
Aneesh
Flag of Canada image

> Does MySQL handle large volumes of traffic well?
Yes
'>Does connecting to it through PHP perform well?
Yes that will

But we dont know the future of mYsql.. sO YOU MAY HAVE TO RETHINK
Avatar of brettr
brettr

ASKER

>>But we dont know the future of mYsql.. sO YOU MAY HAVE TO RETHINK

Isn't this true about any database?  What do you mean?

If anything, you should be able to remain at a current version and not accept MySQL updates.
ASKER CERTIFIED SOLUTION
Avatar of Loganathan Natarajan
Loganathan Natarajan
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial