[SQLObject] Re: Re: FireBird / Interbase

[Ian S. <ia...@et...>]

"James Ralston" <jcr...@ya...> wrote in message
news:200...@we......

> "Mostly" is an important word here.  The initial cut
> at ib/fb support was done against the .4 release of SO
> instead of the cvs version <doh!>.  That has been
> corrected but Ian (Bicking) has been buried (I hope

It doesn't look like your changes are in the SF CVS - are you keeping them
somewhere else? Accessible? I'd rather not have to find all the known issues
myself.

> Nice feature.  Although, in my experience, most db
> optimizations are done after the fact...when the
> "great dba in the sky" does his cypherin' (wink to
> Jethro from the Beverly Hillbillies) on which fields
> will most greatly benefit from index additions.

True, but once that has happened you really want to feed that information
back into the model. At least I do.

I don't know of a way to extract the Query Plan from kinterbasdb but if this
exists then debug mode could extract the plan, do a count of NATURAL and
give you a list of queries that require optimization. This at least makes
the DBA's job easier. Most of us can't afford to have a truly great DBA on
staff but with the help of PLAN we can add indexes to remove all the natural
joins and at least make them much more efficient.

Thanks James, Firebird support is already usable. If I can help in any way
to improve the FB support I'd be glad to.

- Ian Sparks.