As I understand stored procedures:
Stored procedures offer a level of performance that you normally can not
replicate in code. The stored procedure actually has the query stored in the
query parser ready to rumble. You do not have to invoke network or socket
overhead in calling a long query and you do not have to invoke the query parser
at each invocation of the procedure. Hopefully, the procedure takes advantages
of the caches found in most database servers. Theoretically, the performance
gains are tremendous if you can knock out network access and the CPU cycles of
parsing the query.
That being said, I am a fan of MySQL and would use it over MSSQL any day. Not
having sub-selects, stored procedures, and until recently transaction support I
have found programmatic methods to get around these issues.
My experience has been this - let the application that is closest to the data do
the manipulation. This is true if the primary purpose is to store, retrieve,
and manipulate data. So, when MySQL supports stored procedures you will see,
again, a jump in usability and performance.
> Quoting robert_rowe <robert_rowe@stripped>:
> > I'm lead developer for a company that writes custom software for the
> > industry. We support MSSQL and MySQL. I've found that from a programming
> > aspect (VB + ADO) there is relatively little difference between MSSQL and
> > MySQL. There is some sight syntax differences and MySQL versions < 5.0 do
> > support stored procedures. We use the InnoDB table type for MySQL as it
> > provides row level locking and transactions. Our largest client has about
> > gig of data and averages 125 users. I've found that MySQL usua
> > lly out performs MSSQL if you tune it properly and use good programming
> > techniques. It is less integrated with Microsoft products though so if
> > clients will be accessing the data via MS Office applications then MSSQL
> > seem easier. We offer both platforms mainly because a lot of IT managers
> > convinced that Microsoft solutions are the best even when benchmarks say
> > different.
> I admit to dome degree I am one of the IT Managers - the it 'sounds to good
> be true' syndrome I suppose. But I'm coming around. The decision will be for
> MSSQL Server due to us using other MS products and the supporting of one
> product, but I'm interested for future reference when it does become an
> (probably other jobs).
> As an aside, stored procedures seem to be a big thing with some people,
> the MS people I encounter (the ASP.NET mantra of using stored procedures for
> databases access and even processing tasks), yet people seem to get along
> them fine, until recently, in MySQL.
> This makes me thing they may not be the holy grail people say they are...in
> MySQL, until recently, all SQL must have been done at the code level rather
> at the database server level - is that a major issue? Does it even provide
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1