Title: Performance issue reported by our devs Last modified: August 22, 2016 --- # Performance issue reported by our devs * Resolved [Debra](https://wordpress.org/support/users/notebookingpages/) * (@notebookingpages) * [11 years, 8 months ago](https://wordpress.org/support/topic/performance-issue-reported-by-our-devs/) * Our developers found some performance issues with our site since WPPA 5.4.11 update. I just updated to 5.4.12 today, so I don’t know if the below is still a problem or if update fixes this. * Our developers reported the following: The problem is in wppa_session_start ( wp-content/plugins/wp-photo-album-plus/wppa-session.php) and wppa_create_session_entry( wppa-wpdb-insert.php) functions. * Plugin has disabled default wppa session id setting in function wppa_create_session_entry, so wppa_session_start function are unsuccessfully trying to get correct id for 10 times (each takes 1 sec because of sleep(1) function call). * Our developers temporarily commented sleep(1) call as mentioned below and said I should contact you. wp-content/plugins/wp-photo-album-plus/wppa-session.php line 48 * [https://wordpress.org/plugins/wp-photo-album-plus/](https://wordpress.org/plugins/wp-photo-album-plus/) Viewing 5 replies - 1 through 5 (of 5 total) * Plugin Author [Jacob N. Breetvelt](https://wordpress.org/support/users/opajaap/) * (@opajaap) * [11 years, 8 months ago](https://wordpress.org/support/topic/performance-issue-reported-by-our-devs/#post-5370190) * This was indeed a problem but it has been fixed in 5.4.12. Thanx for the report. * [mstancikova](https://wordpress.org/support/users/mstancikova/) * (@mstancikova) * [11 years, 4 months ago](https://wordpress.org/support/topic/performance-issue-reported-by-our-devs/#post-5370347) * Hello i updated wp photo album to version 5.5.0. and problem is still there with session this is the error from lo. file: * WordPress database error Duplicate entry ‘0’ for key ‘PRIMARY’ for query INSERT INTO `wp_wppa_session` ( `session`, `timestamp`, `user`, `ip`, `status`, `data`,` count` ) VALUES ( ‘26177898f3ce6e458f94155ec1900546’, ‘1423641948’, ‘admin’, ‘ 92.223.169.82’, ‘valid’, ”, ‘1’ ) made by require(‘wp-blog-header.php’), require_once(‘ wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wppa_session_start, wppa_create_session_entry * Plugin Author [Jacob N. Breetvelt](https://wordpress.org/support/users/opajaap/) * (@opajaap) * [11 years, 4 months ago](https://wordpress.org/support/topic/performance-issue-reported-by-our-devs/#post-5370348) * Manually inspect the db table wp_wppa_session and make sure the column ‘id’ has the attribute AUTO_INCREMENT * [Daphne C.](https://wordpress.org/support/users/dchristof/) * (@dchristof) * [10 years, 8 months ago](https://wordpress.org/support/topic/performance-issue-reported-by-our-devs/#post-5370362) * Jacob hi, I have version 6.3.6 installed and I still have the problem. I installed Query Monitor plugin and I can see that the query UPDATE `wp_wppa_session` is a slow query. I checked table wp_wppa_session in my database and the “id” column has the attribute AUTO INCREMENT. Any other ideas on how to fix this? * Plugin Author [Jacob N. Breetvelt](https://wordpress.org/support/users/opajaap/) * (@opajaap) * [10 years, 8 months ago](https://wordpress.org/support/topic/performance-issue-reported-by-our-devs/#post-5370363) * The session table is heavily updated. It contains records that stay one hour active for each user accessing the site, logged in or not. After 1 hour the record is removed. This may result in a scattered table after some time. You may truncate the table manually on the server sql admin ( TRUNCATE TABLE wp_wppa_session). This will only affect data like last selection and view count info for the users that currently access the site. No big deal, but it will clean up the table. * Try this, and if it works, i will add this action at plugin update and on the settings page in Table VIII-A1: Setup, so you can do it on a regular basis. * If the disorder of the table is the cause of the issue, you could alternatively install plugin wp-optimize and let it re-organize that plugin all the tables on a regular basis. Viewing 5 replies - 1 through 5 (of 5 total) The topic ‘Performance issue reported by our devs’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/wp-photo-album-plus.svg) * [WP Photo Album Plus](https://wordpress.org/plugins/wp-photo-album-plus/) * [Frequently Asked Questions](https://wordpress.org/plugins/wp-photo-album-plus/#faq) * [Support Threads](https://wordpress.org/support/plugin/wp-photo-album-plus/) * [Active Topics](https://wordpress.org/support/plugin/wp-photo-album-plus/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wp-photo-album-plus/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wp-photo-album-plus/reviews/) * 5 replies * 4 participants * Last reply from: [Jacob N. Breetvelt](https://wordpress.org/support/users/opajaap/) * Last activity: [10 years, 8 months ago](https://wordpress.org/support/topic/performance-issue-reported-by-our-devs/#post-5370363) * Status: resolved