dshallenberger Posted December 4, 2003 Share Posted December 4, 2003 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 Link to comment https://forums.phpfreaks.com/topic/1461-using-mysql-for-a-large-site/ Share on other sites More sharing options...
nabeel21 Posted December 4, 2003 Share Posted December 4, 2003 I would like to know that too. Plus what are these forum and phpfreaks.com running on? Is it MySQL? Link to comment https://forums.phpfreaks.com/topic/1461-using-mysql-for-a-large-site/#findComment-4820 Share on other sites More sharing options...
Arenium Posted December 4, 2003 Share Posted December 4, 2003 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.linuxquestions.org/questions/sh...threadid=116360 make of it what you will Link to comment https://forums.phpfreaks.com/topic/1461-using-mysql-for-a-large-site/#findComment-4821 Share on other sites More sharing options...
deRusett Posted December 4, 2003 Share Posted December 4, 2003 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!. Link to comment https://forums.phpfreaks.com/topic/1461-using-mysql-for-a-large-site/#findComment-4825 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.