Hi guys,
I have mediachase 4.1 that use an SQL server 2005 for store data an runs in a windows 2008 environment platform.

I have the problem with "VersionLoadByCustomerProduct" stored procedure. The stored procedure takes more than 17 seconds to run.

I have created a new user control inserted into a PagingCategoryTemplate that list all available download for each product into a specific category.

With a profiler I have find that the problem is in this query:

SELECT DISTINCT P.ProductId, D.DownloadId, D.[Name], V.VersionId, V.Version

                                    FROM Product P, Sku S, Version V

                                                INNER JOIN Download D ON V.DownloadId = D.DownloadId

                                                INNER JOIN Policy P1 ON P1.PolicyId = D.PolicyId

                                                LEFT OUTER JOIN ObjectDownload OD ON

                                                D.DownloadId=OD.DownloadId

For info the Product table contains 2750 products, the Sku table 2750 sku's and the table Version 120 records.

Any suggestions?

Thx!