I am thinking to use only Stored Procedures while developing Library Management System in Java with MySQL. But some articles show that only using Stored Procedures is an expensive method开发者_如何学运维, due to the metadata retrieval that the driver performs to support output parameters. So, performance reason it is not recommended. Just use queries in your developments.
So, is it recommended to use only stored Proedures or not?
Strong reasons with logics are welcomed!
Yes this is right that there is performance issue of stored procedure so if you want to developed "online public access library catalog" (OPAC), better to use queries but if your application is to be used only in your organization stored procedure will help you to get rid of massive queries.
精彩评论