Subject Re: [firebird-support] View takes longer than select, FB 1.5
Author Alexandre Benson Smith
Rick Debay wrote:
> Never mind. I reread the section where you wrote "Views that uses
> aggregates on FB 1.5 move the WHERE clause to the HAVING clause".
> That explains why it takes as long as an unfiltered query, where I want
> results for all entities, not just one.
> Until IBObjects allow us to move to FB2, we'll just have to change our
> business process to run all reports at once instead of on demand.

Or use a direct select on tables instead of views.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil