> Message: 2 > From: Hagibis Fan <[EMAIL PROTECTED]> > Subject: [plug] does mysql scale > > are there any mysql users in here? I am thinking > of getting an mysql certification (to improve my > resume--could be useful later). most of the > people in my day job dosnt take it seriously, > but i *really* do like it. > > do you use it in a serious > application, and like how much rows do you estimate > on your largest table? I have it on my > webserver at around 20k rows but i dont know how it > would behave in large applications. > > jondz
MySQL scales and scales _really well_, however it lacks many of the niceties that have come to be considered essential in 'real' DBMSes, working foreign keys, subselects, triggers, SPs, etc... You are going to have to do a lot of extra stuff to work around their absence. But if your app can do without most of these and you need MySQL's blazing speed, then MySQL makes for an extremely effective tool. I've become a Firebird fan lately, but for an application like say, a high traffic web forum (which has relatively simple tables), I'd probably still stick to MySQL (though since I'm using PHP ADODB for the one I'm developing right now, switching to Firebird will be much less painful). MyISAM tables are really easy to maintain and are quite fast (on simple queries only). InnoDB has more heavyweight features but seems like a lot more pain to work with. Anyone out there have good things to report wrt to InnoDB? _ Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] Fully Searchable Archives With Friendly Web Interface at http://marc.free.net.ph To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED]
