E-commerce websites rely heavily on databases to deliver information, therefore it is crucial to have an optimally running database system. Comrogen uses the Microsoft Sql Server family of databases and includes various tools to optimize database by rebuilding indexes, tuning category views, clearing out old session data as well as maintaining log size by trimming outdated information.

Database maintenance can be scheduled in the system to happen automatically at the interval specified by admins, this process uses the web services system and will not interfere with website activity, however, it is recommend to schedule maintenance at night where it will have minimal impact on website performance.

Perhaps the most critical aspect of an e-commerce website is securing database information, this includes not only your product catalog and categories, but also customer information, orders, as well as all store settings needed to run your store. Comrogen is one of the few e-commerce systems that allows admins to create database back-ups form within the administration without having to contact a database administrator or hosting provider.

NOTE: This option may only be available with a cloud, virtual, or dedicated server. Databases can also be scheduled to be backed up automatically at an interval specified by site admins (again, we recommend doing this during off peak hours to minimize impact on site performance).

Comrogen also supports the ability to restore your database, if you have had a bad update or other issue where a previous version of the database needs to be re-loaded, the administration console will allow you to restore your database back to the last backed-up version.

NOTE: This option may be disabled as in certain situations you may require a Merged backup, where new orders/customers may need to be carried over to a later backup.