[ic] flypage / IC efficiency?
IC
ic at tvcables.co.uk
Sat Sep 17 18:45:34 UTC 2016
> > 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
Hi Jon,
Those 6 queries are generated by a *completely blank* flypage.html with no
[item] tag on it, there is no reason to run the query 'select sku from
products' 3 times without even a single tag on the page, where are these
queries generated in the core, I cannot find it??
Regards,
Andy
More information about the interchange-users
mailing list