Housekeeping on eva database

Status: 

Closed

Priority: 

N/A

Test URL(s):

References:

Request(s):

It was found that there are 4 database table prefixes in Evaluation Services website.

Two of them are not needed. So tables with those two prefixes should be removed.

The database size will be significantly reduced and website performance and maintenance could be improved.

Four sets of table prefixes
1. 22ev_
2. D3oY8Frl_
3. fbu_
4. st_
 
 
prod site
Approx. changes after unused tables dropped 
Total table #
185
39
Total table size
239.1 MB
87.9 MB
Total Rec #
~960,335
~824,929
Total table prefix
4
2
 

1 thought on “Housekeeping on eva database”

Leave a Comment