Non functional history triggers can be disabled while executing dayend to optimize the process
17 July 2012 Amjad Hussain Optimization of Query/SP/DB, 0
During day end optimization for MBAFC we disabled history triggers on contract table to optimize day end procedure “SP_dayend_upd_od_daysâ€ÂÂ. This change reduced the 5 minutes of procedure execution time.
This post was viewed (32) times.
Cursor impact on Performance VUGen in LoadRunner
Registered Users
Categories
- Announcement (1)
- Announcements (4)
- Application Server (7)
- Apache Tomcat (2)
- EA Server (4)
- IIS 6.0 -7.5 (2)
- Jaguar Server (1)
- JBoss (1)
- Artificial Intelligence (2)
- Browsers (1)
- Buy / Sell (5)
- Chemistry (1)
- Circles (1)
- Databases (11)
- MSSQL 2000 (2)
- MSSQL 2005 (2)
- MSSQL 2008 (2)
- MySQL 4.x and 5.x (1)
- Optimization of Query/SP/DB (10)
- Oracle 10G (1)
- Oracle 11G (1)
- Oracle 9i (1)
- Domains Sales (2)
- Front End Dev. (3)
- Java (3)
- Human Capital Division (5)
- Internet (8)
- NEC – NetSol Entertainment Committee (1)
- New Launch (10)
- Parenting (1)
- Philosophy (2)
- Physics (4)
- Platforms (1)
- Ubuntu / Linux (1)
- Quality Management System (1)
- Restaurants (2)
- Search Engine (1)
- Social Media (4)
- SQA (11)
- Audits (1)
- LoadRunner (9)
- Neo Load (1)
- QTP – QuickTest Professional (1)
- Test Automation (Concepts) (1)
- Testing Techniquies / Approaches (1)
- WCF Storm (2)
- winRunner (1)
- Technology (1)
- Test (1)
- Theology (1)
- Travelling the Globe (3)
- Travel China (1)
- Travel Malaysia (1)
- Travel Pakistan (1)
- Uncategorized (28)
- Weekend Read (11)
- Whitebox Testing (1)
Archives
- December 2022 (1)
- March 2020 (1)
- December 2017 (1)
- March 2015 (1)
- October 2014 (1)
- March 2014 (1)
- December 2012 (16)
- October 2012 (16)
- September 2012 (12)
- August 2012 (8)
- July 2012 (13)
- June 2012 (4)
- May 2012 (3)
- April 2012 (3)
- September 2011 (2)
- November 2009 (1)
- October 2009 (1)
- January 2009 (1)
- June 2008 (1)
- December 2007 (2)
- June 2007 (1)
- December 2006 (1)
- November 2006 (1)
- October 2006 (1)
- August 2006 (1)
- June 2006 (1)
- May 2006 (1)
- April 2006 (1)
- March 2006 (3)
- February 2006 (1)
- January 2006 (5)
- December 2005 (1)
- November 2005 (1)
- October 2005 (3)
- August 2005 (1)
- June 2005 (4)
- May 2005 (6)
- March 2005 (1)
Categories
Announcements
Apache Tomcat
Application Server
Audits
Buy / Sell
By External Speakers
Circles
Databases
Domains Sales
EA Server
Front End Dev.
IIS 6.0 -7.5
Internet
Java
LoadRunner
Mc Cabe
MSSQL 2000
MSSQL 2005
MSSQL 2008
MySQL 4.x and 5.x
NEC - NetSol Entertainment Committee
Neo Load
New Launch
Optimization of Query/SP/DB
Oracle 11G
Physics
QTP - QuickTest Professional
Restaurants
Search Engine
Social Media
Soft Skills for Tech Gurus
SQA
Test
Test Automation (Concepts)
Testing Techniquies / Approaches
Theology
Travel China
Travelling the Globe
Travel Malaysia
Uncategorized
WCF Storm
Weekend Read
Whitebox Testing
winRunner
Work, Life and Personal Finances