Hi Magnus, If you are running the query in OpenDB first and then taking the CFDUMP output of the query in to Workbench could the query not be cached and hence run signficantly quicker in workbench second versus OpenDB first. Have you tried it the other way round?
Regards, Lee On Saturday, December 6, 2014 6:09:36 AM UTC, Magnus wrote: > > I am doing some performance tuning on an application. I am trying to tune > up some queries to make them faster. As I have been doing this I have > noticed that the query exection times displayed by OpenBD in a dump or > debug output are significantly higher that the exact same query run in > MySQL Workbench. Sometimes an order of magnitude greater. > > Can anyone explain what is going on here. Why does a query that takes 16ms > in Workbench (returning 30 to 50 rows) take 160ms as shown by OpenDB. OR an > other query thatis so fast it shows as 0.000sec (0ms), show in OpenBD as > taking 600ms!. > > I suppose there is additional overhead in passing the data from MySL to > OpenBD but surely that can't be that inefficient? > > Thisa is on a Windows 7 development server with plenty of RAM. Not > especially new but fast enough. > OpenBD 3 > Tomcat 7 > Apache 2.4 > MyQL 5.x > > What is going on here? > > Thanks, > > -- -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en --- You received this message because you are subscribed to the Google Groups "Open BlueDragon" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
