…index On 5.5: mysql [localhost] {msandbox} (foo2) > explain select count(*) from test_estimate where type=6 \G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: test_estimate type…page. Then it assumes all pages…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…PHP application: > SELECT * FROM articles WHERE user_id IN(23,545,654,34) > instead of: > SELECT * FROM articles WHERE user_id IN (SELECT…EXPLAIN or optimizing your queries remember > we’re here to help. Partial agreement: “Use Indexes smartly.” Indexing…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…SELECT id FROM users WHERE featured=1) Some day this should be fixed however but do not expect it soon. Use Indexes…PHP applications use test database with reasonable amount of data in it. And do run EXPLAIN…
