Tagged: MySQL


Optimizing MySQL: Queries and Indexes

The database is just too slow. Queries are queuing up, backlogs growing, users being refused connection. Management is ready to spend millions on “upgrading” to some other system, when the problem is really that MySQL is simply not being used properly. Badly defined or non-existent indexes are one of the primary reasons for poor performance, […]


Top 15 Best WordPress Plugins to Use in 2011

There are lots of reasons to use wordpress in these days, wordpress have thousands of good plugins available in market which accomplish your websites all needs. Here is the Top 15 Best WordPress Plugins to Use in 2011. W3 Total Cache – This WordPress plugin is great for two reasons. First, it makes your pages […]

Export Data to CSV Using PHP

It is many time we need to export table data to CSV in our most of applications. There is a simple code to export data to CSV using PHP Code: if($_GET[‘action’] == ‘export’) { $titlearr = array(“Heading 1″,”Heading 2″,”Heading 3″,”Heading 3″,”Heading 4″); $q = mysql_query(“select field1, field2, field3. field4 from where table”); $columns = count($titlearr); […]

Best Google Ads Placement for Classified Sites

Classified Sites are generally those which have the most content generated by users. In most cases the users are trying to sell their services or products to local audience, hence we need to focus on all the different aspects of the website. Users would visit the Homepage followed by the Search Results pages when they […]

jQuery Advantages and Disadvantages

What is jQuery? jQuery is basically a JavaScript library and it was designed to make the client-side scripting of HTML more simple. The person responsible for its birth is John Resig at BarCamp NYC in 2006. It is an open-source software and dual-licensed by MIT License and the GNU General Public License. Version 2. jQuery […]

Make Windows Run More Smoothly

Whether you have a humble netbook or a powerful custom PC, you will almost invariably be, at some point, wasting precious system resources on the unnecessary. Resources and power which should be diverted to the task at hand are often clogged by forces unseen, and can negatively impact your browsing, work, or anything else. These […]