Logi Info Forum Threads    >    Posts


Preload Data/Cache When Logging Into Application

J. Reitter
United States

26 Jul 2019 10:55 AM
   
This thread is open for replies.
12.5 SP8   .NET app   131 views   Subscribe  


For performance purposes, we would like to "pre-load" data/create a cache when a user logs into our system, but the pre-loaded data needs to be custom to each user and should run in the background, i.e., any initial reports, dashboards, etc. are not impacted while the "pre-load" runs, as long as the "pre-loaded" data is not being used in an initial login report/dashboard.

  • Since we do not know who will be logging in, we cannot run a process early morning to try and load data for all users.
  • Also, the data may contain either hundreds or thousands of records (but we, in general, have the performance down so data loads take 1 minute or less). 

For instance, one user might be this:
SELECT COUNT(InvoiceNo) as CntInv, MIN(InvoiceDate) as MinDate, MAX(InvoiceDate) as MaxDate, SUM(InvoiceTotal) as SumInv, SUM(Taxes) as TotalTaxes
from dbo.InvoiceTable
WHERE Shipper = 'Logi Analytics'

While another user might be this:
SELECT COUNT(InvoiceNo) as CntInv, MIN(InvoiceDate) as MinDate, MAX(InvoiceDate) as MaxDate, SUM(InvoiceTotal) as SumInv, SUM(Taxes) as TotalTaxes
from dbo.InvoiceTable
WHERE Shipper = 'ZoomData'

Part of the idea is to make the data available for subsequent dashboard elements, reports, etc. 

Blake Ryner
United States

29 Jul 2019 03:57 PM

Is it possible to create a table with these rollups done ahead of time on all of your data?  That way it is a quick one row lookup by id?

We have various fact tables for different grains and has allowed us to get pretty good performance on reads.



Contact

United States
7900 Westpark Drive
Suite A200
McLean
Virginia, 22102
1-888-564-4965
salesteam@logianalytics.com

United Kingdom
Scott House
The Concourse
Waterloo Station
London, SE1 7LY
020 3103 0306
emea_sales@logianalytics.com

Ireland
20 Harcourt Street
Suite 10
Dublin
D02 H364
3531 400 7506


© Copyright 2020 Logi Analytics, Inc. All Rights Reserved           |          Contact DevNet          |          Site FAQs          |          Terms of Use          |          LogiAnalytics.com