Does EDB Server have any configuration tables or log files that report slow query performance statistics?

This would be an easy way to find unoptimized queries in an application without having to debug it. I can implement it in my application easy enough (because all queries go through a central procedure), but I'm wondering if Tim has some monitoring at the server level?

Barry

In MySQL there is a slow query log text file that will log queries that take longer than 'x' seconds. Does EDB have something similar? There are also 3rd party tools out there for MySQL (MonYog) that will monitor performance at real time which is kind of neat. It displays a dashboard with gauges showing the performance of server. https://www.webyog.com/webyog/monyogscreenshots

Barry,

<< Does EDB Server have any configuration tables or log files that report
slow query performance statistics? >>

You have a few options here:

1) This will tell you how much I/O you're incurring per
session/database/table:

http://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=ServerSessionStatistics_Table

2) You can use the ExecutionTime of any SQL statement execution to determine
how long it took:

http://www.elevatesoft.com/manual?action=viewprop&id=edb2&product=delphi&version=7&comp=TEDBQuery&prop=ExecutionTime

<< This would be an easy way to find unoptimized queries in an application
without having to debug it. I can implement it in my application easy enough
(because all queries go through a central procedure), but I'm wondering if
Tim has some monitoring at the server level? >>

The quick answer is "no".  Although, it's easy enough to add it to the
informational logging in the engine/server.  I'll add it to the enhancements
list.

Tim Young
Elevate Software
www.elevatesoft.com