Robert Sundström writes: > > Most stable commercial products exposes the opposite behavior. It may be > the case that MySQL performs pretty well in single (or few) user cases, but > the commercial alternatives will, in my experience, in most cases beat > MySQL on 3-5 users and above. >
Only few small comments. The above is not true. Take a look at InnoDB benchmarks on InnoDB site. > It is also the case that most commercial products supports better > optimization methods than MySQL. Two important things are caching statement > compilations at the server and stored procedures. If I have a performance > problem in my database it is often the case that I can improve things by > putting some SQL-code in a stored procedure. cacheing queries will be soon release in 4.0 branch and stored procedures are available via myperl, which should be found on our portals pages. -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php