mrc logo mrc logo
  • m-Power m-Power
    What is m-Power?
    Overview Demos Build Process Case Studies Specs Pricing Trial
    m-Power Resources
    Overview How-To Videos Webinars & Podcasts White Papers Fact Sheets
  • Solutions Solutions
    What does m-Power build?
    Overview Database Front-Ends Reporting CRM Systems Business Intelligence Dashboards Inventory Management Mobile Apps ERP Enhancements Modernization Spreadsheets to the web MS Access to the web B2B/Web Portals Scheduling Embedded Analytics Web Forms Workflow Data Exploration Budgeting & Forecasting APIs and Web Services Db2 Web Query Alternative
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Services Services
    Development Services Training Mentoring
  • About About
    Overview Partners Press Releases Careers Events Contact Blog
  • Support Support
    Support Home FAQ Documentation Customer Portal Enhancements Updates Roadmap Techblog
Try m-Power

m-Power Manual

Browse:

  • Home
  • Reports
  • In-Memory Reporting
Back to Manual

In-Memory Reporting

The architecture of m-Power reports allow them to query data from a variety of sources, including:

  • -A database, via a JDBC connection
  • -Web Services
  • -In-Memory
  • This documentation will focus on the final point listed above, In-Memory Reporting. It is important to note that while In-Memory Reporting may offer considerable performance advantages from Web Services and database connections, it is only recommended to use in limited situations. One common use of in-memory reporting is for use in high visibility graphing and dashboards. Other good uses of this feature would include any case where data is somewhat stagnant yet frequently accessed.

    To begin, developers first need to create a Summary application type, using the In-Memory Summary template. When this template is compiled and run, the generated data will be stored on the application server rather than the database. It is recommended to use m-Power's Messaging and Scheduled Task feature to automate the regular running of this summary, allowing the data to refresh as needed.

    Once the summary has been created, build your Report and select your In-Memory summary table. Please note that since In-Memory Reporting does not utilize the database whatsoever, some common m-Power features will not be available, including table joins and database calculations. If joins or database calculations are needed, you are encouraged to implement these within the summary application.

    The embedded video below explains the process in more detail:

    Continue building the report as you would build any other standard application. At run-time your application will query the In-Memory data set rather than the database.
    Note: The first time the data set is run, the performance may be slower than normal, as extra overhead is required to load the data into memory.
    Note: Since the data set was generated from a summary, please remember that the data will be stagnant until the summary is re-run allowing the data to be updated.
    Note: Because the data lives in-memory, any dropdown lists that are added to record selections need to access data from an External application.

Created: August 12, 2015 | Modified: June 12, 2017

Search


Browse By Category

Build Process (13)
Starting with m-Power (8)
Retrievals (10)
Reports (15)
Summaries (4)
Maintainers (17)
Graphs (8)
m-Power Data Explorer (4)
General (24)
Calculations (5)
Utilities (9)
m-Power Administration (23)
Security (11)
Freemarker (6)
m-Painter (29)
Form Validation (5)
External Objects & UDFs (12)
Deprecated Documentation (23)
Bootstrap Templates (7)

Popular Tags

DB2 Dates Security Summaries Graphing Data Dictionary Freemarker Calculations Report Java Graphs Build Process Record Selections Reports Bar Graphs Compiling App Properties Production Database Performance Retrieval Prompt Screens Dropdowns Advanced Parameters Popular Email Graph Properties Maintainer Form Validation Video Bootstrap Templates Getting Started m-Painter Administration External Objects Excel Application Properties RPG Tomcat Admin Maintainers Retrievals mrc-Productivity Series SQL

See all tags »

michaels, ross & cole, ltd. (mrc)

Privacy Policy Cookie Policy Cookie Settings Notice at Collection Do Not Sell or Share My Personal Information

mrc (US)

2001 Midwest Road
Suite 310
Oak Brook, IL 60523
630-916-0662

mrc (UK)

Mortlake Business Centre
20 Mortlake High Street
London, SW14 8JN
+44-20-335-59566


© 2024 mrc. All rights reserved.