ikran Posted July 30, 2021 Share Posted July 30, 2021 Hello, on my e-commerce site developed with prestashop I have a catalog consisting of about 300,000 items. Unfortunately when I go to do the frontend search for an article, the search begins and prestashop continues to search and always stays there looking ... Is there any solution to this to solve the problem? Link to comment Share on other sites More sharing options...
Danny Posted July 30, 2021 Share Posted July 30, 2021 4 minutes ago, ikran said: Hello, on my e-commerce site developed with prestashop I have a catalog consisting of about 300,000 items. Unfortunately when I go to do the frontend search for an article, the search begins and prestashop continues to search and always stays there looking ... Is there any solution to this to solve the problem? You can try to optimize mysql tables using phpmydmin, just the automatic procedure could help. Danny Link to comment Share on other sites More sharing options...
ikran Posted July 30, 2021 Author Share Posted July 30, 2021 Before doing the optimization I ask you if this is the correct procedure: I enter phpmyadmin I open the prestashop database In the Structure tab I select all the tables and then I choose Optimize table it's correct? Link to comment Share on other sites More sharing options...
Danny Posted July 30, 2021 Share Posted July 30, 2021 (edited) 41 minutes ago, ikran said: Before doing the optimization I ask you if this is the correct procedure: I enter phpmyadmin I open the prestashop database In the Structure tab I select all the tables and then I choose Optimize table it's correct? yes, you can start checking some of the tables in Overhead (last column), step by step. Check which are bigger tables and what they represent if you're unsure. Danny Edited July 30, 2021 by Danny (see edit history) Link to comment Share on other sites More sharing options...
ikran Posted July 30, 2021 Author Share Posted July 30, 2021 Good morning, I have optimized all the larger tables (greater than 1MB) but nothing has changed ... When I write something to look for, it starts looking and stays there looking for hours ... I am thinking of rebuilding the index from the prestashop backend in parameters-> search, you say it can be a solution or is it not worth it? Link to comment Share on other sites More sharing options...
Nickz Posted July 30, 2021 Share Posted July 30, 2021 Have you cleared your caches after optimization? A back up of the database should be done before optimization. 42 minutes ago, ikran said: I have optimized all the larger tables (greater than 1MB) but nothing has changed ... Link to comment Share on other sites More sharing options...
Danny Posted July 30, 2021 Share Posted July 30, 2021 41 minutes ago, ikran said: Good morning, I have optimized all the larger tables (greater than 1MB) but nothing has changed ... When I write something to look for, it starts looking and stays there looking for hours ... I am thinking of rebuilding the index from the prestashop backend in parameters-> search, you say it can be a solution or is it not worth it? Yes, it could help but it is not an error-free (often) procedure. Probably, with a large number of items, you need to increase some php.ini values first. Then you can try. Could you please share a link so I can check if what you say happens for everybody? Danny Link to comment Share on other sites More sharing options...
ikran Posted July 30, 2021 Author Share Posted July 30, 2021 I managed to get my provider to update the values in the php.ini file as written in the prestashop manual ... (unfortunately I don't have direct access to these settings) memory_limit = 512M max_execution_time = 300 max_input_time = 300 upload_max_filesize = 20M post_max_size = 22M max_input_vars = 20000 allow_url_fopen = on Now the search works! Thanks a lot to everyone! However, the site in question is www.si-parts.com 👍 1 Link to comment Share on other sites More sharing options...
Danny Posted July 30, 2021 Share Posted July 30, 2021 (edited) 29 minutes ago, ikran said: I managed to get my provider to update the values in the php.ini file as written in the prestashop manual ... (unfortunately I don't have direct access to these settings) memory_limit = 512M max_execution_time = 300 max_input_time = 300 upload_max_filesize = 20M post_max_size = 22M max_input_vars = 20000 allow_url_fopen = on Now the search works! Thanks a lot to everyone! However, the site in question is www.si-parts.com 👍 quindi è bastato alzare alcuni valori? Bene. Si funziona, non è un fulmine, ma hai anche tanti prodotti. 😉 So you just increased some php.ini values, db optimization and cleared cache? Good. Probably you can set up memory_limit = 1024M Danny Edited July 30, 2021 by Danny (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now