Store Procedure

  • Reduced network traffic and latency, boosting application performance.
  • Stored procedure execution plans can be reused, staying cached in SQL Server’s memory, reducing server overhead.
  • Client execution requests are more efficient. For example, if an application needs to INSERT a large binary value into an image data column not using a stored procedure, it must convert the binary value to a character string (which doubles its size), and send it to SQL Server. When SQL Server receives it, it then must convert the character value back to the binary format. This is a lot of wasted overhead. A stored procedure eliminates this issue as parameter values stay in the binary format all the way from the application to SQL Server, reducing overhead and boosting performance.
  • Stored procedures help promote code reuse. While this does not directly boost an application’s performance, it can boost the productivity of developers by reducing the amount of code required, along with reducing debugging time.
  • Stored procedures can encapsulate logic. You can change stored procedure code without affecting clients (assuming you keep the parameters the same and don’t remove any result sets columns). This saves developer time.
  • Stored procedures provide better security to your data. If you use stored procedures exclusively, you can remove direct SELECT, INSERT, UPDATE, and DELETE rights from the tables and force developers to use stored procedures as the method for data access. This saves DBA’s time.

Most Popular

The difference between React vs AngularJs

Image
React and AngularJs are currently using Travel and News companies. Main reason difference between AngularJs and ReactJs is AngularJS 1. AngularJs is MVC framework library. It is used for Two-way data binding. 2. AngularJs is an App development framework. ReactJS 1. React Js is a Library. It is used for One-way data binding. 2. ReactJs is an interface development framework. AngualrJs is a Javascript Framework. Where we can add HTML tags with Scrip tag. It is a Library written in Javascript. AngularJs developed by GOOGLE. AngularJs similar to Backbone or JavascriptMVC. It is a complete solution for rapid development. Following are some Features of AngularJs. 1. REST Easy: RESTful action quick communication between server to the client. 2. Extends HTML: AngularJS extends HTML with ng-directives. The ng-app directive defines an AngularJS application. The ng-model directive binds the value of HTML controls (input, select, textarea) to application data. The ng-bi...
Keep reading

How to send emails using PHPmailer and GMAIL SMTP

Image
Here I have tried how to send PHPMailer with attachement using SMTP configuration. For SMTP Configuration we here used GMAIL Auth. You can used any Auth like SMTP2GO , SendGrid . Download PHPMailer library. PHPMailer Sample Code Addd or Copy paste the following code in your editor and save with any filename with extension ".php" and try in your live server or local server. But Make sure you have to connect with internet with proper Auth details <?php require_once('phpmailer/PHPMailerAutoload.php'); $mail = new PHPMailer(); $mail->CharSet = "utf-8"; $mail->IsSMTP(); // Set mailer to use SMTP $mail->SMTPDebug = 1; // Enable verbose debug output $mail->SMTPAuth = true; // Enable SMTP authentication $mail->Username = "xxx@example.com"; //Your Auth Email ID $mail->Password = "xxxxxx"; //Your Password $mail->SMTPSecure = 'tls'; // Enable TLS encryption, `ssl` also accepted $mail->Host = "...
Keep reading

Enabling Gzip Compression of PHP, CSS, and JS Files Without mod_deflate

For enable Gzip compression using mod_deflate add following lines to your .htaccess file AddOutputFilterByType DEFLATE text/html text/plain text/xml text/css text/javascript application/javascript application/x-javascript But those who don’t allow the mod_deflate module and run PHP in CGI/FastCGI mode you can’t go with the easy method. So, to serve up your PHP, CSS, and JS files you can try the following method. Step 1: PHP Configuration Add or modify the following lines in your custom php.ini file output_handler = Off zlib.output_compression = On zlib.output_handler = ob_gzhandler Now this will take care of gzipping all PHP files. Step 2: .htaccess Configuration Add the following lines to the bottom of a .htaccess file in the root of your website. RewriteEngine On RewriteRule ^(.*\.js) gzip.php?type=js&file=$1 RewriteRule ^(.*\.css) gzip.php?type=css&file=$1 This will redirect all css and js requests files through gzip.p...
Keep reading