On the InterBase 2007 partner tools CD I kind of quietly released InterBase PLANalyzer 1.2. A few people have spotted it on CodeCentral. But there was a Help bug I needed to fix, so I’ve waited until I had time to fix that to announce it. Anyway, that’s taken care of now, so here’s what’s in the latest version of this free tool:
Version 1.2.1
- Version 1.2.1 fixes a bug displaying online help that was introduced in 1.2.
- InterBase PLANalyzer now supports InterBase versions 5.6 through 2007.
- You can print the SQL, the PLAN tree, and the reads chart. Select the appropriate tab and choose File->Print.
- Several PLAN parser bugs fixed. Handling of SQL Dialect 3 DBs improved.
- The connect dialog now displays the last DB you opened by default, if you choose to remember DB names.
- The user interface has been tidied up and XP themes are now supported. Also, IB PLANalyzer now stores your selected options in the Application Data directory (the actual location varies depending upon your operating system) instead of the directory containing the EXE. This means that each Windows user gets their own settings, and you don’t have to be an administrator to run the program.
- The record count of the result set from a SELECT statement is displayed in the status bar.
- I’m no longer buffering the results for the grid on the SQL tab in a TClientDataset. This eliminated a few bugs, some of them significant, which were caused by that component. If you’re using an older version of InterBase (prior to IB 7) the grid will stop displaying after about five minutes or so to prevent long-running transactions. With IB7+ the application will do a commit retaining from time to time to achieve the same goal while keeping the grid active.
- Many other small bug fixes.
(What is InterBase PLANalyzer? It’s a tool which helps you quickly optimize InterBase queries. It’s free.)
{ 5 } Comments
I have a irritating problem with Planalyzer 1.2.324.
I can execute a query once, after that: key violation.
Also occurs when executing a query with 2 left joins of the same table but with different alias. Seems because of difficult plan?
Cannot reproduce with demo database, but can email plan of statement.
Do you also have some code how to retrieve these statistics from interbase? I really would like to do it for debug/test my application!
Andre, that bug should be fixed in v. 1.2.1.
To get the statistics, I use an IBX component called TIBStatisticalService. The only things that are at all tricky is (1) you have to do a fetch all before the stats are meaningful, and (2) that the stats are cumulative, so you must remember what the stats were before you run the query/fetch, then get them again, and take the difference to get the stats for the query.
I am using PLANalyzer 1.2.1 with Firebird 2.0.
When I execute a query of a view, I get the following error:
TPlanPaser.ParsePlanItem: Unrecognized PLAN syntax — "NATURAL", "INDEX" or "ORDER" not found after alias: PK_USERFIELDID))))
Is PLANanlyzer full compatible with FB 2.0?
Thank you
Where can I download Planalyzer ? The download link seems to be broken.
Regards Roland
Roland, the download link works for me, but I did just update it to remove the redirect via Borland (which was working, but out of date).
Post a Comment