<?php

	set_time_limit(120);

	$mysqli = new mysqli('127.0.0.1', 'root', '', 'eclerd_earth');

	$resultats = array();

	$queries = array();

	function test($id, $req)

	{

		global $mysqli, $resultats, $queries;

		$s = microtime(true);

		$r = $mysqli->query($req);

		$resultats[$id] = microtime(true) - $s;

		$queries[$id] = $req;

	}

	function testAll($nom, $selection)

	{

		test(

			$nom.' - WHERE - IN',

			'SELECT '.$selection

			.' FROM `cases` `case0`, `casesTest` `case1`'

			.' WHERE'

				.'`case1`.`id` IN (`case0`.`idVoisin1`, `case0`.`idVoisin2`, `case0`.`idVoisin3`, `case0`.`idVoisin4`)'

			);

		test(

			$nom.' - INNER - IN',

			'SELECT '.$selection

			.' FROM `cases` `case0`'

			.' INNER JOIN `casesTest` `case1`'

			.' ON'

				.'`case1`.`id` IN (`case0`.`idVoisin1`, `case0`.`idVoisin2`, `case0`.`idVoisin3`, `case0`.`idVoisin4`)'

		);

		test(

			$nom.' - JOIN - IN',

			'SELECT '.$selection

			.' FROM `cases` `case0`'

			.' JOIN `casesTest` `case1`'

			.' ON'

				.'`case1`.`id` IN (`case0`.`idVoisin1`, `case0`.`idVoisin2`, `case0`.`idVoisin3`, `case0`.`idVoisin4`)'

		);

		test(

			$nom.' - WHERE - EQUALS',

			'SELECT '.$selection

			.' FROM `cases` `case0`, `casesTest` `case1`'

			.' WHERE'

				.'`case1`.`id`=`case0`.`idVoisin1`'

			);

		test(

			$nom.' - INNER - EQUALS',

			'SELECT '.$selection

			.' FROM `cases` `case0`'

			.' INNER JOIN `casesTest` `case1`'

			.' ON'

				.'`case1`.`id`=`case0`.`idVoisin1`'

		);

		test(

			$nom.' - JOIN - EQUALS',

			'SELECT '.$selection

			.' FROM `cases` `case0`'

			.' JOIN `casesTest` `case1`'

			.' ON'

				.'`case1`.`id`=`case0`.`idVoisin1`'

		);

	}

	testAll('XY', '`case0`.`x`, `case0`.`y`, `case1`.`x`, `case1`.`y`');

	testAll('ID', '`case0`.`id`, `case1`.`id`');

	arsort($resultats);

	var_dump($resultats);

	var_dump($queries);

?>

• id: int(10)
  
• x: smallint(5)
  
• y: int(10)
  
• altitude: bigint(20)
  
• poisson: bigint(20)
  
• foret: bigint(20)
  
• eau: bigint(20)
  
• co2: bigint(20)
  
• chaleur: bigint(20)
  
• idVoisin1: int(10)
  
• idVoisin2: int(10)
  
• idVoisin3: int(10)
  
• idVoisin4: int(10)
  
• mer: bit(1)
  

• PRIMARY BTREE, Unique, Non compressé, (id:516960), Interclassement A, NOT NULL
  
• BTREE, Unique, Non compressé, (x:,y:516960), Interclassement A, NOT NULL
  

• Format: statique
  
• Lignes: 516 960
  
• Longueur de ligne ø: 75
  
• Taille de la ligne ø: 101 o
  
• Prochain index automatique: 516 961
  

(09-03-2014, 07:23 PM)Xenos a écrit : 'XY - JOIN - EQUALS' => float 2.5597670078278
'ID - JOIN - EQUALS' => float 1.7225079536438