[ic] flypage / IC efficiency?
Jon Jensen
jon at endpoint.com
Sat Sep 17 18:37:20 UTC 2016
On Sat, 17 Sep 2016, IC wrote:
> With a totally empty flypage.html IC stills runs 6 queries:-
>
> 3830956 Query select sku from products where sku = 'test-sku'
> 3830956 Query select template_page from products where sku = 'test-sku'
> 3830956 Query select sku from products where sku = 'test-sku'
> 3830956 Query select description from products where sku = 'test-sku'
> 3830956 Query select sku from products where sku = 'test-sku'
> 3830956 Query select category from products where sku = 'test-sku'
>
> This is crazy, the whole page should be generated with 3 or so queries, but
> IC is using 6 queries with no tags on a blank page, they need to be
> aggregated into efficient queries.
>
> I can't find in the core where these flypage queries are generated?
They are generated by [item-field], as someone already mentioned.
You can rework the flypage to use a [query] tag to fetch whatever you want
in a single query and then use [sql-param] to access the values without
any further hits to the database.
Jon
--
Jon Jensen
End Point Corporation
https://www.endpoint.com/
More information about the interchange-users
mailing list