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).
Hard SQL request
-
Jan
- Phoca Hero
- Posts: 48403
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Hard SQL request
Hi, I don't see anything strange on that screenshot, I see there one error when the database was not selected. 
What you exactly mean with the strange query?
Jan
What you exactly mean with the strange query?Jan
If you find Phoca extensions useful, please support the project
-
NeuroZ
- Phoca Newbie
- Posts: 4
- Joined: 11 Dec 2017, 21:25
Re: Hard SQL request
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)
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)
-
Jan
- Phoca Hero
- Posts: 48403
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Hard SQL request
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
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