Search quickly, articles slowly

Submitted by MarcoCH on Fri, 2020-05-29 07:38 in Installation and Setup

hello David

Can you help me with that. The search function on my new page with 700,000 articles is very fast, results are displayed quickly.

But when I click on the article it takes about 12 or more seconds until it is loaded.

How does the whole database query go very quickly but the article itself loads very slowly?

Is there an explanation?

Best regards
Marco

Submitted by support on Fri, 2020-05-29 10:39

Hello Marco,

Could you check whether it is the Related Products query that is causing this - if you temporarily disable in config.php at line 10:

$config_useRelated = FALSE;

Thanks,
David.
--
PriceTapestry.com

Submitted by MarcoCH on Fri, 2020-05-29 11:23

hello David

No, I switched it off, it doesn't change anything.
Search remains fast, article loading takes 20 seconds.

Would you like to see for yourself?
{link saved}

regards
Marco

Submitted by support on Fri, 2020-05-29 12:04

Hi Marco,

That's strange - please could you email me from this installation;

products.php
includes/database.php

If nothing obvious I'll add profiling code to the database library to check all queries being run by the page...

Cheers,
David.
--
PriceTapestry.com