Re: Options to speed up a 7 table join executed frequently.

From: Bill Ferguson <wbfergus_at_gmail.com>
Date: Wed, 23 Mar 2011 06:49:47 -0600
Message-ID: <AANLkTikfyVefsB9wMywhQ557ftVpFrX3KviiS8wjAw00_at_mail.gmail.com>



Though it was kind of a pain to get setup, I had a similar problem, but one I created, not some develeopers. My approach was to setup triggers on the tables the various data pieces came from. Then in the trigger itself, I write the pertinent information into another table set up solely for these frequent queries.

Not all that elegant, but it's a heck of a lot faster than the original way of joining all the tables together.

--

Received on Wed Mar 23 2011 - 07:49:47 CDT

Original text of this message