> -----Original Message-----
> From: Yves Glodt [mailto:yg@...]
> >>
> >> Hello,
> >>
> >> we are trying to enhance performance of an application we
> resell. It
> >> has about 50 tables, and one of them contains many rows of
> calculated
> >> data (about 1300000). The field IPN is the persons id who the data
> >> belongs to. With 45 persons, that makes ~28000 records per person.
> >> Selects are mostly made of the 5th column, with the first
> 4 columns
> >> in the where-clause.
> >
> > You'd probably get better help by sending a query that seems to be
> > slow, along with the plan that FB used.
> >
> > Without example queries it's very difficult to offer index
> suggestion.
>
>
> yes I can imagine that... unfortunately I don't have access
> to the source of the program :-( Is there a way to see the
> queries that are sent to the server?

You might be able to find some by hex editing the executables. I'm not sure
if there's some way to monitor FB engine... I'd think so but I've never done
it.