I should have asked about the optimization level which should be 'none', 'partial' or 'full' after you issue =SYS(3054,1) and run the Query.

Also what would be the response time if you run the Query on the same machine where the data is?

That may shed some light on whether the Query can be sped up.