Subject | tips for increase performance |
---|---|
Author | emisutil |
Post date | 2004-02-18T10:57:52Z |
Hello
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
Thanks
Emiliano Sutil
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
Thanks
Emiliano Sutil