Database operations often tend to be the main bottleneck for most web applications today. It's not only the DBA's (database administrators) that have to worry about these performance issues. We as programmers need to do our part by structuring tables properly, writing optimized queries and better code. Here are some MySQL optimization techniques for programmers.
This is a list of handy MySQL commands that I use time and time again. At the bottom are statements, clauses, and functions you can use in MySQL. Below that are PHP and Perl API functions you can use to interface with MySQL. To use those you will need to build PHP with MySQL functionality. To use MySQL with Perl you will need to use the Perl modules DBI and DBD::mysql.
Submitted by Anonymous (not verified) on Mon, 2007-05-07 11:21
Search across the documentation libraries for several different products and releases. You can see how popular your search term is in each library, and choose which product and release to explore further.
Submitted by Anonymous (not verified) on Wed, 2007-01-31 01:31
Covers all of the major enterprise relational database systems: DB2, Informix, Oracle, and SQL Server, as well as articles, tips, and how-tos on many other database systems such as Access, Visual FoxPro, and MySQL.
Submitted by Anonymous (not verified) on Wed, 2007-01-31 00:05
The DatabaseJournal newsletter provides you with a round up of the content which is delivered each day to the DatabaseJournal web site. DatabaseJournal is a database-focused Web site that embraces the entire database sector, with in-depth coverage of Microsoft SQL Server, Oracle Database, IBM DB2, Sybase, MySQL, and more.
Submitted by Anonymous (not verified) on Tue, 2006-12-05 12:27
Developers.net gives you a one-stop resource for wireless computing and mobile networking tutorials, white papers, downloads, and more. Learn about wireless security, standards, specifications, application development, service deployment--a wealth of tips and howtos you can put to use today.