For the query times I am basing the OpenBD supplies times on the number provided in the query object dump. I would have thought thatthat that was calculated before any rendering.
Magnus On Saturday, 6 December 2014 01:32:46 UTC-8, Al Holden wrote: > > 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 [email protected] <javascript:>. > 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
