>
> A view is the same thing as a normal query and is only prepared and
> executed at the time you need it.
>
> What is the result that you are looking for? Maybe a selectable
> stored procedure is what you need. That's what I use for the aged A/R
> in my application, and the performance is very fast, and that's with
> 30,000 clients and 100,000 invoices(the invoices).
>
> BTW, my application is not an accounting system.
>

The result I want is a dataset (I work with delphi) so I can show this
dataset on a report made with FastReport.

What do you mean with selectabel storede procedure?

How do you access 100.000 invoices quickly?

thanks