Cart is empty
Client’s Problem and Tasks
At the time of contacting us, the client’s online store has accumulated more than 150,000 completed orders. All of them continued to be stored in the database. When forming a list of orders, the database had to extract a large amount of information, which made it difficult to work with the administrative part of the online store and highly loaded the server. When the administrator was searching through the list of orders, the system hung up completely and returned an error. The work of the administrator was paralyzed.
Our Work Process
In order to reduce the load on the database, our developers have moved obsolete orders to separate tables for archiving. At the same time, all data was saved: archived orders can be found through a simple search and view all the details of shipment, payment, etc.
In order to automate the archiving of orders, we have developed the following functionality: when an order is, for example, 1 year old (or some other arbitrary time set by the administrator), all order data is transferred to the archive table and this action frees up space for active orders. The action is carried out according to a given schedule using CRON.
A special script checks whether all order properties have been correctly transferred to the archive tables. If there are no errors, the order is removed from the main table. This check prevents data loss during archiving.
If you need to disable archiving for some orders, you can do it manually by editing the order.
We added custom fields to order search. Now orders can be searched not only by status, but also by customer’s phone number, country, VAT, etc.
Our Work Results
- The online store can accept even more orders without losing speed: the list of orders is loaded in 0.005 seconds.
- The work of the administrative part has been debugged: convenient and fast order management has been reached.
- Data loss during archiving is excluded thanks to a special script.
Diamandino — Online Store of Everyday Consumer Goods
Services
Add-on/modification development
Need custom functionality for your store? We develop apps, modifications, and integrations to meet your unique requirements. Reliable and professional solutions.
Client’s Problem and Tasks
At the time of contacting us, the client’s online store has accumulated more than 150,000 completed orders. All of them continued to be stored in the database. When forming a list of orders, the database had to extract a large amount of information, which made it difficult to work with the administrative part of the online store and highly loaded the server. When the administrator was searching through the list of orders, the system hung up completely and returned an error. The work of the administrator was paralyzed.
Our Work Process
In order to reduce the load on the database, our developers have moved obsolete orders to separate tables for archiving. At the same time, all data was saved: archived orders can be found through a simple search and view all the details of shipment, payment, etc.
In order to automate the archiving of orders, we have developed the following functionality: when an order is, for example, 1 year old (or some other arbitrary time set by the administrator), all order data is transferred to the archive table and this action frees up space for active orders. The action is carried out according to a given schedule using CRON.
A special script checks whether all order properties have been correctly transferred to the archive tables. If there are no errors, the order is removed from the main table. This check prevents data loss during archiving.
If you need to disable archiving for some orders, you can do it manually by editing the order.
We added custom fields to order search. Now orders can be searched not only by status, but also by customer’s phone number, country, VAT, etc.
Our Work Results
- The online store can accept even more orders without losing speed: the list of orders is loaded in 0.005 seconds.
- The work of the administrative part has been debugged: convenient and fast order management has been reached.
- Data loss during archiving is excluded thanks to a special script.
