Performance Tuning[Thanx Mr.Omny]

Results 1 to 2 of 2

Thread: Performance Tuning[Thanx Mr.Omny]

  1. #1
    Join Date
    Dec 1969

    Default Performance Tuning[Thanx Mr.Omny]

    Q1.Do you have it compiled in dubug mode?<BR>A1.Yes we are still In debug Mode, later we would chage<BR>Q2.What type of db are you using?<BR>A2.Im using MS sql 2000<BR>Q3.What type of db connectors are you using?<BR>A3.we are using OLEDB connection.<BR>Q4.Are you using complex nested SQL statements?<BR>A4.Yes In some places<BR>Q5.Are you using views or stored procs?<BR>A5.Im using Stored Procs<BR>Q6.What machine are you running it on?<BR>A6.Windows 2000 Server.<BR>Q7.Are there any heavy graphics that have to load?<BR>A8.Well No really but we have DHTML Menu, which Loads in the Page.. ie As include file.(SIze 180KB).<BR>Q9.How large are the resulting html pages that are rendered?<BR>A9.may be (157,324,200 KB&#039;s etc..)THis File Size is Excluding the Menu (.Js file[180kb])<BR><BR>Thanx a lot for the Response Mr.Omny

  2. #2
    Join Date
    Dec 1969

    Default RE: Performance Tuning[Thanx Mr.Omny]

    Vishalrai,<BR><BR>A couple of suggestions:<BR><BR>1. Running in Release mode might make a huge difference. When you compile in debug mode there are lots of debug symbols that get lumped in with your dll, and of course your app is now aware of it and looking for debug logic and breaks. In your web.config change debug="false" and recompile in release mode to test. You can always switch it back.<BR><BR>2. I don&#039;t know much about the performance of the OLEDB Connectors in .net. I have been using the SQLClient connectors because of its optimization for use with SQL 2k. I have been getting great results with 1000&#039;s of results.<BR><BR>4. Nested SQL statements have caused bottlenecks for me in the past. Try converting those to views if you can. I have seen serious execution time decreases when converting to views.<BR><BR>5. Good. Stored Procs good :).<BR><BR>6. Good.<BR><BR>7 & 8. I think your downloaded filesize is quite large. 180 k for js for a menu system is pretty darn big, especially when used in conjunction with a 150k + html generated file that contains your data.<BR><BR><BR>I hope this helps :)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts