Running a simple SQL (Select * from HCM_Employee) takes a very long time for me and never returns.
Another user runs that same query and it returned very quickly with results. Where should look to solve this issue?
Thanks
Hey Patrick,
There could be a few reasons why this is happening but the most likely scenario is that the data for your HCM_Employee table is being pushed through an optimization process in the background that A) provides faster query response times and reduces the amount of data scanned to return you an answer.
I know, sounds funny that A above is "provide faster query response times" when you're clearly seeing a long time to process
The first time you run a query against a table, we trigger this optimization pipeline. If you've been putting in a lot of HCM_Employee data into the Data Lake, then this could likely be the reason why it's taking a little longer - Data Lake is taking all of those files and optimizing them before running the query. Once this process is done, your query should run relatively quickly and you'll see that in subsequent queries, it performs as you'd expect.
There are a few things we're doing at Infor to improve this. The first is we're adding in several enhancements that will speed up this optimization step. Second, we're going to update the Compass UI/UX to better indicate when the query is running vs. simply being prepared. Lastly, we're evolving our optimization pipeline to run automatically behind the scenes without waiting for a user to query or trigger this data prep step.
If you're still seeing issues or you're seeing consistently slow performance times, you can submit an incident to Support with your Query ID(s) and we can take a look to see what's happening here.
Mike,
Thanks for replying with clarifications and yes I opened a ticket.
Patrick
