Now engaged in the development of ERP system in manufacturing, the most complex business is implemented in the process of storage, although now volume small, the parallel pressure is not big, but the later problem certainly, if after the business code is written in c #, database application and return to the most basic (add and delete), add and delete database is to use stored procedures to achieve? Just pulled out the data in the table, the back-end using Linq implementation? Using WebServiec each table is divided into an interface, whether also can relieve stress

CodePudding user response:

This person cannot treat as the same, want to see the actual business scenarios, in some cases, absorbs pressure also increased pressure on the server as a whole, and vice versa,
My experience is, in the work of data integrity requirements is not high, is separate, instead just use stored procedures to database one-time finish,
In addition, this also has a certain relationship, and database such as oracle itself is stronger, no matter how you can be, but if mysql is washed-up, sometimes writing instead of in the process of storage efficiency is low,
All in all, my personal understanding, this is not a pure database problem, the key is your business logic,

CodePudding user response:

What you said may be complex business data processing and reporting, to distinguish them, take the production, the production plan, set a plan generation to preset information is business,
And production plan according to the information data is the data processing (process is very complicated but just a result, the user does not need to know about the middle of the process,)
This action of a large amount of data processing, use stored procedures of database is the most convenient and easy to maintain, (even can make a data processing server alone, pull the underlying data used to calculate a result to write back, to prevent the collapse of business database,) if you use is essentially a focus on the use of a temporary table, only need to increase the memory, and can greatly increase the computing speed,

CodePudding user response:

You know, now this is not on the system, or learning from others' experience is given priority to,
===
Now engaged in the development of ERP system in manufacturing, the most complex business is implemented in the process of storage, although now volume small, the parallel pressure is not big, but the later problem certainly the ,
You this question, the greater the judgment, there is no actual basis, to know that under normal circumstances, stored procedure is the highest performance, rather than through the c # implementation,

Later, if the business code is written in c #, database application and return to the most basic (add and delete), add and delete database is to use stored procedures to achieve?
From here you can see, you of the stored procedure is stem what of, is not clear, it also suggests that the greater the problem of what you said above is also a random judgment, because you never know what stored procedures to do, then you all judgment of stored procedures, is deviating from the facts,
I think, the main purpose of the stored procedure code is consolidation, improve performance, so an insert statement, encapsulated with a stored procedure, can improve performance, so can improve degree of encapsulation?


Just pulled out the data in the table, the back-end using Linq implementation? use WebServiec each table is divided into an interface , whether also can alleviate pressure
A table a webservice, did you watch the more blog garden, webservice is also out of technologies, you also take out,

CodePudding user response:

Question is that you need to accept new things, even you standard Sap ERP are beginning to use ETL, Spark, storm, datalake, grahpsql

IT all over the world on the discussion of Big data, middle office, what are you talking about the insert, select a list in discussing a webservice

Ps: by the way, Bigdata not XX garden think what tens of millions of data, hundreds of millions of data, what left join, index, not people self anesthesia here "I am not a Bat, I can't contact with these, what a suck.net is the bottom"

Bigdata is derived from a book "Big Brother" -- -- -- -- -- -- -- -- -- -- Big not Big, Big represents the ubiquitous, in terms of ERP, it is ubiquitous, typical people want to build ERP, is want him everywhere, so, you should go to care about "ubiquitous" technology, rather than discuss a table, a few left the join