You are here: silicon.com > Resources > White Papers > Security > Security Administration > Best Practices

Best Practices White Papers

MySQL best practice techniques for efficient data retrieval and optimal data modification

Overview This chapter excerpt from MySQL Database Design and Tuning describes how to create the best possible SQL queries for MySQL databases by focusing on two major subtopics: efficient data retrieval and optimal data modification.

The popularity of MySQL as a database system for everything from Web services to Wiki pages cannot be denied. However, every database system responds better with proper design and under-the-hood tuning. In this free chapter download from MySQL Database Design and Tuning, the author describes how to create the best possible SQL query code for MySQL databases by focusing on two major subtopics:

Efficient data retrieval, and
Optimal data modification

Title: MySQL Database Design and Tuning
Author: By Robert Schneider
Publisher: Pearson Education, Sams Publishing
Chapter 8: Optimize your MySQL database with these advanced SQL tips
ISBN: 0672327651; Published: Jun 13, 2005; Copyright 2005
Web site

Additional MySQL downloads and articles can be found using this TechRepublic tag.

Further White Paper Details
Publisher	TechRepublic	File Format	PDF
Date Published	December 2005	Downloads	72
Format	Downloads
Topics	Best Practices, Database Management

Did you find this white paper useful?

Take a holistic approach to business-driven security

Publisher:
IBM

Security: New strides in preventing intrusions.

Publisher:
IBM

Web application security: automated scanning versus manual penetration testing

Publisher:
IBM

Risk Management: Bridging Policies and Procedures - Fundamental Security Concepts

Publisher:
Global Knowledge

Tags:
security management

Does Size Matter? The security challenge of the SMB

Publisher:
McAfee

Tags:
anti-hacking

John Lamb's Week: Sorting the holiday snaps from the smut

For workers not skiving off work to look at pornography, quick retrieval of information remains a problem. For all the advances in information retrieval putting your hand on the right document or data is difficult.

Channel:
Comment & Analysis

MySQL lifts restrictive licensing terms

The rift divided MySQL and PHP, software that lets computers construct customised Web pages on the fly. The library change didn't mean that PHP and MySQL couldn't be used together, only that MySQL "was downgraded from its unique status to the level...

Leader: Database wars

The big name here is MySQL, though today another player was thrown into the ring with the news - expected for some time by this publication - that CA has spun off its database business, Ingres, which will live as a standalone open-source company.

Oracle made a move on MySQL

Oracle tried to acquire open source database maker MySQL, an indication of the profound changes the software giant is willing to make as it adapts to the increasingly significant collaborative programming philosophy.

Channel:
Open source
Tags:
mysql,
oracle

BBC online revamp embraces mobiles, podcasts and user content

The BBC should be focusing on what it's really good at: creating high-quality, non-user-generated content. Simon Grice, founder of etribes, which provides publishing tools for user-generated content, questioned the move.

Web 2.0 prompts love for open source

The effort of rewriting stored procedures, applications and queries also adds to the complexity of migration, he wrote. The study found the market is led by MySQL - bought by Sun in February for $1bn, more than the total size of the market - with...

Live Webcast: Telecoms 2.0 - Where is telecoms heading?

In this webcast, our panel of experts will review where we are with next generation telecoms in the UK, working through the concept of 'Telecoms 2.0': - Realising the potential of Next Generation Networks - why it isn't just about the technology? - What attributes should firms be looking for in their telco partner? - Is the relationship between telco provider and customer changing? - What things need to happen to make next generation services a reality? - You say you want the supplier to change. Do you want to change too? - What is Telecoms 2.0?

Publisher:
ZDNet UK

Telecom 2.0: Mind over matter

ntl:Telewest Business believes that the role of the telco is evolving. Gone are the days when it was enough to simply focus on circuits and minutes, customers now need a far higher degree of interaction and look for suppliers who will talk business solutions with them.

Publisher:
ntl:Telewest Business

IBM Information Server Change Data Capture

In today's fast-paced world, access to real-time data has never been more important. To be successful, organizations need to be able to report and analyze corporate data quickly and easily, regardless of what applications created the data, what platform they're running on, or what database they're stored in.

Publisher:
IBM

An examination of server consolidation: the trends that can drive efficiencies and help businesses gain a competitive edge

This white paper provides a starting point for organizations contemplating server consolidation. It includes an overview of server consolidation concepts and techniques and provides guidance on methodologies. It also looks at the potential cost savings associated with server consolidation and offers information on how organizations can sustain the advantage they have gained by consolidating their servers.

Publisher:
IBM

Also on silicon.com

Site Navigation:

Best Practices White Papers

MySQL best practice techniques for efficient data retrieval and optimal data modification

Quick Sitemap Links:

About Us

Search

Blogs

Verticals

Advertising Features

CNET Networks in Europe

CNET Networks in the United States

CNET Networks in Asia Pacific