Support » Plugin: Auto Amazon Links - Amazon Associates Affiliate Plugin » Plugin is caching user reviews

  • Resolved nicolaottomano

    (@nicolaottomano)


    Hi @miunosoft
    I noticed that the cache-related MySQL tables are getting bigger.
    So I searched on the support forum and found how to reduce cache by setting expiration and auto-clean Cron tasks.

    Now, going deeper into this topic, I noticed that the plugin is caching reviews into aal_request_cache table, which weight around 300-400 KB each.

    Do the reviews caching is needed? And, could it be possible to deactivate it if not used?

    Thanks,

    Nicola

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author miunosoft

    (@miunosoft)

    If %review% is not set in the Item Format unit option, they shouldn’t be neither fetched nor cached. If they do, let me know.

    Thread Starter nicolaottomano

    (@nicolaottomano)

    I don’t have units right now, only the AALB-converted shortcodes.
    In Settings -> Default I have the following Item Format for the List template:

    
    <div class="amazon-auto-links-product">
        <div class="amazon-auto-links-product-image">
            %image%
        </div>
        <div class="amazon-auto-links-product-body">
            %title%
            %rating% %prime% %price%
            %description%
            %disclaimer%
        </div>
    </div>
    
    

    But digging into aal_request_cache, I see lot of “customer_review2” type rows.

    Plugin Author miunosoft

    (@miunosoft)

    Ah, I see. %rating% also triggers the review look-up routine.

    Can you temporary remove %rating% to see if it makes any difference?

    Thread Starter nicolaottomano

    (@nicolaottomano)

    Yes, now it is working properly.
    I only see api type into the table.

    Plugin Author miunosoft

    (@miunosoft)

    Okay. Would it be okay for you to go without star ratings? Or is it something critical for you to have?

    You seem to care the size of the database. If they are cached in actual files, do you care the size as much as you do for the database? I’m wondering whether to implement the ability to cache data as files.

    Thread Starter nicolaottomano

    (@nicolaottomano)

    Okay. Would it be okay for you to go without star ratings? Or is it something critical for you to have?

    It is not really important for me to have rating stars on products. Just nice to have šŸ™‚

    You seem to care the size of the database. If they are cached in actual files, do you care the size as much as you do for the database? Iā€™m wondering whether to implement the ability to cache data as files.

    I have un limited disk space on my hosting, while the database size is limited to 1 GB so, from my perspective, I really care not to store things into the DB.
    Anyway, since I don’t really need to show user reviews on products, I think the DB tables would be not as big as before.
    Now, with 64 products cached, the whole cache size is less than 1 MB VS over than 20 MB before (I mean with user reviews caching).

    I have another question, if I buy a PRO license right now, would it works with the current beta?

    Plugin Author miunosoft

    (@miunosoft)

    @nicolaottomano Did you delete your last reply? I received a notification Email from wordpress.org but I don’t see the message here. In case of a pre-sale inquiry about Pro, please use the contact form. Thank you!

    Thread Starter nicolaottomano

    (@nicolaottomano)

    @miunosoft
    Akismet put all my replies in moderation, so I only have to wait to be enabled to comment again.

    Plugin Author miunosoft

    (@miunosoft)

    I see. I’ll respond to your pre-sale inquiry Email.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Plugin is caching user reviews’ is closed to new replies.