Stored procedures are essential to any app that process large amounts of data. Otherwise you are left processing everything on the client side, much slower then on the database side. Plus when you get into working with the good stuff (oracle) you can do much more then just retrieve data like pass objects directly from java to the database. For smaller apps they may not be necessary, but any large scale operation wouldn't work w/o them...
I think MySQL has a long ways to go before it will really be a contender. I know that is used widespread for small web setups, but before version 5 it really didn't have many of the standard features the bigger players had such as stored procedure support or even sub queries.
my $0.02...
Slashdot Mirror
Stored procedures are essential to any app that process large amounts of data. Otherwise you are left processing everything on the client side, much slower then on the database side. Plus when you get into working with the good stuff (oracle) you can do much more then just retrieve data like pass objects directly from java to the database. For smaller apps they may not be necessary, but any large scale operation wouldn't work w/o them...
my $0.02...
I think MySQL has a long ways to go before it will really be a contender. I know that is used widespread for small web setups, but before version 5 it really didn't have many of the standard features the bigger players had such as stored procedure support or even sub queries. my $0.02...