mirror of
https://github.com/php/presentations.git
synced 2026-04-28 17:53:13 +02:00
Ilia Alshanetsky
9 lines
305 B
PHP
9 lines
305 B
PHP
<?php
|
|
// slow joinless approach
|
|
$a = sqlite_fetch_single($db, "SELECT id FROM foo WHERE name='ilia'");
|
|
$b = sqlite_array_query($db, "SELECT * FROM bar WHERE id={$a}");
|
|
|
|
// Fast Join implementation
|
|
$b = sqlite_array_query($db,
|
|
"SELECT b.* FROM foo f INNER JOIN bar b ON f.id=b.id WHERE f.name='ilia'");
|
|
?>
|