ActiveSQL vs DataLayer.SQL. My Observation.

Has anyone else noticed degraded performance when using ActiveSQL with MySQL?

I created a basic Analysis grid using the Wizard then replaced DataLayer.SQL with ActiveSQL thinking this would be more efficient. When running the report from my laptop it would time out with messahe “Action impossible while not connected”. I added &rdAgDataRetrieval=Pause to the end of the URL improved times considerably but how much?

These results were while running debugger on my laptop. I thought it was interesting that, in MySQL, ActiveSQL takes about twice as long.

DataLayer .ActiveSQL time to run, 87.408. DataRetrieval paused, 5.218.

DataLayer.SQL time to run , 49.190. DataRetrieval paused, 2.160