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

[harshwe]

Hello Luke,

I know, this may be Just a basic question for you, but wanted to know further about few of the Tables from database entries in respect to Theme and site. (mainly Products)
Would appreciate to receive your kind and helpful response on below query.

We found below database Table entries with somewhat large number of Record entries and bigger data sizes.
Wanted to know, with which features or options of site these entries are related to respectively.

https://i2.paste.pics/960a75f94c9d9db901fc4cdd14a97de0.png

Means, say with-
a) Product Attributes (color, size) which one is directly related out of these below ones-
wprt_postmeta
wprt_options
wprt_termmeta
wprt_term_taxonomy
wprt_term_relationships
wprt_term_relationships

Similarly for-
b) Product name
c) Attribute terms (like, pink, red, white – or any Color value)

We are asking this, as we can try to reduce few of the color attribute terms and few product tags by removing them from our site. In order to minimize the Record and data size of relevant Database table. But we are not sure, which one is actually related to which one.

We understand we can optimize database with the help of WP Optimize or any similar plugin. But for testing purpose, we tried by first Optimizing wprt_options table, but everytime, it reduces few Record count.
But then when we try to optimize further, it then again increases the Record Count and keep going Up-and-down like this way. So this does not seems a Proper or working solution. So, if there is any correct or proper solution then please suggest us.

Also, please suggest on above, so that we can directly Delete Extra or unwanted few of the Product Tags and Color attribute terms as well.

Also, can you please suggest what are these below ones (Tables) directly related to –
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

Regards

• This topic was modified 1 year, 8 months ago by harshwe.

Hello,

Sorry to say that, but such customization is not included in our support.

You can get acquainted with Envato Support Policy here:

https://themeforest.net/page/item_support_policy

We do not recommend accessing the database without specialists, contact the hosting, maybe they will help you.

I do hope you would remain as our valued customer and thank you for your time.

Kind Regards

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

Hello,

If you delete any color, it will be deleted from the wprt_termmeta table.

You can independently learn which table corresponds to why:
https://codex.wordpress.org/Database_Description

Kind Regards

[harshwe]

Hello Luke,

Thank you so much. This is what I wanted to ask and wanted to know about.

Just 2 things –
a). Curious to know, why the prefix is termed as wprt_ and Not wp_

I mean, the official link that you shared is also showing wp_ (as Database table prefix) and also during searching on Google also it shows wp_ for All table prefixes
But Google Searches never shows the results with wprt_

So from where, this wprt_ is exactly coming from or defined. Is it because of the Woodmart Theme or for some other reason.

b). If wprt_termmeta table shows color values (Attribute’s terms like Blue, Green)

Then what table is for the Attribute itself. That is for Size, Color, Material and so on..
Is it wprt_term or some other.

Regards

• This reply was modified 1 year, 8 months ago by harshwe.

Hello,

When you created WordPress, you set the wprt_ prefix, which is why you kept it. The default database table prefix for WordPress is ‘wp_’; however, recommend changing it. The reason for this is that all your login details are stored in your database, making your WordPress tables very popular targets for hackers. Changing the prefix makes it harder for them to break in.

Kind Regards

Hello Luke,

Thank you for clarifying.
a) So you mean to say that we should keep it as it is. That is with some additional prefix. Means wprt_ is recommended and suggested. Instead of wp_ alone

b) I think this point got skipped somehow. Can you please suggest
If wprt_termmeta table shows color values (Attribute’s terms like Blue, Green)

Then what table is for the Attribute itself. That is for Size, Color, Material and so on..
Is it wprt_term or some other.

Regard

Hello,

a) Yep, you are right.

b) In the documentation on the WordPress database that we sent to you above, it is indicated that the wp_termmeta table stores only the name, tag and id of the term or attribute. And all other options that you see on the attributes or terms page are already stored in the wp_termmeta table.

Kind Regards

[Author]

Posts