[Skip to main content](#vessel-content) # Dashboard Slow Loading ## - **[mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile")** - [![mojooutdoors-holden's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") Topic Author - [ Offline](/forum/user/12526-mojooutdoors-holden) Less More - Posts: 303 - Thank you received: 18 - - 8 years 6 months ago [\#291909](#291909) by [mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") *[Dashboard Slow Loading](/forum/36-reports-statistics/894564-dashboard-slow-loading#291909 "-- HikaShop version -- : 3.4.0 -- Joomla version -- : 3.8.6 For a while now, our dashboard takes an abnormal amount of time to load -- sometimes more than 20 seconds. Is there a particular database table that might be slowing it down? Large order or email log table? I've been trying to locate a fix but haven't had much luck. The dashboard is the only page to load slowly. The rest of the backend has minimal loading times.")* was created by *[mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile")* -- HikaShop version -- : 3.4.0 -- Joomla version -- : 3.8.6 For a while now, our dashboard takes an abnormal amount of time to load -- sometimes more than 20 seconds. Is there a particular database table that might be slowing it down? Large order or email log table? I've been trying to locate a fix but haven't had much luck. The dashboard is the only page to load slowly. The rest of the backend has minimal loading times. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTQ1NjQtZGFzaGJvYXJkLXNsb3ctbG9hZGluZz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 8 years 6 months ago [\#291917](#291917) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Dashboard Slow Loading](/forum/36-reports-statistics/894564-dashboard-slow-loading#291917 "-- HikaShop version -- : 3.4.0 -- Joomla version -- : 3.8.6 For a while now, our dashboard takes an abnormal amount of time to load -- sometimes more than 20 seconds. Is there a particular database table that might be slowing it down? Large order or email log table? I've been trying to locate a fix but haven't had much luck. The dashboard is the only page to load slowly. The rest of the backend has minimal loading times.")* Hi, Turn on the "debug mode" setting of the Joomla configuration and look at the bottom of the dashboard page. You'll get all the queries on the page with the timings for each one. That way, you can see which query is slow and then deduce from that which table is too big and / or which query could be optimized. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTQ1NjQtZGFzaGJvYXJkLXNsb3ctbG9hZGluZz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile")** - [![mojooutdoors-holden's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") Topic Author - [ Offline](/forum/user/12526-mojooutdoors-holden) Less More - Posts: 303 - Thank you received: 18 - - 8 years 6 months ago [\#291961](#291961) by [mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") Replied by *[mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile")* on topic *[Dashboard Slow Loading](/forum/36-reports-statistics/894564-dashboard-slow-loading#291961 "-- HikaShop version -- : 3.4.0 -- Joomla version -- : 3.8.6 For a while now, our dashboard takes an abnormal amount of time to load -- sometimes more than 20 seconds. Is there a particular database table that might be slowing it down? Large order or email log table? I've been trying to locate a fix but haven't had much luck. The dashboard is the only page to load slowly. The rest of the backend has minimal loading times.")* I turned on the debugging option and i see several duplicate entries and a few calls that are taking the majority of the load time. Here is an example: [ ![Screenshot231.png](/forum/attachment/43505) ](/forum/attachment/43505 "Screenshot231.png") However, i'm unsure how to resolve the errors. Seems to be related to the hikashop tables though. Not sure what the "NO INDEX KEY COULD BE USED" error is, but it seems that it forces the entire table to be indexed which takes a ton of time. Any ways to quickly resolve this? Surely it's a common problem? - [ ![Screenshot231.png](/forum/attachment/43505) ](/forum/attachment/43505 "Screenshot231.png") [ ](/forum/attachment/43505?download=1 "Screenshot231.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTQ1NjQtZGFzaGJvYXJkLXNsb3ctbG9hZGluZz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 8 years 6 months ago [\#292009](#292009) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Dashboard Slow Loading](/forum/36-reports-statistics/894564-dashboard-slow-loading#292009 "-- HikaShop version -- : 3.4.0 -- Joomla version -- : 3.8.6 For a while now, our dashboard takes an abnormal amount of time to load -- sometimes more than 20 seconds. Is there a particular database table that might be slowing it down? Large order or email log table? I've been trying to locate a fix but haven't had much luck. The dashboard is the only page to load slowly. The rest of the backend has minimal loading times.")* Hi, For some reasons it looks like it's not able to use the index available on the file_type column of the hikashop_file table. Can you check that you have that index ? [ superuser.com/questions/766451/view-exis...xes-using-phpmyadmin](https://superuser.com/questions/766451/view-existing-indexes-using-phpmyadmin) It's not a common problem. Database and mysql queries optimization is not a simple matter. It depends on how much data you have in each table of the Mysql query, how the query is constructed and how the tables are made to store the data. A query might be optimized for a specific case which might end up bein detrimental to another case. Can you check whether you have the "dashboard legacy" setting activated or not ? Changing that setting could well help circumvent the problem. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTQ1NjQtZGFzaGJvYXJkLXNsb3ctbG9hZGluZz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile")** - [![mojooutdoors-holden's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") Topic Author - [ Offline](/forum/user/12526-mojooutdoors-holden) Less More - Posts: 303 - Thank you received: 18 - - 8 years 6 months ago [\#292044](#292044) by [mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") Replied by *[mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile")* on topic *[Dashboard Slow Loading](/forum/36-reports-statistics/894564-dashboard-slow-loading#292044 "-- HikaShop version -- : 3.4.0 -- Joomla version -- : 3.8.6 For a while now, our dashboard takes an abnormal amount of time to load -- sometimes more than 20 seconds. Is there a particular database table that might be slowing it down? Large order or email log table? I've been trying to locate a fix but haven't had much luck. The dashboard is the only page to load slowly. The rest of the backend has minimal loading times.")* Here's the structure for that table: [ ![Screenshot232.png](/forum/attachment/43527) ](/forum/attachment/43527 "Screenshot232.png") Also, the legacy checkout option is turned off. However, it is also slow with it turned on as well. - [ ![Screenshot232.png](/forum/attachment/43527) ](/forum/attachment/43527 "Screenshot232.png") [ ](/forum/attachment/43527?download=1 "Screenshot232.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTQ1NjQtZGFzaGJvYXJkLXNsb3ctbG9hZGluZz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 8 years 6 months ago [\#292069](#292069) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Dashboard Slow Loading](/forum/36-reports-statistics/894564-dashboard-slow-loading#292069 "-- HikaShop version -- : 3.4.0 -- Joomla version -- : 3.8.6 For a while now, our dashboard takes an abnormal amount of time to load -- sometimes more than 20 seconds. Is there a particular database table that might be slowing it down? Large order or email log table? I've been trying to locate a fix but haven't had much luck. The dashboard is the only page to load slowly. The rest of the backend has minimal loading times.")* Hi, The legacy checkout option won't change anything regarding the dashboard. I was talking about the "dashboard legacy" setting. Please check the correct setting. Regarding the table structure, just below the area of your screenshot, you must have an "index" link you can click on and it will then expand to display the indexes on that table: [ monosnap.com/file/PVtqs7dhl3Yu0gqw5b4V54kEbu8VGc](https://monosnap.com/file/PVtqs7dhl3Yu0gqw5b4V54kEbu8VGc) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTQ1NjQtZGFzaGJvYXJkLXNsb3ctbG9hZGluZz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile")** - [![mojooutdoors-holden's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") Topic Author - [ Offline](/forum/user/12526-mojooutdoors-holden) Less More - Posts: 303 - Thank you received: 18 - - 8 years 6 months ago [\#292113](#292113) by [mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") Replied by *[mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile")* on topic *[Dashboard Slow Loading](/forum/36-reports-statistics/894564-dashboard-slow-loading#292113 "-- HikaShop version -- : 3.4.0 -- Joomla version -- : 3.8.6 For a while now, our dashboard takes an abnormal amount of time to load -- sometimes more than 20 seconds. Is there a particular database table that might be slowing it down? Large order or email log table? I've been trying to locate a fix but haven't had much luck. The dashboard is the only page to load slowly. The rest of the backend has minimal loading times.")* Woops. Meant same behavior whether dashboard legacy is turned on or off. As for the index, here's the expanded screenshot. [ ![Screenshot233.png](/forum/attachment/43545) ](/forum/attachment/43545 "Screenshot233.png") Seems that there is only one index. Your screenshot shows two. Is there any easy way to add this in to correct the issue? - [ ![Screenshot233.png](/forum/attachment/43545) ](/forum/attachment/43545 "Screenshot233.png") [ ](/forum/attachment/43545?download=1 "Screenshot233.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTQ1NjQtZGFzaGJvYXJkLXNsb3ctbG9hZGluZz90bXBsPW1hcmtkb3du) 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: 26400 - Thank you received: 4080 - - [](http://obsi.dev) - 8 years 6 months ago [\#292118](#292118) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Dashboard Slow Loading](/forum/36-reports-statistics/894564-dashboard-slow-loading#292118 "-- HikaShop version -- : 3.4.0 -- Joomla version -- : 3.8.6 For a while now, our dashboard takes an abnormal amount of time to load -- sometimes more than 20 seconds. Is there a particular database table that might be slowing it down? Large order or email log table? I've been trying to locate a fix but haven't had much luck. The dashboard is the only page to load slowly. The rest of the backend has minimal loading times.")* Hello, Regarding the query details, it looks like the "order product" table is right now the element to optimize. It might be interesting to add an index on the "product_id" to speed up some queries ; you have a very high number of entries in that table in your side. The "generic" query to add the index is : Code: ALTER TABLE `#__hikashop_order_product` ADD INDEX `product_id` (`product_id`); But you have to replace the "#_" by your database price ; which will be in your case Code: ALTER TABLE `jml_hikashop_order_product` ADD INDEX `product_id` (`product_id`); Please let us know if it improve the query and you can give us a new screenshot of the debug so we can compare values. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTQ1NjQtZGFzaGJvYXJkLXNsb3ctbG9hZGluZz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile")** - [![mojooutdoors-holden's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") Topic Author - [ Offline](/forum/user/12526-mojooutdoors-holden) Less More - Posts: 303 - Thank you received: 18 - - 8 years 6 months ago [\#292183](#292183) by [mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") Replied by *[mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile")* on topic *[Dashboard Slow Loading](/forum/36-reports-statistics/894564-dashboard-slow-loading#292183 "-- HikaShop version -- : 3.4.0 -- Joomla version -- : 3.8.6 For a while now, our dashboard takes an abnormal amount of time to load -- sometimes more than 20 seconds. Is there a particular database table that might be slowing it down? Large order or email log table? I've been trying to locate a fix but haven't had much luck. The dashboard is the only page to load slowly. The rest of the backend has minimal loading times.")* Maybe it helped a little. Hard to tell as the page still takes quite a while to load. [ ![Screenshot237.png](/forum/attachment/43555) ](/forum/attachment/43555 "Screenshot237.png") As far as the database results, the key was successfully added in the jml_hikashop_order_product table [ ![Screenshot238.png](/forum/attachment/43556) ](/forum/attachment/43556 "Screenshot238.png") Any other suggestions? I can give database access and super user access to the backend of the website if necessary. - [ ![Screenshot237.png](/forum/attachment/43555) ](/forum/attachment/43555 "Screenshot237.png") [ ](/forum/attachment/43555?download=1 "Screenshot237.png") - [ ![Screenshot238.png](/forum/attachment/43556) ](/forum/attachment/43556 "Screenshot238.png") [ ](/forum/attachment/43556?download=1 "Screenshot238.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTQ1NjQtZGFzaGJvYXJkLXNsb3ctbG9hZGluZz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile")** - [![mojooutdoors-holden's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") Topic Author - [ Offline](/forum/user/12526-mojooutdoors-holden) Less More - Posts: 303 - Thank you received: 18 - - 8 years 6 months ago [\#292184](#292184) by [mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") Replied by *[mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile")* on topic *[Dashboard Slow Loading](/forum/36-reports-statistics/894564-dashboard-slow-loading#292184 "-- HikaShop version -- : 3.4.0 -- Joomla version -- : 3.8.6 For a while now, our dashboard takes an abnormal amount of time to load -- sometimes more than 20 seconds. Is there a particular database table that might be slowing it down? Large order or email log table? I've been trying to locate a fix but haven't had much luck. The dashboard is the only page to load slowly. The rest of the backend has minimal loading times.")* Also, here is the database call that is taking the most time: [ ![Screenshot239.png](/forum/attachment/43557) ](/forum/attachment/43557 "Screenshot239.png") - [ ![Screenshot239.png](/forum/attachment/43557) ](/forum/attachment/43557 "Screenshot239.png") [ ](/forum/attachment/43557?download=1 "Screenshot239.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTQ1NjQtZGFzaGJvYXJkLXNsb3ctbG9hZGluZz90bXBsPW1hcmtkb3du) 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: 26400 - Thank you received: 4080 - - [](http://obsi.dev) - 8 years 6 months ago [\#292185](#292185) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Dashboard Slow Loading](/forum/36-reports-statistics/894564-dashboard-slow-loading#292185 "-- HikaShop version -- : 3.4.0 -- Joomla version -- : 3.8.6 For a while now, our dashboard takes an abnormal amount of time to load -- sometimes more than 20 seconds. Is there a particular database table that might be slowing it down? Large order or email log table? I've been trying to locate a fix but haven't had much luck. The dashboard is the only page to load slowly. The rest of the backend has minimal loading times.")* Hello, I don't remember in which version exactly but we added an index in the hikashop_file table ; but just in the database definition and not via the update system. So, it could explain why you do not have the index for that. The "generic" query to add the index is : Code: ALTER TABLE `#__hikashop_file` ADD INDEX `file_type` (`file_type`); Afterwards, the index could be more optimized by using a combination of file_type + file_ref_id. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTQ1NjQtZGFzaGJvYXJkLXNsb3ctbG9hZGluZz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile")** - [![mojooutdoors-holden's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") Topic Author - [ Offline](/forum/user/12526-mojooutdoors-holden) Less More - Posts: 303 - Thank you received: 18 - - 8 years 6 months ago [\#292202](#292202) by [mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") Replied by *[mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile")* on topic *[Dashboard Slow Loading](/forum/36-reports-statistics/894564-dashboard-slow-loading#292202 "-- HikaShop version -- : 3.4.0 -- Joomla version -- : 3.8.6 For a while now, our dashboard takes an abnormal amount of time to load -- sometimes more than 20 seconds. Is there a particular database table that might be slowing it down? Large order or email log table? I've been trying to locate a fix but haven't had much luck. The dashboard is the only page to load slowly. The rest of the backend has minimal loading times.")* Much better! However, I'm not well versed in the database management. By using a combination of file_type + file_ref_id, do you mean to generate another index called file_type with: Code: ALTER TABLE `#__hikashop_file` ADD INDEX `file_ref_id` (`file_ref_id`); Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTQ1NjQtZGFzaGJvYXJkLXNsb3ctbG9hZGluZz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 8 years 6 months ago [\#292214](#292214) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Dashboard Slow Loading](/forum/36-reports-statistics/894564-dashboard-slow-loading#292214 "-- HikaShop version -- : 3.4.0 -- Joomla version -- : 3.8.6 For a while now, our dashboard takes an abnormal amount of time to load -- sometimes more than 20 seconds. Is there a particular database table that might be slowing it down? Large order or email log table? I've been trying to locate a fix but haven't had much luck. The dashboard is the only page to load slowly. The rest of the backend has minimal loading times.")* Hi, Jerome meant using such query: Code: ALTER TABLE `#__hikashop_file` ADD INDEX `file_ref_id` (`file_ref_id`, `file_type`); The following user(s) said Thank You: [mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTQ1NjQtZGFzaGJvYXJkLXNsb3ctbG9hZGluZz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile")** - [![mojooutdoors-holden's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") Topic Author - [ Offline](/forum/user/12526-mojooutdoors-holden) Less More - Posts: 303 - Thank you received: 18 - - 8 years 6 months ago [\#292260](#292260) by [mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") Replied by *[mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile")* on topic *[Dashboard Slow Loading](/forum/36-reports-statistics/894564-dashboard-slow-loading#292260 "-- HikaShop version -- : 3.4.0 -- Joomla version -- : 3.8.6 For a while now, our dashboard takes an abnormal amount of time to load -- sometimes more than 20 seconds. Is there a particular database table that might be slowing it down? Large order or email log table? I've been trying to locate a fix but haven't had much luck. The dashboard is the only page to load slowly. The rest of the backend has minimal loading times.")* Will there by any issue if I already added what jerome sent? Code: ALTER TABLE `#__hikashop_file` ADD INDEX `file_type` (`file_type`); Meaning if I add the query you sent Nicolas, will it mess anything up? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTQ1NjQtZGFzaGJvYXJkLXNsb3ctbG9hZGluZz90bXBsPW1hcmtkb3du) 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: 26400 - Thank you received: 4080 - - [](http://obsi.dev) - 8 years 6 months ago [\#292269](#292269) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Dashboard Slow Loading](/forum/36-reports-statistics/894564-dashboard-slow-loading#292269 "-- HikaShop version -- : 3.4.0 -- Joomla version -- : 3.8.6 For a while now, our dashboard takes an abnormal amount of time to load -- sometimes more than 20 seconds. Is there a particular database table that might be slowing it down? Large order or email log table? I've been trying to locate a fix but haven't had much luck. The dashboard is the only page to load slowly. The rest of the backend has minimal loading times.")* Hello, You can have multiple index in your tables (as long as the index name is unique). But it is possible to add several time an index on the same columns, it won't bother mysql (but it will tell you that it's useless). Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. The following user(s) said Thank You: [mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTQ1NjQtZGFzaGJvYXJkLXNsb3ctbG9hZGluZz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile")** - [![mojooutdoors-holden's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") Topic Author - [ Offline](/forum/user/12526-mojooutdoors-holden) Less More - Posts: 303 - Thank you received: 18 - - 8 years 6 months ago [\#292438](#292438) by [mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") Replied by *[mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile")* on topic *[Dashboard Slow Loading](/forum/36-reports-statistics/894564-dashboard-slow-loading#292438 "-- HikaShop version -- : 3.4.0 -- Joomla version -- : 3.8.6 For a while now, our dashboard takes an abnormal amount of time to load -- sometimes more than 20 seconds. Is there a particular database table that might be slowing it down? Large order or email log table? I've been trying to locate a fix but haven't had much luck. The dashboard is the only page to load slowly. The rest of the backend has minimal loading times.")* Thanks guys. Sorry for the lack of knowledge of SQL tables. Pretty much my first experience with them. Dashboard loading time went from +10 seconds down to just 2-3 seconds. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTQ1NjQtZGFzaGJvYXJkLXNsb3ctbG9hZGluZz90bXBsPW1hcmtkb3du) 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.118 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)