Jump to content

Search the Community

Showing results for tags 'sqli'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • News and Announcements
    • News and Announcements
  • osCommerce Online Merchant v2.x
    • General Support
    • osCommerce Online Merchant Community Bootstrap Edition
    • Add-Ons
  • Development
  • General
    • General Discussions
    • Live Shop Reviews
    • Security
    • Developer Feedback
  • PayPal's Announcements
  • Sage Pay's Announcements
  • Solomono - new level osCommerce templates's Announcements
  • German Community's OSCOM v2.x
  • German Community's Allgemein

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start



Real Name




Found 1 result

  1. 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