Title: System performance
Last modified: August 29, 2023

---

# System performance

 *  Resolved [Damian](https://wordpress.org/support/users/flexcode/)
 * (@flexcode)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/system-performance/)
 * Hello.
 * My blog have around 15k post, 20k images.
 * Table mgmlp_folders = 37,606 rows.
 * I try use option:
 * `Add an index to the postmeta table. _Recommend for sites with a high number 
   of media files. Uncheck to remove the index._`
 * But while save, and page reloaded -> these option is unchecked. Why?

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Thread Starter [Damian](https://wordpress.org/support/users/flexcode/)
 * (@flexcode)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/system-performance/#post-17011133)
 * I change max_execution_time = 0, php memory 6gb, but still see alert: 500 Internat
   server Error. Request Timeout;
 *  Thread Starter [Damian](https://wordpress.org/support/users/flexcode/)
 * (@flexcode)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/system-performance/#post-17011634)
 * I found one problem more:
 *     ```wp-block-code
       [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Obyrn_Wieliczka/_resampled' and pm.meta_key = '_wp_attached_file'' at line 3]
       SELECT ID FROM th_posts LEFT JOIN th_postmeta AS pm ON pm.post_id = ID WHERE pm.meta_value = 'assets/Wywiady/2013/d'Obyrn_Wieliczka/_resampled' and pm.meta_key = '_wp_attached_file'
       ```
   
 *  Plugin Author [AlanP57](https://wordpress.org/support/users/alanp57/)
 * (@alanp57)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/system-performance/#post-17012526)
 * We recommend setting the max execution time to at least 600.
 * You could try adding the index manually through phpMyAdmin in your site’s control
   panel. Open phpMyAdmin. Click on the SQL tab. In the Sql edit area enter:
 * `ALTER TABLE <postmeta table name with prefix> ADD INDEX mg_meta_value (meta_key
   ASC, meta_value(255) ASC);`
 * Replace `<postmeta table name with prefix>` with the acutual postmeta table name
   and click the go button.
 * If you need to remove the index, the SQL for that is:
 * `DROP INDEX mg_meta_value ON ``<postmeta table name with prefix>`;
 * As for the other issue, it looks like you may have a folder name containing an
   apostrophe. As apostrophes are used as delimiters in code, you need to rename
   the folder and either add a backslash (\) before the apostrophe or remove the
   apostrophe to avoid generating errors.
    -  This reply was modified 2 years, 9 months ago by [AlanP57](https://wordpress.org/support/users/alanp57/).
 *  Thread Starter [Damian](https://wordpress.org/support/users/flexcode/)
 * (@flexcode)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/system-performance/#post-17014797)
 * Hello.
 * I use this SQL query and help our page.
   I fixed name dirs too.And now i see folders
   in our backend. So i think thats all. Thank you.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘System performance’ is closed to new replies.

 * ![](https://ps.w.org/media-library-plus/assets/icon-128x128.jpg?rev=1814048)
 * [Media Library Folders](https://wordpress.org/plugins/media-library-plus/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/media-library-plus/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/media-library-plus/)
 * [Active Topics](https://wordpress.org/support/plugin/media-library-plus/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/media-library-plus/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/media-library-plus/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [Damian](https://wordpress.org/support/users/flexcode/)
 * Last activity: [2 years, 9 months ago](https://wordpress.org/support/topic/system-performance/#post-17014797)
 * Status: resolved