June 6, 2011 at 12:20 pm
I have a function that retreives summary data often. So i can get this data, i create temporary tables to store some filtered data and then select some rows of this table based on several options.
I think this have a great overhead when this query runs..
I'm considering use a trigger to update a summary table after data is changed, but i don't know if this method could be faster.
How do i evaluate the fatest method?
Regards
June 6, 2011 at 12:28 pm
I have a function that retreives summary data often. So i can get this data, i create temporary tables to store some filtered data and then select some rows of this table based on several options.
I think this have a great overhead when this query runs..
I'm considering use a trigger to update a summary table after data is changed, but i don't know if this method could be faster.
How do i evaluate the fatest method?
Regards
You have a couple of options, as I see it... (mind you, my eyesight isn't great)
1. create a job to get/move the summary data into your "reporting" table(s) at scheduled times
2. create triggers to do the same when the data is modified.
Fastest method? Only one way to find out: benchmark.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply