Abaksoft Posted November 18, 2015 Share Posted November 18, 2015 Hi all, In your VPS you want best performances with your unigui application : I know that in a classical client server desktop application, the good practice is to use store procedures and let the DB server do its job. What about an unigui application wich is executed in a server. Does the dynamic query works faster on each cession or same logic (store procedure is prefered) ? Any expertise ? Thx... Quote Link to comment Share on other sites More sharing options...
adragan Posted November 19, 2015 Share Posted November 19, 2015 Each application is a combination of both. For heavy processing with lots of calculations , stored procedures works best. It's also a question of being able to rollback transactions in case something goes wrong. For displaying stuff on the screen one have to use dynamic queries. Quote Link to comment Share on other sites More sharing options...
Abaksoft Posted November 19, 2015 Author Share Posted November 19, 2015 Thank you adragan... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.