-
The combination of management and software optimizes management first, and then optimizes ERP according to management
-
Does your company use ERP or develop ERP?
If you just use it, you can only optimize the business process.
If you want to develop, then optimize the system process, optimize the database, optimize the query table report, and so on.
-
Optimization process, database optimization, etc.
-
What kind of software is your ERP, different software will be different.
-
Data, maybe you don't think it's useful now, it's summarized, and you don't know when it's going to be used in the future.
Therefore, no matter what optimization method is, it is unscientific.
That can only be said, deal with your most pressing needs.
For example, if your ERP system is slow due to too much data, then one is to find a way to upgrade the hardware, the second is to find a way to optimize the database, and the third is to refer to a better algorithm.
In terms of optimization, you can add indexes, change views, optimize stored procedures, and remove some data that is currently useless, and this last one is often the most effective.
Therefore, many ERP software adopts the year-end method, and the speed of building a new database every year will be significantly improved.
However, the time period and granularity of segmentation should be closely related to the volume and scale of enterprise data.
In doing so, the loss is historical data, or the convenience of historical data analysis is sacrificed, and the existing data processing capacity is improved.
Then, when you solve the existing contradictions and need to mine information from historical data, you should introduce data mart technology to slice and analyze data independently of the ERP system.
Therefore, in order to be able to carry out effective analysis in the future, I would recommend that the optimization method you adopt must be to improve the processing speed of the existing ERP system without compromising the historical existing data. This needs to be supported by your software vendor, or you as a software vendor need to consider it.
-
There are several areas that need to be optimized.
Optimization of ERP procedures and systems.
Database optimization.
For the two points, it may be necessary to do it separately, find ERP development and maintenance personnel, see which program and which function are affected by speed and efficiency, and optimize, modify the program and modify the process in order to achieve the desired effect.
database, you have to ask a special DBA to do it, adjust their respective parameters to solve the bottleneck, very professional work.
-
If you are an enterprise user, please contact your IT department.
If you are an implementer, please consult with your company's developers.
If you are just learning, please learn database SQL, oracle related knowledge database optimization is a very professional technology, not just casual can be said clearly and done well.
-
ERP is a good thing, and it plays a role in enterprise management like a high-speed train, but if it can only do inventory statistics, process maintenance, financial management, procurement and sales management, it is not a real ERP, but an inventory statistics program.
-
It depends on your own understanding of the society. and their own worldview. Your SEO and ERP should be the mainstream of the Chinese IT market now and later.
ERP is still a little early for the Chinese market. As long as China's first-tier cities are still aware of the importance of ERP.
Kwon Sang-woo and Son Tae-young are about to get married. >>>More
Uric acid mainly comes from the body's metabolism of purines and nucleoproteins. However, it is greatly affected by external factors, such as eating animal offal, beef and mutton, seafood, shrimp and crab, mushrooms, bone marrow, etc., which are rich in floating foods, and then go for examination. The experimental data is not necessarily the same in different laboratories, because the actual operation methods used are different (150-416 males and 89-357 females in our laboratory. >>>More
BPR: Emphasizing the transformation of business processes as the object and center, with the goal of caring for customer needs and satisfaction, and fundamentally rethinking and thorough redesigning of existing business processes. >>>More
I think my favorite anime "Spirit Cage" is finally online, and I update two episodes at a time, isn't it enjoyable to watch? But what exactly are we here to see the cage? I believe that many friends will talk about "Fantasy Nordlin", but unfortunately, Fantasy Nordlin is permanently suspended, let alone in his lifetime, and even the grandson of his grandson can't see it. >>>More
Hand tremors are one of the common symptoms of hyperthyroidism, and the typical symptoms of hyperthyroidism include hand tremors, palpitation, heat intolerance, and sweating. In addition to hand tremor as a typical symptom of hyperthyroidism, there are some other symptoms, such as some patients will have protrusion, and some patients will have thick neck swelling, which is manifested as goiter, which is what people call big eyes and thick neck disease.