Comparing the open source MySQL database server against the proprietary database server “MS SQL Server” fromMicrosoft.
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
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.
XML sitemap for Google and URL list text file
output for other search engines
Map unlinked or database generated pages that crawlers miss out!
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