Search the Community
Showing results for tags 'sql'.
Found 4 results
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
Hi Everyone, Hope everyone is keeping safe and well in these scary times. Im looking to run an sql to increase the shipping weight of products if under 1kg to 1.1kg leaving all other weights unchanged. Could do with some help as I dont want to destroy my database Many Thanks
MySQLi Prepared Statement Automator This Add-On comes with the only guarantee of possibly causing you a lot of headaches. It looks like it's working quite well, but further testing is required ... - Support Thread - http://addons.oscommerce.com/info/9076
Hi, As part of the installation of a contribution I have to run the following SQL database query: DROP TABLE IF EXISTS `products_cross_sell`; CREATE TABLE IF NOT EXISTS `products_cross_sell` ( `products_cross_sell_id` int(10) NOT NULL auto_increment, `products_id` int(10) unsigned NOT NULL default '1', `cross_sell_id` int(10) unsigned NOT NULL default '1', `cross_sell_sort_order` int(10) unsigned NOT NULL default '1', PRIMARY KEY (`products_cross_sell_id`) ) TYPE=MyISAM; When I do this I get the following error message: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 7 Is there an obvious error does anyone know? Thanks David