Showing Google Maps with many markers in PHP Sometimes you need to display Google Maps with a large number of markers. However, adding too many markers makes the map page load too slow. This article explains how you can use marker cluster feature of the forms map location plug-in to cluster large numbers of markers [...]
Some great articles on how to improve the performance of your MySQL Server: Optimize slow queries with mk-query-digest Use delayed flushing table_cache negative scalability How innodb_open_files affect performance Use of table_cache Thanks to MySQLPerformanceblog.com!
After I explained the MySQL method for getting the TOP N rows in a query it is time to explain the same for MS-SQL. Here we use the TOP function. To retrieve the first 5 rows from the names table, use the following query: SELECT TOP 5 firstname,lastname FROM names If you want to retrieve [...]
Just some links MySQLi Resultset Iterator Twitter Business Model Revealed? Is Twitter the next huge e-commerce site? According to a story in The New York Times, it could be. The report puts a few pieces of information together to conclude that Twitter could “couple e-commerce with advice from other shoppers, an element that most search [...]
As promised in my previous post with usefull PHP articles and tutorials, now it’s time for some cool and handy SQL articles! Here we go: Execute SQL job through batch file This article will show you how you can execute a SQL job with one click, allowing anyone to do this. Author Divya Agrawal shows [...]
This time all dedicated to SQL Adjusting Innodb for Memory resident workload – Great article on how to finetune InnoDB! MySQL and IBM MySQL Connector/OpenOffice.org: Alpha 2 is ready for testing! – Great development! Recover from No-Route to Host or Storage Engine Plugin Crashes – Be sure to read this! SQL Unit Testing – Nice [...]
Last week I was playing around with the computed columns feature in SQL Server from Microsoft. A computed column is computed from an expression that can use other columns in the same table. The expression can be a noncomputed column name, constant, function, and any combination of these connected by one or more operators. The [...]
Because I’m running a project which has a relative large database (tables with 70.000.000 records in them), I wanted to know which was faster in performance, MyISAM or InnoDB. Currently I’m using MyISAM, and I’m running into some performance and stability issues. First, I’ve created a table with a few columns: