[ic] flypage / IC efficiency?
Stefan Hornburg (Racke)
racke at linuxia.de
Sat Sep 17 14:47:03 UTC 2016
On 09/17/2016 03:57 PM, IC wrote:
>> Hello Andy,
>>
>> 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 need to run some tests on our current flypage, its running a crazy number
> of queries, 271 for a single page load, we do use a highly customised
> products table and liberal use of [item-field somefield] but not that many!
> We also use timed build as well and I tested logged out in a new session.
>
> Looking at the mysql log it ran this select sku query 124 times in 1 page
> load:-
>
> 3807628 Query select sku from products where sku = 'my-test-sku'
>
> Regards,
> Andy
Hello Andy,
in that case it would really pay out to gather all the data needed
in the flypage SpecialSub and create a custom flypage.
Regards
Racke
--
Ecommerce and Linux consulting + Perl and web application programming.
Debian and Sympa administration.
More information about the interchange-users
mailing list