This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

This topic contains 3 replies, has 2 voices.

Last updated by Bruno Kos 4 months ago.

Assigned support staff: Bruno Kos.

Author Posts
June 14, 2019 at 6:49 pm #4023779

Euro Segway

Just wonder that on the web having ~100 pages we have icl tables ~130 Mb
Is that normal?
Screenshot hidden link

June 15, 2019 at 7:23 am #4025731

Bruno Kos
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hi,

Thank you for contacting WPML support!

It really depends on how much content have you translated - for example, the two tables I see that have the biggest size are the following:
- icl_translation_status shows the status about translated content
- inside wp_icl_translations are all translation relations

Can you tell me approximately how much pages/posts/custom posts have you translated? These tables are filled automatically and you cannot remove them because they are required by WPML core. So So unless you are experiencing some issues with your website - especially with the WPML part - there's nothing we should do related to the sizes of these tables.

Regards,
Bruno Kos

June 15, 2019 at 9:25 am #4026219

Euro Segway

Hi,

We have less than 100 pages/posts/custom posts total in English; translated to 6 languages.
We are experienced in php/ mysql but do not know the structure of wpml tabels.
Is there any way to optimize it?

June 17, 2019 at 9:26 am #4033939

Bruno Kos
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hi,

You can find some of the information related to database tables here:
https://wpml.org/documentation/support/wpml-tables/

While as for the optimization functions, have a look here:
https://wpml.org/forums/topic/database-optimization-tool-for-wpml/#post-664629
https://wpml.org/forums/topic/database-table-icl_string_pages-too-big/#post-3222102
https://wpml.org/forums/topic/string-translation-clean-up/#post-791058

This would cover all the options you can use to optimize database size.

Regards,
Bruno Kos