2 replies to this topic

[vladikov]

So here we go..

I'm using CS-Cart(it's a shopping cart software) and has been modified the design look and everything.

My problem is on the CS-Cart database has 201 tables and some of them are not being used, so my question is, is it possible to remove or merge the tables into smaller groups, like 10-20 tables perhaps?

I've ever tried to remove one table and it's a chaos even if I've tried to change the php code too.

If there's any person in this forum could do this changing I would hire you, thanks.

Regards,
Vlad.

[fayyazlodhi]

You need to understand that removing tables is not a trivial task,

First - your db design needs to be modified to accommodate this. At the very least you need to remove all foreign key relations with the tables to be deleted.

Secondly, you mentioned you are using the software which means code must have been written to access the database which must be using joins, table names and all sorts of queries. They all need to be modified.

You should have a good enough reason to go through all this effort.

[WingedPanther]

If you don't know why the tables are there, then removing them is NOT safe. 201 tables is not all that many, for a professional application. You would do well to start by looking through the source code to understand the purpose of each table. Also, if you are denormalizing the database simply for the sake of having fewer tables, you could cause problems down the road.