[veenuisthebest]

Hiii..

I have 2 different vb databases, small enough, just around 10-12 MB each.

Now, issue is that my Site A has a very optimized database BUT my Site B doesn't.
Reason I say this is simple:-

1. Both have same resources, same db size but Site A runs smooth and faster than Site B.

2. When I try to optimize databases from admincp, Site A optimises in not more than 2 seconds and shows "Table is up to date" for almost every table WHEREAS Site B hangs inbetween while optimization, and I have to do it per 10-20 at a time. It hardly shows "Table is up to date" for any table.

3. Now, while investigating the issue, I noticed that tables in Site A show very accurate Data Length for every table BUT Site B has most of the table's Data Length to same 16 KB each (even when they are empty i.e. 0 bytes). Its something similar with both site tables Index Length too.

So, how do I make Site B as good as Site A. That 16 KB is surely some problem.

Thanks