Hi,

At February 18, 2004, 06:57, emisutil wrote:

> I´m developing an accounting application and I have a table with near
> 50.000 records and other table with 15.000 record. When I try make a
> view with this tables with 3 sum() over numeric fields it takes a lot
> of of time to give me the result. This make me think about my view is
> not properly design, so I want to know if is there any tip to make
> this views to make them faster

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.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)