When pulling data from a secondary database, is PDO preferred over xPDO or vice versa?
I am just comparing like for like for my own needs, doing a complex sql query gives me following results. They all seem pretty close tbh.
Native PHP
$result = mysql_query($sql);
Uncached: MySQL: 0.1573 s, 677 request(s), PHP: 3.0849 ss, total: 3.2422 ss, document retrieved from database.-->
Cached : MySQL: 0.1963 s, 676 request(s), PHP: 1.5260 ss, total: 1.7223 ss, document retrieved from cache.-->
PDO
$result = $modx->query($sql);
Uncached: MySQL: 0.1854 s, 678 request(s), PHP: 2.9924 ss, total: 3.1778 ss, document retrieved from database.-->
Cached : MySQL: 0.1674 s, 677 request(s), PHP: 1.3563 ss, total: 1.5237 ss, document retrieved from cache.-->
xPDO
$result = $xpdo->query($sql);
Uncached: MySQL: 0.1658 s, 677 request(s), PHP: 2.7665 ss, total: 2.9323 ss, document retrieved from database.-->
Cached : MySQL: 0.1854 s, 676 request(s), PHP: 1.4833 ss, total: 1.6687 ss, document retrieved from cache.-->
