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   64 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.




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