Also create appropriate indexes on the columns used in JOIN On Tue, Nov 24, 2009 at 5:54 PM, Raghupathi Kamuni <[email protected]>wrote:
> Use Left Outer JOIN for joining tables > > AVMWeb_Items > AVMWeb_Item_Resources > > INNER JOIN for joining tables > > AVMWeb_Items > AVMWeb_ItemBrands > AVMWeb_ItemSubCategorys > > exec sp_executeSQL and pass the two parameters > > On Tue, Nov 24, 2009 at 4:09 PM, Kadir Avci <[email protected]> wrote: > >> Yes, I found a problem. Which is my sql procedure. >> Here is the procedure. I will change it but I don't know how can I write >> it different. >> >> ALTER PROCEDURE [dbo].[get_AVMWeb_Items_byAnaSayfa] >> @durum nvarchar(50), >> @urunSay nvarchar(50) >> AS >> BEGIN >> DECLARE @sqlStr nvarchar(4000); >> >> set @sqlStr = 'Select top ' + @urunSay + ' AVMWeb_Items.*, ' + >> '(select top 1 deger from AVMWeb_Item_Resources where >> AVMWeb_Item_Resources.itemID = AVMWeb_Items.id) as deger, ' + >> '(select top 1 deger2 from AVMWeb_Item_Resources where >> AVMWeb_Item_Resources.itemID = AVMWeb_Items.id) as deger2, ' + >> 'AVMWeb_ItemBrands.id as MarkaID, ' + >> 'AVMWeb_ItemBrands.brandname, ' + >> 'AVMWeb_ItemSubCategorys.id as AltKatID, ' + >> 'AVMWeb_ItemSubCategorys.subcatname ' + >> 'from AVMWeb_Items, AVMWeb_ItemBrands, >> AVMWeb_ItemSubCategorys ' + >> 'where AVMWeb_ItemBrands.id = AVMWeb_Items.brandID and ' + >> 'AVMWeb_ItemSubCategorys.id = AVMWeb_Items.subcatID and ' + >> 'AVMWeb_Items.durumanasayfaurun = ''' + @durum + ''' and ' + >> 'AVMWeb_Items.durum = ''' + @durum + ''' ' + >> 'order by NEWID()'; >> exec (@sqlStr) >> END >> >> >> >> Kadir Avcı >> Software Developer | Freelance Web Designer >> web: www.kad1r.com >> twt: www.twitter.com/kad1r >> Sent from Izmir, 35, Turkey >> >> On Tue, Nov 24, 2009 at 12:35 PM, Processor Devil < >> [email protected]> wrote: >> >>> I would say that you have a too much large files in the layout or you >>> simply use sql querying method that is well known as "pig coding", that >>> means you use too much database queries on one page... >>> >>> 2009/11/24 Kadir Avci <[email protected]> >>> >>> Hello. I have an e-commerce web project. But this website is very slow >>>> now. >>>> How can I optimize it? >>>> Its opening time is 16sec. To long. >>>> But my other websites are good. Max opening time is 5.68 sec. But this >>>> website I don't know why time is to long. They all use same webconfig. >>>> Here is my webconfig file. >>>> http://pastebin.com/m7022555a >>>> >>>> >>>> Kadir Avcı >>>> Software Developer | Freelance Web Designer >>>> web: www.kad1r.com >>>> twt: www.twitter.com/kad1r >>>> Sent from Izmir, 35, Turkey >>> >>> >>> >> >
