Mysql stored procedure questions and app questions

Source: Internet
Author: User
When I was working on an app recently, I used the stored procedure and suddenly had some ideas. please ask me the traditional app structure. 1 app requests the web server. 2 web server. call the script language to operate on the database. 3. the database returns the result to the web server. 4 if the web server returns the result to the app, can the app directly request the db? Assuming that the db can be requested to be executed in the form of a process in the public network app segment, then the 1app requests the Database 2 the database returns data to the app, which is equivalent to saving the web server link. assuming that the db can withstand concurrency if IOcachecpu is large enough, do not consider whether such architecture is... mysqlapp stored procedure

When I was using the stored procedure for an app recently, I suddenly had some ideas.
Traditional app structure
1 app request web server
2. the web server calls the script language to operate the database.
3. the database returns the result to the web server.
4. the web server returns the result to the app

Can the app directly request the database?
Assume that the database can request
The execution in the form of a process in db becomes
1 app request database
2. the database returns data to the app.
This is equivalent to saving the web server.

Assuming that the concurrency I/O cache cpu capacity that the db can afford is large enough without considering the later maintenance and update, is this architecture feasible? What are the disadvantages?

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.