Database stuff
Two articles on database issues. One for MySQL one for MS SQL Server.
MySQL:
Optimizing Queries with Operators, Branching and Functions
Not an advanced article, just a list fo some standard MySQL functions with details for each, some samples... nice to know the functions are there.
http://www.devshed.com/c/a/MySQL/Optimizing-Queries-with-Operators-Branching-and-Functions-continued/
MS SQL Server
Replacing Cursors and While Loops
This is an old issue, problem that keeps on showing up especially on junior / trainee code. SQL Server has lots of features and functions ... and so on, but if not used properly you can end up having performance issues. One of the most effective performance-killer is inappropriate usage of cursors or while loops. Following article just gives a few examples, but look out for more like these on the internet, it really makes a difference.
Read full article here.
MySQL:
Optimizing Queries with Operators, Branching and Functions
Not an advanced article, just a list fo some standard MySQL functions with details for each, some samples... nice to know the functions are there.
http://www.devshed.com/c/a/MySQL/Optimizing-Queries-with-Operators-Branching-and-Functions-continued/
MS SQL Server
Replacing Cursors and While Loops
This is an old issue, problem that keeps on showing up especially on junior / trainee code. SQL Server has lots of features and functions ... and so on, but if not used properly you can end up having performance issues. One of the most effective performance-killer is inappropriate usage of cursors or while loops. Following article just gives a few examples, but look out for more like these on the internet, it really makes a difference.
Read full article here.
posted by Bobby at
3:42 PM
0 Comments:
Post a Comment
<< Home