This tip helps to increase performance of your Linux system by reducing swappiness. If you have performance issue in your Linux based system, then here is the answer for that. (I tried it on Ubuntu and fedora Linux distro, And its working well on both). You can check the swappiness using : >_cat /proc/sys/vm/swappiness By […]

Need a Dynamic Table inside Stored Procedure? We have two options:             a.Temporary Tables             b.Table Variable Which one is better to use? Which one can provide better performance? Lets have a look at both of them by the means of comparison: One: Transaction Logs are not recorded for Table Variables. This simply means, transaction or rollback […]

 To acess data from a Data Reader, we mostly use the column / field name to retrieve data from a field .   And we use field name instead of index atlest for the following two reasons :- 1. using field name instead of index makes the code more readable 2. if the column order changes […]

While working in a project around a year back, I was facing trouble while downloading data from a SQL server to sqlite database. The SQL server DB contained  millions of records (CAd/CAM refernece data) in some table that I needed to download to the SQLite DB.In fact the records were inserted to the SQL server […]

If the response time of your website is high, i.e if it is taking more time to display the content then the user might lose the interest in using the website. So it is important the response should be as fast as possible. Compression is one of the methods in which we can reduce the […]

Monitor how much time the server is taking to process a request and to give a response. Sometimes we need to monitor the performance of our web application, like how much time the server is taking to process a page. To find out the time a particular request is taking to get processed we can […]

Lets say we have more than two solutions for a complex workflow or a workflow that includes I/O operations.And we want to find out the one that takes minimum execution time.The following simple time functions may help us in making a decision. C++ :  clock_t  clock(void) ,  CLOCKS_PER_SEC This function returns number of clock ticks elapsed between the […]

What is prefetch? This is very interesting thing in html for sites performance. As name says: suppose you are viewing “abc.html” and as a developer I know there are a high probably that after this  page you will visit “xyz.html”, my trick will be here is to prefetch “xyz.html” while you are viewing “abc.html”. How […]