It's all about the answers!

Ask a question

LQE vs DW in 606


Sean F (1.3k243150) | asked Sep 21 '18, 10:07 a.m.
I was testing JRS on a standalone environment.

I found that the DW source always seemed to report out of date data.

When I switched to LQE the reported data was always fresh.

Is this a valid reason for choosing LQE over DW?

Which data source are most folk using in production environments for JRS and why?


Accepted answer


permanent link
Davyd Norris (2.2k217) | answered Sep 21 '18, 8:55 p.m.
DW runs its ETL jobs on a schedule, which by default is done at 1AM and 3AM every night. LQE runs its jobs every 5 minutes or so.

You can increase the frequency of the DW jobs but this will have a performance impact on the server - I would recommend you do it at the lowest load times
Sean F selected this answer as the correct answer

Comments
Sean F commented Sep 22 '18, 5:01 a.m.

Thanks Davyd

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.