Posted by anjana sisodia via SQLMonster.com on 06/20/05 19:16

I have an area on our website where users can customize what data fields they
want to see displayed from a list of about 50 different fields. I have a
query that has about 50 subqueries to pull all this info and it has just got
to be extemely slow...sometimes even times out. I need to pull alot of data
from different tables and the only solution i can think of is to create
triggers on the different tables that i want to pull and store that info in
another table and then just run the query of that table so that there are not
50 - 60 subqueries. Is this a correct solution or does anyone have any other
suggestions? Any help in this area would be greatly appreciated. P.S.. I've
never worked with triggers before but did read up on it a bit.

[Back to original message]