Re: [OpenBD] Query Execution times

['Alan Holden' via Open BlueDragon]

Both the CFDUMP and the Debug output can be resource intensive. Those two can inject a good amount of rendering script and css. As is the case with so many other experiments, the tools we use - to observe the outcome - can change the outcome itself. See if you can use other profiling methods, maybe CFTIMER ? I'd be interested to see if your numbers get any better. Al On 12/5/2014 10:09 PM, 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 openbd+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- -- 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 openbd+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.