Hello! I'm choosing a new framework for a modern and fast ecommerce store. There will be a lot of sql queries, so the speed is very important. For this issue I'm using: mySQL and table with 50 000 products.
With Phalcon PHQL:
Setup from INVO
first query - 0.0076 sec:
second query - 0.0031 sec:
$product = Product::findFirst(25193);
With raw mysqli:
first query - 0.00074 sec:
$mysqli = new mysqli("localhost", "root", "password", "db"); $stmt = $mysqli->query("SELECT * FROM product WHERE product_id = 25193"); $row = mysqli_fetch_assoc($stmt);
So with a lot of joins and many queries an app will be to slow. Or I'm doing something wrong?