Remove deployment table for a type for Production System

[Former Member]

In the current project(which is live), we have a type CSCategory with the deployment table. CSCategory extends Category. There are many references to CSCategory from other types. It could be 1-1, 1-N or N-N.

Obvious, this leads to performance issue and we are facing it. So we want to remove the deployment table for CSCategory type.

I know this

any better approach?

Or only way is to export CSCategory data along with dependent types data and reimport it?

[arvind-kumar_avinash]

AFAIK, there is no better way (i.e. you will need to export CSCategory data along with dependent types data and reimport it). The only couple of things that I would like to add here are:

1. System update does not remove the table from the database. You will have to drop it directly from the database > remove the entry from ydeployments > remove it from items.xml > an clean all > perform the system update.

2. Make sure you have the database backup and rollback strategy in place before you try this.

[Former Member]

Oh no, I think that is the way which I don't want to go

[former_member624549]

The link you reference suggest to remove the deployment in items.xml (and do an update system). Now a flexible search will query the Category table (instead of the CSCategory table). Of course there is no data there yet so you must import all your CSCategory items. The impex must reference all the dependent types. You require an export of categorycategory relation and categoryproduct relation as well (maybe more).

Not sure if hybris accepts the removal of the deplyoment table. The typesystem might get confused because the type is already there and now changes the database table. Maybe you must create a new type CSCategoryNew with no deployment table and export CSCategory then reimport to CSCategoryNew and change alle the code references.

expect an noneasy process

[Former Member]

No, it won't be a good solution to change the type and its references in the code.