Hi Juan,

In general, it is always better to draw summary information from a smaller set and store that information rather than reprocess all data all of the time. It sounds like you're moving into the realm of "data warehousing". You may wish to do some reading on that topic; you may find a way of structuring your data or your process that speeds things up.


>The process is to obtain the final resoult about a lot of diferent surveys. There are 3 kind of surveys of 300 items each. We need to obtain results from any single item of the survey and diferent levels of grouping of items. There are 2500 surveys every 3 months. Every target of the surveys is grouped in 10 diferent levels. I need results for all of the levels of targets and items.
>
>The tables has an Index for every level of target to obtain rankings. What I've been thinking to do is to make the process in temporal tables every period (3 months) and when it is finished add to the main tables.
>
>Any suggestion?