Tag Archive for MySQL

MySQL vs MS SQL Server

January 6, 2010 News, Uncategorized No comments

MySQL.png

Comparing the open source MySQL database server against the proprietary database server “MS SQL Server” fromMicrosoft.

Performance Comparison

The Transaction Processing Performance Council is an independent organization that specifies the typical transactions (transactions used in inventory control systems, airline reservation systems and banking systems) and some general rules these transactions should satisfy. The TPC produces benchmarks that measure transaction processing and database performance in terms of how many transactions a given system and database can perform per unit of time, e.g., transactions per second or transactions per minute.

As of June 2006, SQL Server 2000 holds the third position in the OLTP Test in price by performance results and MicrosoftSQL Server 2005×64 holds the first place. However MySQL does not participate in these tests, so it is difficult to make a head on comparison using TPC benchmarks. Read more

Google Auto Sitemap Generator Script for PHP and MySQL

December 26, 2009 Uncategorized One comment

Google Auto Sitemap Generator Script for PHP and MySQL

AutoSitemap is an easy way to generate a Google Sitemap XML document for your website, forum or blog that can map unlinked or database generated pages not reachable by the crawler method. Simply install the script, add the tracking image so that it is displayed on every page of your website and then register your sitemap URL with Google. It works by capturing the HTTP referer when serving the tracking image.

Features :

XML sitemap for Google and URL list text file
output for other search engines
Map unlinked or database generated pages that crawlers miss out!

Read more

Joey Rivera: Caching using PHP/Zend_Cache and MySQL

November 11, 2009 Uncategorized No comments

I like the definition used in Wikipedia: “a cache is a temporary storage area where often accessed data can be stored for quick access”. The idea is to get ‘often accessed data’ from a database and store it in memory (RAM or as a file in your local file system). This is because:

it’s quicker for a machine to read from memory than to connect to a database and query data.
it’s more efficient for the database to not waste time and resources returning the same dataset multiple times when it could be focusing on other tasks. Read more