Re: Need help optimizing a view, too many queries

2009-05-08 Thread Daniel Roseman
On May 8, 12:03 am, Daniel Roseman wrote: > On May 7, 5:56 pm, Eric Chamberlain wrote: > > > Our view is taking too long to render, can anyone offer suggestions to   > > improve its speed? > > > There are 5830 profiles. > > > Total query count: 23809 > > Total duplicate query count: 493 > > Tota

Re: Need help optimizing a view, too many queries

2009-05-07 Thread Daniel Roseman
On May 7, 5:56 pm, Eric Chamberlain wrote: > Our view is taking too long to render, can anyone offer suggestions to   > improve its speed? > > There are 5830 profiles. > > Total query count: 23809 > Total duplicate query count: 493 > Total SQL execution time: 66.003 > Total Request execution time

Re: Need help optimizing a view, too many queries

2009-05-07 Thread George Song
On 5/7/2009 11:16 AM, Eric Chamberlain wrote: > > On May 7, 2009, at 10:36 AM, George Song wrote: > >> On 5/7/2009 8:56 AM, Eric Chamberlain wrote: >>> Our view is taking too long to render, can anyone offer suggestions >>> to >>> improve its speed? >>> >>> There are 5830 profiles. >>> >>> /To

Re: Need help optimizing a view, too many queries

2009-05-07 Thread Eric Chamberlain
On May 7, 2009, at 10:36 AM, George Song wrote: > > On 5/7/2009 8:56 AM, Eric Chamberlain wrote: >> Our view is taking too long to render, can anyone offer suggestions >> to >> improve its speed? >> >> There are 5830 profiles. >> >> /Total query count:/ 23809 >> /Total duplicate query count:/

Re: Need help optimizing a view, too many queries

2009-05-07 Thread George Song
On 5/7/2009 8:56 AM, Eric Chamberlain wrote: > Our view is taking too long to render, can anyone offer suggestions to > improve its speed? > > There are 5830 profiles. > > /Total query count:/ 23809 > /Total duplicate query count:/ 493 > /Total SQL execution time:/ 66.003 > /Total Request execu