June 20, 2005 at 10:41 am
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.
June 20, 2005 at 10:56 am
For future reference, please do not post the same question in multiple forums.
Please refer here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=192152
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply