Typical problems of optimizing SQL queries for creating medium and large sites/web applications

Andrzej Barczak, Dariusz Zacharczuk

Abstract


Article presents answers to common questions, which have webmasters, programmers when writing SQL queries. How to join tables? Which database engine is better to choose? If and when the better solution is to perform several smaller queries and when complex one? These and other dilemmas will be discussed and provided with concrete examples.

Keywords


SQL; MySQL; optimization; performance

Full Text:

PDF (Polski)

References


Pachev S.: MySQL. Mechanizmy wewnętrzne bazy danych. Helion, Gliwice 2008.

Henderson C.: Skalowalne witryny internetowe. Helion, Gliwice 2007.

Schwartz B., Zaitsev P., Tkochenko V., Zawodny J. D., Lentz A., Balling D. J.: Wysoko wydajne MYSQL. Optymalizacja, archiwizacja, replikacja. Wydanie II, Helion, Gliwice 2009.

Harrington J. L.: SQL dla każdego. Wydanie II, Mikom, Warszawa 2000.




DOI: http://dx.doi.org/10.21936/si2012_v33.n2B.197