Then, specify the interval for query execution – by default it runs each 10 seconds, and number of stored measurement points. Try to put there some “heavy” query, which is used in real application and make sense for end users. Please note: this SQL must be SELECT query! Run Response Checker from Start menu “IBSurgeon\FreeTools\IBSurgeon Response Checker”, and insert text of your test SQL query into the appropriate field (see below). How to setup Response Checker to measure response time? As a result, you’ll be able to recognize time periods when database works slow.įor professional Firebird database optimization service please look here.Ģ. Response Checker allows you to specify an SQL query (some kind of heavy query), run it with the specific period and measure its response time. How to measure the average and maximum response times in real-world production environments running Firebird? For the basic response time measurement you can use IBSurgeon Response Checker. Response time is what your end users will refer as «slow», «very slow» or «good enough» (end users never say that your software is «fast»). There is no reason to measure average response time out of the scope of your real application, until you want some abstract «optimization» - or you are using test environment which is proven to be very close or even identical to your production database.
Response time should be measured with your real-world application and with your production database (or in test environment which simulates production close enough). And, Firebird database performance has such criteria: If you are trying to improve Firebird database performance, the first thing you need to define is criteria of performance optimization.
These tools are simple to use, below you can find their short overview and frequently asked questions. investigate Firebird log for errors and warnings, (“Log Viewer”).view how much data, indices, blobs, etc, are stored in your Firebird or InterBase database (“DBInfo”).measure response time of specific SQL query to find time when query runs slower than usual (“Response Checker”),.IBSurgeon Free Tools is a pack of 3 tools for Firebird and InterBase administrators and developers, designed to facilitate several typical tasks: IBSurgeon Free Tools are included into HQbird Standard. IBSurgeon Free Tools Guide (PDF, English).
0 kommentar(er)
