Hi Jason,
I have one client on a dedicated server. They process about 200,000 transactions daily and have 20,000 visitors daily to the website. We started with MYSQL. As the database grew, the performance decreased. We then switched over to MSSQL server and the performance was increased by 35%. We did this as a test. Because the price for the license is high, we also offered Pervasive SQL which is considerably less expensive. Again, the performance increase was about 30 to 35% over MYSQL. For the price, MYSQL can't be beat. But, when you're dealing with a lot of transactions and large amounts of data I prefer to use MSSQL if the client can afford it. WebLogoWhite Rick Sanders President 902-401-7689 www.webenergy-sw.com Shop online for computer systems, accessories, and much, much more! http://shop.webenergy-sw.com <http://shop.webenergy-sw.com/> From: Jason Pamental [mailto:[EMAIL PROTECTED] Sent: February 19, 2007 12:17 PM To: [email protected] Subject: Re: SPAM-MED: RE: Witango-Talk: OT: Witango hosting Stefan, Well put. I think that there is enough research out there supporting the speed and capabilities of both engines to argue forever. Simply put though, MySQL is in use in enough high-traffic and mission critical enterprise installations that any blanket statements should be taken with a grain of salt. Rick - I don't mean to take away from your own research - we all have to rely in many cases on our own perceptions and experiences. But we should all try to refrain from making statements that can so easily undermine what others in the community are doing. I would think that if Robert Garcia were to weigh in on this he could spell out a very convincing case for MySQL given the tremendous load his projects put it under on a daily basis. Of course, I use SQL Server (2000 and 2005) as well as MySQL daily, and the ease of management and use with SQL Server is amazing, so I tend to lean towards SQL Server simply because I have it - but were I faced with having to purchase the licenses myself, I'm not sure I'd feel compelled to do so. Cheers everyone- Jason ----- Jason Pamental Director of Web Services North Sails Office: 401.643.1415 Fax: 401.643.1420 Mobile: 401.743.4406 Email: [EMAIL PROTECTED] On Feb 19, 2007, at 10:21 AM, Stefan Gonick wrote: Hi Rick, Those arguments are a far cry from "yech". My point was just that Mysql is a reasonable database and it's free. It doesn't deserve that kind of negative comment, which indirectly casts aspersions on With. Obviously, their site doesn't need a super high performance database, so a free one is just fine. Stefan At 10:13 AM 2/19/2007, you wrote: Hi Stefan, I won't get into a debate, but on Windows in a high-volume production environment Microsoft SQL server is the fastest hands-down, followed by Pervasive SQL a close second. I've never bench-marked MSSQL on Windows vs. MYSQL on Linux, but the research I have done stated that MSSQL is faster. Also, I've done lots of work with MYSQL and in an environment where the traffic is high, MSSQL doesn't perform well. Again, my experience has been on Windows. <6b2db6b.jpg> Rick Sanders President 902-401-7689 www.webenergy-sw.com Shop online for computer systems, accessories, and much, much more! http://shop.webenergy-sw.com <http://shop.webenergy-sw.com/> From: Stefan Gonick [ <mailto:[EMAIL PROTECTED]> mailto:[EMAIL PROTECTED] Sent: February 19, 2007 10:45 AM To: [email protected] Subject: Re: SPAM-MED: RE: Witango-Talk: OT: Witango hosting What is "yech" about Mysql? Since version 4 it has been a quite usable database. Stefan At 09:37 AM 2/19/2007, you wrote: I can't believe they use MYSQL! Yech! <6b2db7a.jpg> Rick Sanders President 902-401-7689 www.webenergy-sw.com Shop online for computer systems, accessories, and much, much more! http://shop.webenergy-sw.com <http://shop.webenergy-sw.com/> From: Wolf, Gene [ <mailto:[EMAIL PROTECTED]> mailto:[EMAIL PROTECTED] Sent: February 19, 2007 10:31 AM To: [email protected] Subject: Witango-Talk: OT: Witango hosting This is a bit off topic. I'm looking for a hosting service for my personal use. No, not business related. *laughs* If any of you offer site hosting and Witango app hosting (and perhaps database support as well) would you please send me some information pertaining to costs? Yes, I did try the Witango e-mail search looking for Hosting in the message title and received the following error message: Error An error occurred while processing your request: File: searchforum.taf Position: DirectDBMS Class: DBMS Main Error Number: 1064 [MySQL][ODBC 3.51 Driver][mysqld-5.0.22-community-max]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY w1.datereceived DESC limit 50' at line 12 23000 File: searchforum.taf Position: DirectDBMS Class: Internal Main Error Number: -101 Gene Wolf Supervisor, Business Systems DRS Sensors & Targeting Systems-Optronics 2330 Commerce Park Drive NE Palm Bay, Florida 32905 Phone: 321-309-0685 321-309-0202 (fax) Dictionary.com Word of the Day http://dictionary.reference.com/wordoftheday/ This e-mail, including any attached files, may contain confidential and privileged information for the sole use of the intended recipient. Any review, use, distribution, or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive information for the intended recipient), please contact the sender by reply e-mail and delete all copies of this message. "This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior written approval from the U.S. Department of State." ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ===================================================== Database WebWorks: Dynamic web sites through database integration http://www.DatabaseWebWorks.com <http://www.databasewebworks.com/> CoachVille: For coaches and people taking teleclasses http <http://www.cvcommunity.com/?af=69474> :// <http://www.cvcommunity.com/?af=69474> www.cvcommunity.com?af=69474 <http://www.cvcommunity.com/?af=69474> ________________________________________________________________________ TO UNSUBSCRIBE: Go to <http://www.witango.com/developer/maillist.taf> http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to <http://www.witango.com/developer/maillist.taf> http://www.witango.com/developer/maillist.taf ===================================================== Database WebWorks: Dynamic web sites through database integration http://www.DatabaseWebWorks.com <http://www.databasewebworks.com/> CoachVille: For coaches and people taking teleclasses http <http://www.cvcommunity.com/?af=69474> :// <http://www.cvcommunity.com/?af=69474> www.cvcommunity.com?af=69474 <http://www.cvcommunity.com/?af=69474> ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
<<attachment: image003.jpg>>
