[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