[ic] flypage / IC efficiency?

IC ic at tvcables.co.uk
Sat Sep 17 18:26:28 UTC 2016


> >> if I remember correctly, there is a possibility to "prefetch" product
> > data.
> >>
> >> You can define a "SpecialSub flypage" and return a structure with the
> >> product
> >> data, which would be available on flypage.
> >>
> >> I can't give you more details at the moment, but this SpecialSub is
> >> called in Vend::Interpolate::fly_page.
> >>
> >> Regards
> >> 	Racke

Hi Racke,

I can't find much info on using SpecialSub flypage other than it will call a
block of perl code?

As a sanity check I tried a default flypage and although better it still
made 32 queries, 15 of these were the same select 'sku query' repeated,
before every query it repeats the same select sku query, its doubling up the
number of queries with repeats.

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?

Regards,
Andy




More information about the interchange-users mailing list