Hi I am trying to translate large number of terms via translation table. We have about 15,000 terms in a taxonomy?

When I load the page admin/config/regional/translate/table/taxonomy it uses a lot of memory and impossible to load page when having large number of terms. Please suggest what we can do in this situation?

Is there any settings to show pagination or some other approach with available settings ?

please suggest!

Thanks

CommentFileSizeAuthor
#5 taxonomy_translation_table.patch1.84 KBjas1988
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

jas1988 created an issue. See original summary.

jas1988’s picture

jas1988 CreditAttribution: jas1988 as a volunteer commented
Title: Pagination for translation taxonomy terms ? » Pagination for translation taxonomy terms not working on admin/config/regional/translate/table/taxonomy ?
jas1988’s picture

jas1988 CreditAttribution: jas1988 as a volunteer commented

More debugging I have printed query.

File: taxonomy.translation_table.inc

Function : taxonomy_translation_table_taxonomy_filtered_form

case: default

SELECT ls.lid AS lid, ls.source AS source, ls.location AS location FROM {locales_source} ls INNER JOIN {i18n_string} s ON ls.lid = s.lid WHERE (s.type = :db_condition_placeholder_0) AND (s.objectid IN (SELECT td.tid AS tid FROM {taxonomy_term_data} td WHERE (td.vid = :db_condition_placeholder_1) ))

It seems no pagination limit is working.

jas1988’s picture

jas1988 CreditAttribution: jas1988 as a volunteer commented

When we change line number 130 like below it starts working :

 $query = db_select('locales_source', 'ls')

 $query = db_select('locales_source', 'ls')->extend('PagerDefault');

I hope I am doing it in correct way ?

jas1988’s picture

jas1988 CreditAttribution: jas1988 as a volunteer commented
FileSize
taxonomy_translation_table.patch1.84 KB

I have made patch and with pagination is working in all cases. Please let me know if I am missing something and these changes are not required. Thanks!