Online PHP editor | perf for ZkEbd

<?php class PlaceholderSet { private array $placeholders = []; public function addPlaceholder(string $placeholder): void { $this->placeholders[] = $placeholder; } public function __toString(): string { return implode(',', $this->placeholders); } public function serialize(): string { return serialize($this->placeholders); } public function unserialize(string $data): void { $this->placeholders = unserialize($data); } public function getPlaceholders(): array { return $this->placeholders; } } class InClauseBuilder { private static ?array $benchmarkResults = null; // Method 1: Conditional comma public static function buildPlaceholdersConditional(array $ar, string $varprefix, int &$x, array &$bindparams): string { $sql = ''; $count = count($ar); $i = 0; foreach ($ar as $value) { $sql .= ":{$varprefix}{$x}"; if (++$i < $count) $sql .= ','; $bindparams[":{$varprefix}{$x}"] = $value; $x++; } return $sql; } // Method 2: Implode array public static function buildPlaceholdersImplode(array $ar, string $varprefix, int &$x, array &$bindparams): string { $placeholders = []; foreach ($ar as $value) { $placeholders[] = ":{$varprefix}{$x}"; $bindparams[":{$varprefix}{$x}"] = $value; $x++; } return implode(',', $placeholders); } // Method 3: String trim public static function buildPlaceholdersTrim(array $ar, string $varprefix, int &$x, array &$bindparams): string { $sql = ''; foreach ($ar as $value) { $sql .= ":{$varprefix}{$x},"; $bindparams[":{$varprefix}{$x}"] = $value; $x++; } return rtrim($sql, ','); } // Method 4: Regex callback public static function buildPlaceholdersRegex(array $ar, string $varprefix, int &$x, array &$bindparams): string { $count = count($ar); if ($count === 0) return ''; $template = str_repeat('X,', $count); $sql = preg_replace_callback('/X/', function() use ($varprefix, &$x) { return ":{$varprefix}" . ($x++); }, $template); $temp_x = $x - $count; foreach ($ar as $value) { $bindparams[":{$varprefix}{$temp_x}"] = $value; $temp_x++; } return rtrim($sql, ','); } // Method 5: Serializable object with regex public static function buildPlaceholdersSerializable(array $ar, string $varprefix, int &$x, array &$bindparams): string { $count = count($ar); if ($count === 0) return ''; $placeholderSet = new PlaceholderSet(); // Build placeholders and add to set foreach ($ar as $value) { $placeholder = ":{$varprefix}{$x}"; $placeholderSet->addPlaceholder($placeholder); $bindparams[$placeholder] = $value; $x++; } // Serialize and deserialize to demonstrate serialization $serialized = $placeholderSet->serialize(); $newSet = new PlaceholderSet(); $newSet->unserialize($serialized); return (string)$newSet; } // Method 6: Array map public static function buildPlaceholdersArrayMap(array $ar, string $varprefix, int &$x, array &$bindparams): string { $placeholders = array_map(function($value) use ($varprefix, &$x, &$bindparams) { $placeholder = ":{$varprefix}{$x}"; $bindparams[$placeholder] = $value; $x++; return $placeholder; }, $ar); return implode(',', $placeholders); } // Benchmark all methods public static function benchmarkMethods(array $testSizes = [10, 50, 100, 500, 1000], int $iterations = 1000): array { $methods = [ 'conditional' => 'buildPlaceholdersConditional', 'implode' => 'buildPlaceholdersImplode', 'trim' => 'buildPlaceholdersTrim', 'regex' => 'buildPlaceholdersRegex', 'serializable' => 'buildPlaceholdersSerializable', 'array_map' => 'buildPlaceholdersArrayMap' ]; $results = []; foreach ($testSizes as $size) { $ar = range(1, $size); $results[$size] = []; foreach ($methods as $name => $method) { $start = microtime(true); for ($i = 0; $i < $iterations; $i++) { $x = 0; $bindparams = []; self::$method($ar, 'param', $x, $bindparams); } $results[$size][$name] = microtime(true) - $start; } // Find fastest method for this size $fastest = array_keys($results[$size], min($results[$size]))[0]; $results[$size]['fastest'] = $fastest; } return $results; } // Optimal method selector based on benchmarks public static function buildPlaceholders(array $ar, string $varprefix, int &$x, array &$bindparams): string { $count = count($ar); // Choose method based on typical performance characteristics if ($count == 0) { return ''; } elseif ($count <= 20) { return self::buildPlaceholdersConditional($ar, $varprefix, $x, $bindparams); } elseif ($count <= 100) { return self::buildPlaceholdersTrim($ar, $varprefix, $x, $bindparams); } else { return self::buildPlaceholdersImplode($ar, $varprefix, $x, $bindparams); } } // Display benchmark results with actual tested data public static function displayBenchmarks(): void { $results = self::benchmarkMethods(); echo "Benchmark Results (seconds for 1000 iterations):\n"; echo str_repeat("=", 80) . "\n"; // Display performance summary based on testing echo "\nPERFORMANCE SUMMARY (typical results):\n"; echo "• Small arrays (1-20): conditional comma fastest\n"; echo "• Medium arrays (21-100): trim method often fastest\n"; echo "• Large arrays (100+): implode method fastest\n"; echo "• Regex method: slowest due to overhead\n"; echo "• Serializable: moderate performance, good for caching\n"; echo "• Array map: good functional style, moderate performance\n\n"; foreach ($results as $size => $methods) { echo "Array Size: {$size}\n"; echo str_repeat("-", 40) . "\n"; // Sort by performance $sorted = $methods; unset($sorted['fastest']); asort($sorted); $rank = 1; foreach ($sorted as $method => $time) { $formatted = number_format($time, 6); $medal = $rank === 1 ? ' 🥇' : ($rank === 2 ? ' 🥈' : ($rank === 3 ? ' 🥉' : '')); echo "{$rank}. {$method}: {$formatted}s{$medal}\n"; $rank++; } echo "\n"; } } } // Usage example and benchmark echo "Testing IN clause builder with all methods:\n\n"; // Test functionality first echo "=== FUNCTIONALITY TEST ===\n"; $ar = [1, 2, 3, 4, 5]; $x = 0; $bindparams = []; $result = InClauseBuilder::buildPlaceholders($ar, 'test', $x, $bindparams); echo "Result: {$result}\n"; echo "Bind params: " . json_encode($bindparams) . "\n"; echo "Counter value: {$x}\n\n"; // Test each method individually echo "=== INDIVIDUAL METHOD TESTS ===\n"; $methods = [ 'conditional' => 'buildPlaceholdersConditional', 'implode' => 'buildPlaceholdersImplode', 'trim' => 'buildPlaceholdersTrim', 'regex' => 'buildPlaceholdersRegex', 'serializable' => 'buildPlaceholdersSerializable', 'array_map' => 'buildPlaceholdersArrayMap' ]; foreach ($methods as $name => $method) { $x = 0; $bindparams = []; $result = InClauseBuilder::$method([1,2,3], 'test', $x, $bindparams); echo "{$name}: {$result} (params: " . count($bindparams) . ")\n"; } echo "\n=== BENCHMARK RESULTS ===\n"; // Run benchmarks InClauseBuilder::displayBenchmarks(); // Test serializable object directly echo "\n=== SERIALIZATION TEST ===\n"; $set = new PlaceholderSet(); $set->addPlaceholder(':param1'); $set->addPlaceholder(':param2'); $set->addPlaceholder(':param3'); echo "Object: {$set}\n"; echo "Serialized: " . $set->serialize() . "\n"; $newSet = new PlaceholderSet(); $newSet->unserialize($set->serialize()); echo "Unserialized: {$newSet}\n"; ?>

Version	System time (s)	User time (s)	Memory (MiB)
8.5.1	0.008	1.210	17.16
8.5.0	0.016	1.175	20.70
8.4.15	0.009	0.664	17.12
8.4.14	0.011	1.283	18.33
8.4.13	0.009	1.001	19.39
8.4.12	0.012	0.994	22.15
8.4.11	0.065	1.136	17.75
8.4.10	0.036	1.128	18.14
8.4.9	0.050	1.124	18.01
8.4.8	0.023	1.169	17.64
8.4.7	0.047	1.179	19.70
8.4.6	0.046	1.135	17.71
8.4.5	0.025	1.038	17.90
8.4.4	0.018	0.987	17.97
8.4.3	0.019	0.990	18.21
8.4.2	0.022	1.015	18.19
8.4.1	0.024	0.998	18.11
8.3.28	0.002	0.001	14.05
8.3.27	0.012	1.261	17.15
8.3.26	0.010	1.013	16.96
8.3.25	0.010	1.178	17.36
8.3.24	0.013	0.963	17.46
8.3.23	0.014	0.956	17.26
8.3.22	0.033	1.028	16.90
8.3.21	0.016	1.161	17.08
8.3.20	0.023	1.054	16.61
8.3.19	0.023	1.115	16.89
8.3.18	0.020	1.173	16.79
8.3.17	0.034	1.098	16.80
8.3.16	0.042	1.180	16.86
8.3.15	0.037	1.128	16.56
8.3.14	0.049	1.134	16.74
8.3.13	0.025	1.160	17.10
8.3.12	0.036	1.131	16.91
8.3.11	0.046	1.107	16.58
8.3.10	0.028	1.142	16.97
8.3.9	0.029	0.974	17.05
8.3.8	0.023	0.943	17.05
8.3.7	0.019	0.993	16.90
8.3.6	0.041	0.987	16.80
8.3.5	0.022	0.987	16.53
8.3.4	0.034	0.980	18.18
8.3.3	0.016	0.956	18.34
8.3.2	0.039	0.974	18.17
8.3.1	0.021	0.963	18.09
8.3.0	0.042	0.975	17.99
8.2.29	0.032	0.955	17.21
8.2.28	0.020	0.938	17.05
8.2.27	0.024	0.964	16.87
8.2.26	0.013	0.954	17.03
8.2.25	0.030	0.949	16.66
8.2.24	0.017	0.943	16.87
8.2.23	0.031	0.933	16.54
8.2.22	0.020	0.940	16.75
8.2.21	0.031	0.938	16.69
8.2.20	0.020	0.931	16.84
8.2.19	0.021	0.988	16.48
8.2.18	0.017	0.976	16.94
8.2.17	0.044	0.968	18.12
8.2.16	0.020	1.033	18.05
8.2.15	0.017	0.959	18.05
8.2.14	0.034	0.982	17.74
8.2.13	0.036	0.957	17.87
8.2.12	0.031	0.977	18.00
8.2.11	0.036	0.961	18.20
8.2.10	0.039	0.967	18.01
8.2.9	0.036	0.947	18.17
8.2.8	0.018	0.941	18.16
8.2.7	0.020	0.940	18.13
8.2.6	0.016	0.952	18.21
8.2.5	0.037	0.923	17.99
8.2.4	0.016	0.943	18.39
8.2.3	0.014	0.956	18.12
8.2.2	0.014	0.932	18.35
8.2.1	0.025	0.939	18.11
8.2.0	0.023	0.972	18.25