Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Dashboard widgets showing QoH should now be using inventory snapshot data #89

Closed
jmiranda opened this issue Sep 13, 2015 · 1 comment
Closed
Labels
type: maintenance Code improvements, optimizations and refactors, dependency upgrades...
Milestone

Comments

@jmiranda
Copy link
Member

The current dashboard widgets calculate (and cache) the QoH values for all products at the given location on the fly (i.e. on the first request for the dashboard). Subsequent requests use the cached data. However, the initial request takes about 45 - 60 seconds and is unnecessary since we should now have that data stored in the inventory snapshot table.

@jmiranda jmiranda added the type: maintenance Code improvements, optimizations and refactors, dependency upgrades... label Sep 13, 2015
@jmiranda jmiranda modified the milestone: 0.7.4 Sep 14, 2015
@jmiranda jmiranda added the ready label Oct 6, 2015
@jmiranda
Copy link
Member Author

jmiranda commented Apr 30, 2016

The old dashboard contained data that was stale for about 12 - 24 hours. An admin user could flush the dashboard cache which refresh this data, but this seems to be used infrequently. Now the data should only be stale for about an hour as the dashboard data is now pulled from the inventory_snapshot table which is refreshed every hour.

# Every hour on the hour
openboxes.jobs.calculateQuantityJob.cronExpression = 0 0 * * * ?

You can change the refresh interval by changing the cron expression for the calculate quantity job in openboxes-config.properties. Anything less than 5 minutes might impact performance so I would recommend setting the cron expression to run every 5, 10, or 15 minutes.

# Every 15 minutes
openboxes.jobs.calculateQuantityJob.cronExpression = 0 0/15 * * * ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type: maintenance Code improvements, optimizations and refactors, dependency upgrades...
Projects
None yet
Development

No branches or pull requests

1 participant