Why PDO is the standard in PHP - Performance Analysis

Time Complexity: Why PDO is the standard

O(n)

Understanding Time Complexity

When using PHP to work with databases, the way we connect and run queries affects how fast our code runs as data grows.

We want to understand how using PDO (PHP Data Objects) impacts the time it takes to execute database operations.

Scenario Under Consideration

Analyze the time complexity of this PDO code snippet.

// Connect to database using PDO
$pdo = new PDO('mysql:host=localhost;dbname=testdb', 'user', 'pass');

// Prepare a query
$stmt = $pdo->prepare('SELECT * FROM users WHERE age > :age');

// Execute query with parameter
$stmt->execute(['age' => 18]);

// Fetch all results
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);

This code connects to a database, prepares a query with a condition, runs it, and fetches all matching rows.

Identify Repeating Operations

Look at what repeats or takes time in this process.

• Primary operation: Fetching all rows from the database after query execution.
• How many times: Once per row returned, the fetchAll method processes each row internally.

How Execution Grows With Input

As the number of rows matching the query grows, the time to fetch all results grows too.

Input Size (n)	Approx. Operations
10	Processes about 10 rows
100	Processes about 100 rows
1000	Processes about 1000 rows

Pattern observation: The time to fetch results grows roughly in direct proportion to the number of rows returned.

Final Time Complexity

Time Complexity: O(n)

This means the time to fetch results grows linearly with the number of rows returned by the query.

Common Mistake

[X] Wrong: "Using PDO makes queries run instantly no matter how much data there is."

[OK] Correct: PDO helps organize and secure queries, but fetching more data still takes more time because each row must be processed.

Interview Connect

Understanding how PDO handles data fetching helps you explain how your code scales with data size, a key skill in real projects and interviews.

Self-Check

"What if we used fetch() inside a loop instead of fetchAll()? How would the time complexity change?"