[Skip to main content](#vessel-content) # Database processes slowing server down ## - **[Bower](/forum/user/31321-bower "View Bower's Profile")** - [![Bower's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31321-bower "View Bower's Profile") Topic Author - [ Offline](/forum/user/31321-bower) Less More - Posts: 51 - Thank you received: 0 - - 11 years 10 months ago [\#183707](#183707) by [Bower](/forum/user/31321-bower "View Bower's Profile") *[Database processes slowing server down](/forum/2-general-talk-about-hikashop/873726-database-processes-slowing-server-down#183707 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.2.4 -- PHP version -- : 5.3.3 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : 504 Gateway Time-out nginx Hi I keep getting 504 Gateway Time out errors while working on the site and this was the response I got from my Hosting Service Provider There is currently a large amount of disk usage on the server being consumed by the MySQL service. There are currently some huge processes trying to go through; The process I was trying to acheive was to move a product into a different category and add it to a couple more. Not something I thought was out of the ordinary or used a vast amount of resources to process. Are the time out errors being generated by hikashop or could there be another reason?")* was created by *[Bower](/forum/user/31321-bower "View Bower's Profile")* -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.2.4 -- PHP version -- : 5.3.3 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : 504 Gateway Time-out nginx Hi I keep getting 504 Gateway Time out errors while working on the site and this was the response I got from my Hosting Service Provider There is currently a large amount of disk usage on the server being consumed by the MySQL service. There are currently some huge processes trying to go through; > \| 4238614 \| xi\_user \| localhost \| xi\_db \| Query \| 686 \| Sending data \| INSERT IGNORE INTO xi\_hikashop\_product > (product\_code, product\_parent\_id, product\_created, product\_modified, product\_hit, product\_last\_seen\_date, product\_name, > product\_description, product\_quantity, product\_published, product\_sale\_start, product\_sale\_end, product\_delay\_id, > product\_tax\_id, product\_type, product\_vendor\_id, product\_manufacturer\_id, product\_url, product\_weight, product\_keywords, > product\_weight\_unit, product\_meta\_description, product\_dimension\_unit, product\_width, product\_length, product\_height, > product\_max\_per\_order, product\_access, product\_group\_after\_purchase, product\_min\_per\_order, product\_contact, > product\_sales, product\_waitlist, product\_layout, product\_average\_score, product\_total\_vote, product\_page\_title, > product\_alias, product\_price\_percentage, product\_canonical, product\_msrp, product\_display\_quantity\_field, > product\_warehouse\_id, product\_quantity\_layout, occupation) SELECT CONCAT(p.product\_code, '\_', c0.characteristic\_id) AS > c\_product\_code, p.product\_id, 1418829594, 1418829594, 0, 0, product\_name, product\_description, product\_quantity, > product\_published, product\_sale\_start, product\_sale\_end, product\_delay\_id, product\_tax\_id, product\_type, > product\_vendor\_id, product\_manufacturer\_id, product\_url, product\_weight, product\_keywords, product\_weight\_unit, > product\_meta\_description, product\_dimension\_unit, product\_width, product\_length, product\_height, product\_max\_per\_order, > product\_access, product\_group\_after\_purchase, product\_min\_per\_order, product\_contact, product\_sales, product\_waitlist, > product\_layout, product\_average\_score, product\_total\_vote, product\_page\_title, product\_alias, product\_price\_percentage, > product\_canonical, product\_msrp, product\_display\_quantity\_field, product\_warehouse\_id, product\_quantity\_layout, > occupation FROM xi\_hikashop\_product AS p, xi\_hikashop\_characteristic AS c0 WHERE p.product\_id IN > (928,927,926,10769,10770,10771,10772,10773,10774,10775,10776,10777,10778,10779,10780,10781,10782,10783,10784 > > I have cut this process short, as it is quite lengthy, but I hope this gives you some idea. As the VM you have only has > 2G of ram, it will struggle to perform these tasks and will slow down and cause scripts to take longer to complete, ie > the exceeding of 90 seconds and causing the server to error. > > I would advise to take a look at these processes and see if they can be optimised. The process I was trying to acheive was to move a product into a different category and add it to a couple more. Not something I thought was out of the ordinary or used a vast amount of resources to process. Are the time out errors being generated by hikashop or could there be another reason? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg3MzcyNi1kYXRhYmFzZS1wcm9jZXNzZXMtc2xvd2luZy1zZXJ2ZXItZG93bj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 10 months ago [\#183714](#183714) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Database processes slowing server down](/forum/2-general-talk-about-hikashop/873726-database-processes-slowing-server-down#183714 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.2.4 -- PHP version -- : 5.3.3 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : 504 Gateway Time-out nginx Hi I keep getting 504 Gateway Time out errors while working on the site and this was the response I got from my Hosting Service Provider There is currently a large amount of disk usage on the server being consumed by the MySQL service. There are currently some huge processes trying to go through; The process I was trying to acheive was to move a product into a different category and add it to a couple more. Not something I thought was out of the ordinary or used a vast amount of resources to process. Are the time out errors being generated by hikashop or could there be another reason?")* Hi, The SQL you posted is the variant creation query. It means that you're using the "variant auto fill" option. Would it be possible to have more details about the products listed in the query ? What is the type of the product with id "928" ? The function "updateCharacteristics" when the option "variant auto fill" is activated will dynamically generate/duplicate the variants when a characteristic is added or when a characteristic value is added. Regarding the list of product_id in the query, I think that you're editing a product with a large amount of variants and it could be very very resource consuming. I rewrite the all function in order to optimize it ; but the all system is not made to handle products with hundred or thousand of variants on small servers ; managing such big number of products in the same time require a lot of resources (RAM and CPU) ; that's why we do not recommend to use too much characteristics on products or to deactivate the "variant auto fill" setting to manage yourself the variants you want. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg3MzcyNi1kYXRhYmFzZS1wcm9jZXNzZXMtc2xvd2luZy1zZXJ2ZXItZG93bj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Bower](/forum/user/31321-bower "View Bower's Profile")** - [![Bower's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31321-bower "View Bower's Profile") Topic Author - [ Offline](/forum/user/31321-bower) Less More - Posts: 51 - Thank you received: 0 - - 11 years 10 months ago [\#183795](#183795) by [Bower](/forum/user/31321-bower "View Bower's Profile") Replied by *[Bower](/forum/user/31321-bower "View Bower's Profile")* on topic *[Database processes slowing server down](/forum/2-general-talk-about-hikashop/873726-database-processes-slowing-server-down#183795 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.2.4 -- PHP version -- : 5.3.3 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : 504 Gateway Time-out nginx Hi I keep getting 504 Gateway Time out errors while working on the site and this was the response I got from my Hosting Service Provider There is currently a large amount of disk usage on the server being consumed by the MySQL service. There are currently some huge processes trying to go through; The process I was trying to acheive was to move a product into a different category and add it to a couple more. Not something I thought was out of the ordinary or used a vast amount of resources to process. Are the time out errors being generated by hikashop or could there be another reason?")* Thanks Jerome I cannot find the product with id "928" in the backend - the nearest product id to it (923) had a charactersitic with "no values found" (see attachment). Am just wondering as the site has been updated from Joomla 2.5 to Joomla 3 and the Hikashop has also been updated whether the database has not been populated correctly with the characteristics. It has got to the point where the site is becoming unusable whenever I navigate to Hikashop in the backend. - [ ![Screen_Shot_2014-12-18_at_09_40_15.png](/forum/attachment/21289) ](/forum/attachment/21289 "...t_09_40_15.png") [ ](/forum/attachment/21289?download=1 "...t_09_40_15.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg3MzcyNi1kYXRhYmFzZS1wcm9jZXNzZXMtc2xvd2luZy1zZXJ2ZXItZG93bj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Bower](/forum/user/31321-bower "View Bower's Profile")** - [![Bower's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31321-bower "View Bower's Profile") Topic Author - [ Offline](/forum/user/31321-bower) Less More - Posts: 51 - Thank you received: 0 - - 11 years 10 months ago [\#183797](#183797) by [Bower](/forum/user/31321-bower "View Bower's Profile") Replied by *[Bower](/forum/user/31321-bower "View Bower's Profile")* on topic *[Database processes slowing server down](/forum/2-general-talk-about-hikashop/873726-database-processes-slowing-server-down#183797 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.2.4 -- PHP version -- : 5.3.3 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : 504 Gateway Time-out nginx Hi I keep getting 504 Gateway Time out errors while working on the site and this was the response I got from my Hosting Service Provider There is currently a large amount of disk usage on the server being consumed by the MySQL service. There are currently some huge processes trying to go through; The process I was trying to acheive was to move a product into a different category and add it to a couple more. Not something I thought was out of the ordinary or used a vast amount of resources to process. Are the time out errors being generated by hikashop or could there be another reason?")* Hi Jerome I have looked in the database and there are 183,145 rows in the variant table. I'm presuming that this is the problem and why the server is timing out. There are also 339 characteristics which the client has created so maybe I will need to educate him on how to do it properly! Thanks for your help with this and for helping pinpoint the problem! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg3MzcyNi1kYXRhYmFzZS1wcm9jZXNzZXMtc2xvd2luZy1zZXJ2ZXItZG93bj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 10 months ago [\#183807](#183807) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Database processes slowing server down](/forum/2-general-talk-about-hikashop/873726-database-processes-slowing-server-down#183807 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.2.4 -- PHP version -- : 5.3.3 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : 504 Gateway Time-out nginx Hi I keep getting 504 Gateway Time out errors while working on the site and this was the response I got from my Hosting Service Provider There is currently a large amount of disk usage on the server being consumed by the MySQL service. There are currently some huge processes trying to go through; The process I was trying to acheive was to move a product into a different category and add it to a couple more. Not something I thought was out of the ordinary or used a vast amount of resources to process. Are the time out errors being generated by hikashop or could there be another reason?")* Hi, You're welcome ! I'm glad that you found the source of the issue. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg3MzcyNi1kYXRhYmFzZS1wcm9jZXNzZXMtc2xvd2luZy1zZXJ2ZXItZG93bj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Bower](/forum/user/31321-bower "View Bower's Profile")** - [![Bower's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31321-bower "View Bower's Profile") Topic Author - [ Offline](/forum/user/31321-bower) Less More - Posts: 51 - Thank you received: 0 - - 11 years 9 months ago [\#185561](#185561) by [Bower](/forum/user/31321-bower "View Bower's Profile") Replied by *[Bower](/forum/user/31321-bower "View Bower's Profile")* on topic *[Database processes slowing server down](/forum/2-general-talk-about-hikashop/873726-database-processes-slowing-server-down#185561 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.2.4 -- PHP version -- : 5.3.3 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : 504 Gateway Time-out nginx Hi I keep getting 504 Gateway Time out errors while working on the site and this was the response I got from my Hosting Service Provider There is currently a large amount of disk usage on the server being consumed by the MySQL service. There are currently some huge processes trying to go through; The process I was trying to acheive was to move a product into a different category and add it to a couple more. Not something I thought was out of the ordinary or used a vast amount of resources to process. Are the time out errors being generated by hikashop or could there be another reason?")* Hi Jerome Just another problem related to the above. The variants are not being generated automatically now so the site is operational however due to the fact that they were being generated automatically the size of the database has grown substantially (it is now 400MB with 2million plus products!!!!) Was just wondering if there was an easy way to filter out the variants from the database and leave the master products and characteristics intact?? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg3MzcyNi1kYXRhYmFzZS1wcm9jZXNzZXMtc2xvd2luZy1zZXJ2ZXItZG93bj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 9 months ago [\#185563](#185563) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Database processes slowing server down](/forum/2-general-talk-about-hikashop/873726-database-processes-slowing-server-down#185563 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.2.4 -- PHP version -- : 5.3.3 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : 504 Gateway Time-out nginx Hi I keep getting 504 Gateway Time out errors while working on the site and this was the response I got from my Hosting Service Provider There is currently a large amount of disk usage on the server being consumed by the MySQL service. There are currently some huge processes trying to go through; The process I was trying to acheive was to move a product into a different category and add it to a couple more. Not something I thought was out of the ordinary or used a vast amount of resources to process. Are the time out errors being generated by hikashop or could there be another reason?")* Hi, In the database, there is a column "product_type" and a column "product_parent_id". The "product_type" is set to "variant" if the product is a variant ; the column "product_parent_id" will also have the value of the main product (and will be set to "0" otherwise). Thanks to that, you can delete all variants in your database or you can delete all variants for one single product. Because a variant will also have some references in the table "#__hikashop_variant" and could have some data in the tables "product", "price", "related", etc.. It could be easier to use a "mass action" in order to delete these unwanted variants and not work directly in the database. In all cases, making a backup of the database before touching anything is primordial. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg3MzcyNi1kYXRhYmFzZS1wcm9jZXNzZXMtc2xvd2luZy1zZXJ2ZXItZG93bj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[cgonline](/forum/user/34948-cgonline "View cgonline's Profile")** - [![cgonline's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34948-cgonline "View cgonline's Profile") - [ Offline](/forum/user/34948-cgonline) Less More - Posts: 12 - Thank you received: 0 - - 11 years 9 months ago - 11 years 9 months ago [\#186435](#186435) by [cgonline](/forum/user/34948-cgonline "View cgonline's Profile") Replied by *[cgonline](/forum/user/34948-cgonline "View cgonline's Profile")* on topic *[Database processes slowing server down](/forum/2-general-talk-about-hikashop/873726-database-processes-slowing-server-down#186435 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.2.4 -- PHP version -- : 5.3.3 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : 504 Gateway Time-out nginx Hi I keep getting 504 Gateway Time out errors while working on the site and this was the response I got from my Hosting Service Provider There is currently a large amount of disk usage on the server being consumed by the MySQL service. There are currently some huge processes trying to go through; The process I was trying to acheive was to move a product into a different category and add it to a couple more. Not something I thought was out of the ordinary or used a vast amount of resources to process. Are the time out errors being generated by hikashop or could there be another reason?")* Hi I am experiencing the exact same thing for a friend He has 4 products and 2 characteristics (with 4 & 11 options). Only one characteristic is used pr product. That gives him 147.000 rows in #__hikashop_variant and 414.000 rows in #__hikashop_products. His shop is not live yet and he is experimenting with the characteristics, but this is with default settings. As far as I can see, HS doesn't delete old variants when deleting them? I'd call that a bug. ![:)](/media/kunena/emoticons/8.png ":)") HS needs some way to deal or enlighten us. Maybe the "check db function" can clean up/verify the integrity of the tables (or at least those tables)? Edit: Forgot to say this is with HS Business version 2.3.5 Last edit: 11 years 9 months ago by [cgonline](/forum/user/34948-cgonline "View cgonline's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg3MzcyNi1kYXRhYmFzZS1wcm9jZXNzZXMtc2xvd2luZy1zZXJ2ZXItZG93bj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 9 months ago [\#186445](#186445) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Database processes slowing server down](/forum/2-general-talk-about-hikashop/873726-database-processes-slowing-server-down#186445 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.2.4 -- PHP version -- : 5.3.3 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : 504 Gateway Time-out nginx Hi I keep getting 504 Gateway Time out errors while working on the site and this was the response I got from my Hosting Service Provider There is currently a large amount of disk usage on the server being consumed by the MySQL service. There are currently some huge processes trying to go through; The process I was trying to acheive was to move a product into a different category and add it to a couple more. Not something I thought was out of the ordinary or used a vast amount of resources to process. Are the time out errors being generated by hikashop or could there be another reason?")* Hi, > As far as I can see, HS doesn't delete old variants when deleting them? When deleting what ? Please provide more details ; their is maybe a bug but I need to understand it if you want me to fix it ![:)](/media/kunena/emoticons/8.png ":)") Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg3MzcyNi1kYXRhYmFzZS1wcm9jZXNzZXMtc2xvd2luZy1zZXJ2ZXItZG93bj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[cgonline](/forum/user/34948-cgonline "View cgonline's Profile")** - [![cgonline's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34948-cgonline "View cgonline's Profile") - [ Offline](/forum/user/34948-cgonline) Less More - Posts: 12 - Thank you received: 0 - - 11 years 9 months ago [\#186542](#186542) by [cgonline](/forum/user/34948-cgonline "View cgonline's Profile") Replied by *[cgonline](/forum/user/34948-cgonline "View cgonline's Profile")* on topic *[Database processes slowing server down](/forum/2-general-talk-about-hikashop/873726-database-processes-slowing-server-down#186542 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.2.4 -- PHP version -- : 5.3.3 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : 504 Gateway Time-out nginx Hi I keep getting 504 Gateway Time out errors while working on the site and this was the response I got from my Hosting Service Provider There is currently a large amount of disk usage on the server being consumed by the MySQL service. There are currently some huge processes trying to go through; The process I was trying to acheive was to move a product into a different category and add it to a couple more. Not something I thought was out of the ordinary or used a vast amount of resources to process. Are the time out errors being generated by hikashop or could there be another reason?")* Hi again Sorry for being unclear. This should replicate it: 1. Create a set of characteristics. 2. Then attach it to a product from within the edit product page -> save 3. Change some characteristics from within the edit product page -> save 4. Go in to edit product page and delete the set -> save Keep an eye on the db - The entries are still in #__hs_products as variants and still got the mapping... We did quite some testing with that feature, but it blows my mind that it could generate THAT many entries that it did. (simple math says it should've been attached 39.000 times so I guess it's twofold; A bug in the generation of variants somewhere AND variants not being deleted). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg3MzcyNi1kYXRhYmFzZS1wcm9jZXNzZXMtc2xvd2luZy1zZXJ2ZXItZG93bj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 9 months ago [\#186556](#186556) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Database processes slowing server down](/forum/2-general-talk-about-hikashop/873726-database-processes-slowing-server-down#186556 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.2.4 -- PHP version -- : 5.3.3 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : 504 Gateway Time-out nginx Hi I keep getting 504 Gateway Time out errors while working on the site and this was the response I got from my Hosting Service Provider There is currently a large amount of disk usage on the server being consumed by the MySQL service. There are currently some huge processes trying to go through; The process I was trying to acheive was to move a product into a different category and add it to a couple more. Not something I thought was out of the ordinary or used a vast amount of resources to process. Are the time out errors being generated by hikashop or could there be another reason?")* Hi, I am sorry but I can't reproduce your issue using HikaShop 2.3.5 with the option "Generate variants automatically" configure to "yes" (Main > Advanced settings). Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg3MzcyNi1kYXRhYmFzZS1wcm9jZXNzZXMtc2xvd2luZy1zZXJ2ZXItZG93bj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.275 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)