TheFilmGod Posted September 17, 2007 Share Posted September 17, 2007 I have this fear that the website I'm making will somehow magically attract a great deal of traffic. If this is the case, and I create everything in php and mysql - will there be performance issues? I mean, if this occurs, IF, (it won't ) What do you guys say? I heard oracle is a lot more powerful, but I don't want to take that road... Quote Link to comment Share on other sites More sharing options...
effigy Posted September 18, 2007 Share Posted September 18, 2007 With the right hardware and configuration, I would imagine not. Apparently these folks like it. Quote Link to comment Share on other sites More sharing options...
TheFilmGod Posted September 18, 2007 Author Share Posted September 18, 2007 With the right hardware and configuration, I would imagine not. Apparently these folks like it. Alright. BUT what type of hardware? A dedicated server would be enough? Quote Link to comment Share on other sites More sharing options...
jaymc Posted September 19, 2007 Share Posted September 19, 2007 Depends what your making 20 tables, millions of rows, heavily accessed, tons of active users making concurrent connections = problems Database used by your friends to see who likes ice cream the best = fine Quote Link to comment Share on other sites More sharing options...
TheFilmGod Posted September 19, 2007 Author Share Posted September 19, 2007 I agree with the last post, but that's my point - is mysql worth a huge project or heavily popular site? Quote Link to comment Share on other sites More sharing options...
effigy Posted September 19, 2007 Share Posted September 19, 2007 I think the points are reversed here. You're asking if MySQL can handle something big and that Oracle might be better suited. We're saying it's not the application itself, but what's behind the application. If you have a terrible box, whatever database you put on it is going to have issues. I think your reply to me was on track: "What type of hardware?" I don't know that answer. Check MySQL's website for recommendations and contact them if need be. Keep in mind that saying "magically attract a great deal of traffic" is vague and not receptive to good answers (or any at all). Quote Link to comment Share on other sites More sharing options...
sneamia Posted September 19, 2007 Share Posted September 19, 2007 Wouldn't SMF be a testament to MySQL's scalability? Quote Link to comment Share on other sites More sharing options...
TheFilmGod Posted September 24, 2007 Author Share Posted September 24, 2007 Yes I understand that poorly optimized queries or php code can screw up things. But let us say they are well done, but there IS a lot of traffic, what happends? Is mysql worth the learning and work? Or should I look at oracle? Another thing, can mysql handle over 1 billion rows? (Innodb engine, of course ), what will happen? Will the mysql crash? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.