Hard SQL request

Phoca Cart - complex e-commerce extension
NeuroZ
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 11 Dec 2017, 21:25

Hard SQL request

Post by NeuroZ » 29 Dec 2017, 10:56

Hi!
I was parsing VM products to Phoca Cart. And I have some issue in admin panel - products list.
When I upload 12k products - system has work success. But when I added 20k products - page products list is very long opened.
So I look explain DB queries and finded very strange query (look screenshot: https://yadi.sk/i/1x-GVLIu3R5dLL).

I can send login and pass to admin panel (if needed).

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 43634
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Hard SQL request

Post by Jan » 01 Jan 2018, 18:12

Hi, I don't see anything strange on that screenshot, I see there one error when the database was not selected. :idea: What you exactly mean with the strange query?

Jan
If you find Phoca extensions useful, please support the project

NeuroZ
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 11 Dec 2017, 21:25

Re: Hard SQL request

Post by NeuroZ » 05 Jan 2018, 11:41

1. Time to load page list products
2. Many GROUP BY (I think - this is strange)
+ check email - I send admin access to test Joomla + Phoca with 20k items (look time to load page with product list)

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 43634
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Hard SQL request

Post by Jan » 06 Jan 2018, 21:27

Hi, I have answered your email.

2) In Joomla! 4, the SQL strict rules are used, so all "group by" must by full (long) - ONLY_FULL_GROUP_BY
See:
https://github.com/joomla/joomla-cms/pull/12494

Jan
If you find Phoca extensions useful, please support the project

Post Reply