Jump to content


Photo

using MySQL for a large site?


  • Please log in to reply
3 replies to this topic

#1 dshallenberger

dshallenberger
  • Members
  • Pip
  • Newbie
  • 2 posts
  • LocationCincinnati, OH

Posted 04 December 2003 - 05:22 PM

I\'m building a site that has the potential for a lot of traffic. It\'s a site for posting \'for sale\' ads for anything from trinkets to houses. It\'s the internet version of a current local \'stuff-for-sale\' magazine. Well, the current magazine has about 1,500 ads in it monthly. So I would assume the potential for that many ads, and more, would be placed monthly on this site, with everyone paying with a credit card and submitting an ad, as well as contact information, that will be written to a database. Plus, every page view will pull from the database.

My concern is in my programming techniques and using mysql for a site with this much traffic. Is using basic php and sql to connect to the database and read/write ok? Should I be using a different database? or a different way to connect and/or read/write? is there a limit to open connections for mysql? or general techniques for higher-traffic sites?

I\'ve written a lot of PHP and SQL interacting with mysql, but all somewhat basic/intermediate usage and much lower traffic. Does any of this make a difference?

Thanks for any advice...
Dan

#2 nabeel21

nabeel21
  • Members
  • PipPip
  • Member
  • 25 posts

Posted 04 December 2003 - 05:33 PM

I would like to know that too. Plus what are these forum and phpfreaks.com running on? Is it MySQL?

#3 Arenium

Arenium
  • Staff Alumni
  • Advanced Member
  • 111 posts
  • LocationMassachusetts

Posted 04 December 2003 - 08:12 PM

great thread concerning the database debate, i highly suggest you read ALL the replies (or at least the replies that aren\'t something resembling \"omG d00d FiErbIRd r0x!\") : http://www.linuxques...threadid=116360

make of it what you will

#4 deRusett

deRusett
  • Members
  • PipPip
  • Member
  • 26 posts

Posted 04 December 2003 - 11:04 PM

Nice thread link,


on that note, MySQL will easily handed 1500 a DAY transactions, 1500 a month is hardly big,

My Uncle who is a Computer Engineer in England is the only person I know who does tasks greater then MySQL can handle, He uses Orical, since the company he works for handles 10-25 Million transactions a day,

My former university ran completly on MySQL, during registration thats 5000+ students online signing up for 5-10 courses,

which is intencive insert / drop / update queries, rarely did we experience slow downs from the DB, just poor ASP programming HA!.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users