A database index is a data structure that improves the speed of operations in a table. Indexes can be created using one or more columns, providing the basis for both rapid random lookups and efficient ordering of access to records.
Since LS eCommerce – Magento uses flat tables to fetch and store data coming from LS Central, it was crucial to improve the overall data processing speed of these tables. For that purpose, database indexes have been introduced and added on required columns considering the fact that those are frequently used in queries and joins during replication.
Some indexes are common among all the replication tables as mentioned in the table below.
| Name | Description |
|---|---|
| scope_id | Tells you to which store in Magento the row belongs. |
| processed | Flag to check if data is already copied into Magento. 0 means data needs to be copied into Magento tables and 1 means already copied. |
| is_updated | Flag to check if data is already updated from LS Commerce into Magento. 0 means already updated and 1 means needs to be updated into Magento tables. |
| IsDeleted | Flag to check if a record is deleted from LS Central or not. 1 means already deleted and 0 means not deleted. |