Hikashop is very slow

  • Posts: 30
  • Thank you received: 0
7 years 10 months ago #260612

-- url of the page with the problem -- : www.bandenservice-lelystad.nl/banden
-- HikaShop version -- : JCacheStorageFile::_deleteFolder
-- Joomla version -- : 3.6.5
-- Browser(s) name and version -- : chrome

Hello,

I have a problem with the speed of my hikashop, the loading of the product listing pages and especially the cart ( which sometimes gives a 500 error - internal server error. ). i am loading 10 products on the page itself. that couldnt be it ?
The cart is the biggest problem..

Hope you can help me with this,

Kevin

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
7 years 9 months ago #260614

Hi,

Could you turn on the "debug mode" of the Joomla configuration so that we could look at the debug data of the page ?
That would allow us to understand what is slowing down the display of the page.
Because with a listing of 10 products like you have, it should display super fast. There must be something else to it.

Please Log in or Create an account to join the conversation.

  • Posts: 30
  • Thank you received: 0
7 years 9 months ago #260649

Hi,

Oke what i have seen i have added in a pdf document as attachment.
Hope you can make any sense of it, some words are in dutch. but i have translated most of them

Kevin

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
7 years 9 months ago #260669

Hi,

From what I can see in your PDF, there is a problem with the hikashop_file table in your database.
The MySQL queries on that table take 1 to 6 seconds each even though the queries are fairly normal and should only take a few milliseconds.
So either you have hundred of thousands (or millions) of entries in there, or there is a problem with the structure of that table.
Could you open it with your PHPMyAdmin and provide a screenshot of its structure and tell us how many entries you have in it ?

Please Log in or Create an account to join the conversation.

  • Posts: 30
  • Thank you received: 0
7 years 9 months ago #260781

i dont know how but there are more then 3 million entries in the database table.
i have noticed that with each time the cron job does his work, the table gets filled with fields.
for example : It says 1700 entries, with just 400 products in hikashop after i deleted everything.

The CSV with 7000+ fields should insert the products and if the product exists he should update the products.
What i should mention is that i inserted the 7000 fields manually first, then activated the cron.
This is because the images are downloaded from the csv file and the system cant handle 7000 images to download at once. ( another collegue of yours told me that )

So i have set up the cron plugin with correction of the fields and activated the cron job.
i have added the line that i use for connecting the fields in the csv to the right table fields.

How do i stop the cron job filling the hikashop file table ?

hope you can help me with this.

Kevin

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
7 years 9 months ago #260783

Hi,

So if I understand correctly, you're using the HikaShop Product Cron Update plugin in order to import your CSV, is that right ?

The best would be to understand why this happens since it doesn't on our end.
Could you look at the data in that hikashop_file table ?
What is wrong with the entries there ?
Do you have a lot of entries for each product ? Or maybe most of the entries are for product_ids that don't exist (in the column file_ref_id) ? Maybe something else ?

As a quick fix, I suppose you could just empty the whole table in PHPMyAdmin before running the import of your CSV once. That should fix the problem temporarily, until the images entries gets added back in the table little by little.

Please Log in or Create an account to join the conversation.

  • Posts: 30
  • Thank you received: 0
7 years 9 months ago #260810

Yes that is right!

If i look at the table there are alot of the same products.
I have cleared the whole table, and indeed the shop is amazingly faster.

Please Log in or Create an account to join the conversation.

  • Posts: 30
  • Thank you received: 0
7 years 9 months ago #260846

but what i dont understand is why my cron job with csv file is entering entries in the file table even if the file already exists.

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
7 years 9 months ago #260847

Hi,

Great !
The thing is that on each import, the system first delete all the image entries in the hikashop_file table for the products that are being imported, and then insert the entries for the files in the CSV.
So what you have shouldn't happen.
You say you have several entries for each product. Is that still the case after clearing the data of the table after a few imports ? Could you provide an example with one product ? A screenshot of the hikashop_files entries listing filtered for when file_ref_id = the id of the product and the CSV with only the line(s) for that product and the top line ?
That would help in trying to understand what's going on.

Please Log in or Create an account to join the conversation.

  • Posts: 30
  • Thank you received: 0
7 years 9 months ago #260881

Oke i have made some printscreens from the file table, which now looks normal. No double items ( if i sort and check the file_id field )
Even if i load a test csv file manually to hikashop it works fine as well..
I also have the same test file added as cron job to check it.
It was succesfull but no extra entry was added, so that is good.

The cron job says something like : exchance course updated. ?? here is the example in dutch :

HikaShop Uitgevoerd op 2017-01-30 22:44 ( hikashop triggered at 2017 ... )
Wisselkoersen succesvol bijgewerkt (exchance course succesfull updated. )

I have added alot of usefull printscreens.

Kevin

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
7 years 9 months ago #260910

Hi,

Then maybe the data in there was some old data and it wasn't caused by the import but something else. Otherwise, the problem would have continued after clearing the table and increase the amount of entries by 7K on each CSV import.
Thus, it means that it fixed for good on your website.

Please Log in or Create an account to join the conversation.

  • Posts: 30
  • Thank you received: 0
7 years 9 months ago #261461

Hello,

The file table keeps increasing, the total amount of fields are 187 thousand, instead of the 7000+ products i have..
every 15 minutes the cron is triggered, and add fields..
How is this possible ?
I quickly need to adress it, it is a live site.

Kevin

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
7 years 9 months ago #261508

Hi,

Can you provide a full copy of the CSV file and the full text you have in the "column name" setting of the plugin ?
You can send these to contact AT hikashop DOT com so that we can look at it.

Please Log in or Create an account to join the conversation.

  • Posts: 30
  • Thank you received: 0
7 years 9 months ago #261524

Hello,

I have send the mail to contact AT hikashop dot com.

Kevin

Please Log in or Create an account to join the conversation.

Time to create page: 0.069 seconds
Powered by Kunena Forum