Hi there,

> > > At Upscene, we also sell a tool named "IBLogManager" - this is a
> > > seperate tool (not an add-on for Database Workbench) that is more
> > > advanced than the data-logging facility in IBExpert. The tool is
> quite
> > > cheap and offers lots of features,
> >
> > Second that. ;-)
>
> i was not surprised on that :-)

Me neither that you jump in here. ;-)))

> but
>
> there are different perspectives what logging means. When you compare
> ibexpert´s internal logging possibilities, there are sure some things
> more in IBLogmanager (it is in Fact worth the money, when you need
> the additional features).
>
> But when you have a look at IBMonitor (included in IBExpert Package),
> there is a lot of informations, that are not possible in
> IBLogmanager, for example I/O Bytes, Connection Statistics, Select
> Statements are also logged, Plans and Execution Time are logged for
> each Statement, IP and Computername and Sessionnumber of the Client,
> not only the Username, failed Logins, and other useful informations.

You are talking about a proxy application intercepting
any requests from the client sent to the server, right?

I've once seen a freeware tool which does that as well,
probably not with that huge bunch of information you
are providing.

Pretty useful, for sure. ;-)

Does that work with parametrized queries as well?

> >From my personal experience with a lot of jobs on optimizing the
> speed of customers applications, trigger based logging is only a
> small part of the solution.
>
> And one thing i also want to say:
>
> When there would be no competition, both companies (HK and Upscene)
> would not have this quality in their products.

Competition is a great thing to drive forwards and
to evolve.

> The customer can
> decide what he likes more (the same can we do when we meet again on
> the next firebird conference and order the beer ;-)

Ok, if I can decide, I would rather go with a glass
of wine than beer. ;-))

Cheers,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com