Search the Community
Showing results for tags 'sqli'.
Found 1 result
Hello, I have a store installation (CE FROZEN, PHP 7.2) with very slow loading admin/categories.php, maybe 20-30 sec. Characteristics for products/chategories: products aprox. 1800 products_to categories aprox. 20000 (products are linked to several categories) categories aprox. 6000 The big number of categories and product links may explain the slow loading. Database tables have been analysed and optimized, they are all using MyISAM and the index settings in the tables are all correct (core). But I observe the following difference between server and local develop installation under XAMPP: Server: always the same loading time XAMPP: slow loading on first time page load rel. fast loading on second and following page loads (2-3 sec.) So my conclusion is that it should be related to a database cache setting. I checked the sqli settings in php.ini of the XAMPP installation and tried to lower mysqli.cache_size=2000 to a very low setting (10) in order to simulate the server problem but no difference. Questions: With the amount of products/categories/links does it sound reasonable this slow loading? Which setting on the server/database can produce this different behaviour Thank you in advance Rainer