Re: When to use Stored Procedures

2010-04-18 Thread Shawn Green
Hi Johan, Johan De Meersman wrote: as a totally off-topc question, wouldn't something along the lines of LIMIT COUNT(*)/2, 1 do that trick? On 4/15/10, Rhino wrote: ...snip... For example, suppose you had to determine the median grade for a test. ... That would require running the query

Re: When to use Stored Procedures

2010-04-17 Thread Johan De Meersman
as a totally off-topc question, wouldn't something along the lines of LIMIT COUNT(*)/2, 1 do that trick? On 4/15/10, Rhino wrote: > > > Shawn Green wrote: >> Tompkins Neil wrote: >>> Hi, >>> >>> I've used mainly of the older versions of MySQL. However am looking >>> to port >>> a application acr

Re: When to use Stored Procedures

2010-04-15 Thread Rhino
Shawn Green wrote: Tompkins Neil wrote: Hi, I've used mainly of the older versions of MySQL. However am looking to port a application across to MySQL 5. My question is when would one decide to use a Stored Procedure over a query written at the application level ? The decision to encap

Re: When to use Stored Procedures

2010-04-15 Thread Shawn Green
Tompkins Neil wrote: Hi, I've used mainly of the older versions of MySQL. However am looking to port a application across to MySQL 5. My question is when would one decide to use a Stored Procedure over a query written at the application level ? The decision to encapsulate a particular proce

When to use Stored Procedures

2010-03-30 Thread Tompkins Neil
Hi, I've used mainly of the older versions of MySQL. However am looking to port a application across to MySQL 5. My question is when would one decide to use a Stored Procedure over a query written at the application level ? Cheers Neil