Clean database by simple board means of JTL
How to clean your Microsoft SQL database, which JTL tools (e.g. compress images or clean records) can help you and why you should do this at all, is answered by Andreas Bezuh of ecomDATA GmbH. Database optimization is a subtask in JTL SEO.
eBakery is a JTL service partner and eCommerce agency specialized in SEO and SEA. As a JTL agency, we support you in the conception and planning of your JTL store, including the interface to the most important Internet sales portals/marketplaces such as eBay, Amazon, Rakuten, Hood.de and real.de. Our focus is always on the development of a solution individually adapted to you, including a synchronously working merchandise management system (e. g. B. JTL Wawi) with professional warehouse management.
YOU MIGHT ALSO BE INTERESTED IN:
What can JTL offer you?
Depending on how long you’ve been in eCommerce, you’ve certainly dealt with various ERP systems. Are you already using JTL? The JTL ERP system is an innovative and free ERP system that allows you to centrally control and manage all your work processes. In addition to JTL-Wawi, JTL has developed countless other functions that enable you to generate long-term success thanks to automated processes. Because JTL adapts perfectly to your needs. In addition to merchandise management, JTL also offers professional warehouse management or a cash register system. ecomDATA generally deals with modern hosting methods and is a specialist in the field of JTL. Therefore ecomDATA can answer your question how to optimize your JTL-Wawi database and which JTL tools you need for that.
Clean database
Namely, you have the possibility to start a cleanup via the JTL database management. With the cleanup you can define several options, e.g. that inactive articles are deleted or that logs are removed that are already older. This will give you more space in the database. Another option is to see how big your images are and if they can be resized. Image sizes in the JTL-Wawi database, you can find under Check articles and image sizes. To compress images, JTL-Wawi has an additional function. For example, you can use it to search for images larger than 500 KB and display them. And if you want, you can eventually have them scaled down.
Workflows can fill database quickly
Regardless of whether it is a JTL database or a SQL database, how would a professional go about cleaning it up? ecomDATA, for example, would first run a query to look into the database to see which table requires large storage space. Queries read databases, but also files from other IT systems. This way you can find out where exactly the problem lies. For example, if you have generated a lot of sales and have many workflows active, those very workflows can write logs to the database that take up a lot of memory. In such a case, a table can quickly become full and occupy the database with 10 GB. If they are really only logs, you can easily delete them and keep only those of the last 2 weeks, for example. If you do all this, you will have gained quite a bit of storage space.
Data cleansing is always worthwhile
You can also check whether data in the database is really used to the extent that it consumes space. A database does not free space immediately after you delete something. In any case, you should always check if certain logs populate a database before purchasing a SQL Standard server. In summary, there are several ways to clean up your database. Deleting inactive items, compressing images and definitely checking logs are just a few of them. Freeing up disk space is always a sensible thing to do in any case, because a full database can slow down certain work processes. Furthermore, you can only create reliable evaluations if your data is error-free, e.g. not duplicated in the database, and correctly displayed.
You want to clean and optimize your JTL-Wawi database?
Want to clean up your database and do it right? For further questions or information, feel free to contact ecomDATA or us. Our experts can also give you other valuable tips on eCommerce.
- 0/5
- 0 ratings
Very bad! | Bad | Hmmm | Oke | Good! |
---|---|---|---|---|
0% | 0% | 0% | 0% | 0% |
Do you have questions or need an individual offer? Do not hesitate to contact us.