Web Designer queries slow - v8

Hi Experts

I'm doing some performance analysis on the front end. 

We load a collection using the web database query (essentially a join between a few tables), and when I look in the log this query takes a long time to run (nearly 7 s)

However, when I run the same query directly in SSMS or Object browser, the query takes a few milliseconds

My question is: Does the portal set some SQL connection variables which might be slowing down the execution? 

Thanks

Kin 

Parents Reply Children