Hi,

> Is there any way that I can see what FB SuperServer is
> currently "doing"?
>
> I am trying to convert a program written for MS SQL Server and one
> query which used to run in about minute just returned on FB after
> about 30 mins! (yikes - I think I have to do some optimization!)
>
> But while that was running... I was trying to figure out if my
> program died or if FB was just chewing on the query...
>
> Is there any way to tell what FB is currently processing for the
> SuperServer architecture?

No, there isn't.

As for the query, try reading the query plan - that should help. Or
give us the query and the plan (as text).

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com