Reply To: Increased Records and Data size of few Tables. Want to optimize Database n Table

Hello Luke,

I think you misunderstood the query. I did not mean to say to access the DB directly.
My query is actually related with theme or options somehow.

Actually we simply wanted to know, if we Delete few of the Color Attribute’ s terms (say Yellow, pink, red ..), then which database table it is related to out of these-
wprt_postmeta
wprt_options
wprt_termmeta
wprt_term_taxonomy
wprt_term_relationships

We do not alter the Database directly, nor we wanted to. In this example case, we will only delete the attribute’s terms (yellow, red – Color)

Your idea about this can help me a lot to refine and minimize the size of DB table record, count.

Similarly, can you please suggest what are these below ones (Tables) directly related to the option (like product, attributes, images or any other)–

wprt_postmeta
wprt_options

https://i2.paste.pics/56c78cd927bd330ba0ff5b68403c5670.png

Means, what we add in our site, so that the Database Record Count and Data size increases for these database tables. So that we can refine them directly without doing Hit and Trial.

Regards