Currently browsing

December 21, 2012

Run any Stored Procedure from Net version 2

Run any Stored Procedure from .Net – version 2 Please change In my last article I found some limitation and this code also quite large so I’ve write it’s modified code to run stored procedure. It’s more powerful and comparatively very low code and use is also very easy. When …

Transaction Log and VLF

Transaction Log and VLF Introductions Transaction log is used for data recovery purpose of the database. A proper understanding of transaction log is very important to managing the transaction log. Point in focus In this article I am trying focus on the points are mentioned bellow. 1.    The Physical architecture …

MySQLi prepared statements

MySQLi prepared statements pre { background-color:#444; white-space:pre-wrap; font-size:85%; padding:0px 6px; } Lessons learned: Prepared statements are 13 percent faster than normal statements with escaping Prepared statements are 8 percent faster than normal statements without escaping To get improvements, you need at least 10000 inserts for 1 statement Using insert…set is …