sql
15 essential PHP and MySQL tutorials!
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 to [...]
Great tips to improve your MySQL performance
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!
Using TOP in MS-SQL queries
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 a certain percentage (for example [...]
RSS Reader Picks #7
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 [...]
Usefull MySQL articles and tutorials to improve your skills!
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 a technique [...]
RSS Reader Picks #5
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 article how to [...]
How to: Computed columns in SQL Server
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 expression [...]
MySQL: Performance benchmark MyISAM versus InnoDB
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: