How did you apply them in the ORM?
Mark,
Darlington Web Design
Experts, Information, Ideas & Knowledge
ASP.NET Tips & Tricks
Mark,
Darlington Web Design
Experts, Information, Ideas & Knowledge
ASP.NET Tips & Tricks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
procs vs dynamic sql 2
- Thread starter jmeckley
- Start date
- Status
- Thread starter
- #22
1. Using NH Prof I copied the sql queries in question to QA.
2. I reviewed the exeuction plans.
3. Then I created/removed indexes and ran the query in QA.
4. I then compared execution plans. As long a cluster became an index or a scan became a seek I was happy.
I was able to reduce the duration of my integration test suite from ~3 minutes to just over 2 minutes.
I copy/pasted the index changes into a script file which I can run against production when I deploy. I also adjusted some of my queries in code and ran them through my test to ensure the queries did not break. This is all very manual, but for my first attempt it's acceptable.
Indexing is definitely an art that comes with experience.
Jason Meckley
Programmer
Specialty Bakers, Inc.
2. I reviewed the exeuction plans.
3. Then I created/removed indexes and ran the query in QA.
4. I then compared execution plans. As long a cluster became an index or a scan became a seek I was happy.
I was able to reduce the duration of my integration test suite from ~3 minutes to just over 2 minutes.
I copy/pasted the index changes into a script file which I can run against production when I deploy. I also adjusted some of my queries in code and ran them through my test to ensure the queries did not break. This is all very manual, but for my first attempt it's acceptable.
Indexing is definitely an art that comes with experience.
Jason Meckley
Programmer
Specialty Bakers, Inc.
- Status
Similar threads
- Locked
- Question