Offshore Software Outsourcing Company, offshore IT outsourcing services, offshore software development Russia

Home / Technical Support / MySQL

Key Offerings:

B2B and B2C E-Business Solutions

Offshore Software Development Outsourcing

Strategic Consulting

Offshore Software Outsourcing

About ALTOROS: ALTOROS Systems is headquartered in Tampa, Florida and maintains an office near Boston, Massachusetts and technology development center in Belarus and Russia. ALTOROS specializes on providing value-added e-commerce and web-based software development and offshore software outsourcing services to emerging enterprises helping them successfully plan and implement business initiatives.

Node: Optimising Database Structure, Next: Optimising the Server, Prev: Locking Issues, Up: MySQL Optimisation

Optimising Database Structure

Design Design Choices

Data size Get Your Data as Small as Possible

MySQL indexes How MySQL Uses Indexes

Indexes Column Indexes

Multiple-column indexes Multiple-Column Indexes

Open tables Why So Many Open tables?

Table cache How MySQL Opens and Closes Tables

Creating many tables Drawbacks to Creating Large Numbers of Tables in the Same Database