Posts tagged #index

OpiniDatabase sharding is the process of splitting up a database across multiple machines to improve the scalability of an application. The justification for database sharding is that after a certain scale point it is cheaper and more feasible to scale a site horizontally by adding more machines than to grow it vertically by adding beefier servers.

Excellent advanced info on crating dB indexes, looking at query plans to understand performance.

A great analysis about a question that I had not thought of but is pretty interesting now that you mention it!