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”