RE: mySql versus Sql Server performance

2010-10-26 Thread Patrick Thompson
ts current incarnation - so I consider it to be accurate, at least in that respect. Patrick myList - everything you could possibly want (to buy) -Original Message- From: Gavin Towey [mailto:gto...@ffn.com] Sent: Tuesday, October 26, 2010 3:52 PM To: Patrick Thompson; mysql@lists.mysql.c

RE: mySql versus Sql Server performance

2010-10-25 Thread Patrick Thompson
Sorry, that should be 200MB not 20MB (still doesn't seem like much to me) Patrick myList - everything you could possibly want (to buy) -Original Message- From: Patrick Thompson Sent: Monday, October 25, 2010 5:24 PM To: 'Gavin Towey'; mysql@lists.mysql.com Subject: RE: m

RE: mySql versus Sql Server performance

2010-10-25 Thread Patrick Thompson
'0' 'innodb_mirrored_log_groups', '1' 'innodb_open_files', '300' 'innodb_rollback_on_timeout', 'OFF' 'innodb_stats_on_metadata', 'ON' 'innodb_support_xa', 'ON' 'innodb_sync_spin_loops&#

RE: [SPAM] RE: mySql versus Sql Server performance

2010-10-25 Thread Patrick Thompson
list.com/> - everything you could possibly want (to buy) From: Martin Gainty [mailto:mgai...@hotmail.com] Sent: Monday, October 25, 2010 3:53 PM To: Patrick Thompson; gto...@ffn.com; mysql@lists.mysql.com Subject: [SPAM] RE: mySql versus Sql Server performance Importance: Low Patrick- you'll w

RE: mySql versus Sql Server performance

2010-10-25 Thread Patrick Thompson
LT CHARSET=latin1; This is just the retrieve side - which seems to be around 1.5 times slower than the equivalent Sql Server numbers. The update is much slower - 3 to 5 times slower depending on the record size. It makes sense to me to focus on the retrieve, maybe the update is just a reflecti

RE: mySql versus Sql Server performance

2010-10-25 Thread Patrick Thompson
list.com/> - everything you could possibly want (to buy) From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De Meersman Sent: Monday, October 25, 2010 9:55 AM To: Patrick Thompson Cc: mysql@lists.mysql.com Subject: Re: mySql versus Sql Server performance I merely skimmed it, but y

mySql versus Sql Server performance

2010-10-25 Thread Patrick Thompson
I am running an open source project that provides an abstraction layer over a number of different stores. I am puzzled by performance numbers I am seeing between mysql and sql server - a brief discussion is available here http://cipl.codeplex.com/wikipage?title=Data%20Provider%20Comparison The