[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