• Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
  • Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
Quick Support
Book Demo

Application-wide Caching in Acumatica with Slots and IPrefetchable

By admin on September 27, 2018April 19, 2019

I’m doing a guest post this week for my awesome friends at the Acumatica Developer Network on a technique that I covered during my session at the last Virtual Developer Conference and is not widely used by developers outside the Acumatica development team — slots and the IPrefetchable interface.

When monitoring and profiling any database-driven application, you often see the same queries and the same data accessed over and over again by different modules and users of your application. The performance hit of these queries may not be evident at first, especially if they’re simple. However, as the number of users and the complexity of your application increases, the effects compound and ultimately result in noticeable overhead.

What if you could load this data once, cache it, and make it available to every session? The Acumatica framework provides a mechanism to do this called “slots”. Acumatica provides a special interface, IPrefetchable, that enables lazy-loading of your data the first time that it’s needed and takes take care of invalidating your cache, if and when the cached data gets modified elsewhere in the application.

Internally, slots are used for many scenarios. Examples of structures that are cached in slots include:

  • Access Rights
  • Site Maps
  • Segmented Key Configurations
  • AR/AP Discount Rules

Continue reading on the ADN Blog: Application-wide Caching with Slots and IPrefetchable


Application-wide Caching in Acumatica with Slots and IPrefetchable was originally published in Velixo on Medium, where people are continuing the conversation by highlighting and responding to this story.

Source: Velixo

Post navigation

Gain added flexibility by downloading your Sage Intelligence reports to Excel
9 reasons why CFOs, controllers and accountants prefer Excel over Acumatica ARM for their financial…

Recent Posts

  • Why Working In Excel Works
  • Alchemex Welcomes Velixo 6 For MYOB Advanced
  • Welcome to Velixo Reports Version 4.2
  • Part 3 of 3: Learn how to create a Management Pack in Sage 50cloud Intelligence
  • Part 3 of 3: Create and customize reports easily with the Financial Report Designer

Search

Contact Us

Phone: +61 2 9890 2339
Email: sales@alchemex.com.au
Address: PO Box 212, Deaken West, Canberra, Australia, 2600

Products

  • Intelligence Reporting
  • Velixo Reports

Services

  • Consulting
  • Training
  • Development

About

  • About Us
  • Partners
  • Blog

Support

  • New Ticket
  • Community (Coming Soon)
  • Knowledgebase

Phone: +61 2 9890 2339
Sales: sales@alchemex.com.au
Support: support@alchemex.com.au

Facebook-f Linkedin

© All rights reserved Alchemex Pty Ltd 2020

Made with ❤ by Unfazed Ltd