<- Previous
MySQL Server and Application Performance Tuning
2001 O'Reilly Open Source Convention
Jeremy D. Zawodny, Yahoo! Inc.
Next ->
Writing Fast Queries: Don't
Don't ask for fields you don't need
(
SELECT * FROM
)
Don't ask for rows you don't need--use
LIMIT
Don't store data that you can easily compute
Don't ask for a hash of records if an array will suffice
(Perl)
Don't always assume that MySQL will sort quickly
(fixed in 4.0)
<- Previous
San Diego, California
Wednesday, July 25th 2001
http://jeremy.zawodny.com/oscon-2001/mysql/
Next ->