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.
