3 ms·
Cleanup - Probably one the most effective but often ignored tips for DB management. Do you really need all that data in real time? Are you querying all of it in
by gauravgupta 13y ago
Cleanup - Probably one the most effective but often ignored tips for DB management. Do you really need all that data in real time? Are you querying all of it in your app? If not, it makes sense to archive parts of it to another disk. The size reduction would boost performance tremendously.
- webvet 13y ago>Do you really need all that data in real time? Are you querying all of it in your app? Yes and yes. ALL the data records could potentially be queried via site navigation.