Community @ The Turning Gate

Hi Mike, I've emailed you a PHP test file for measuring the performance of a single SQLite query that does not use any Backlight code.

For anybody else interested, the contents of the file is:

<?php
	$start = microtime(true);

	$pdo = new PDO('sqlite:backlight/data/publisher/master.sq3');

	if (isset($_REQUEST['pragma'])) {
		$res = $pdo->query('PRAGMA synchronous = off');
		$pdo->query('PRAGMA journal_mode = PERSIST');
	}

	$queryStart = microtime(true);
	$pdoStatement = $pdo->prepare('select * from album');
	$pdoStatement->execute();
	$results = $pdoStatement->fetchAll(PDO::FETCH_ASSOC);

	$count = count($results);
	$end = microtime(true);
	$queryTime = ($end - $queryStart) * 1000;
	$totalTime = ($end - $start) * 1000;

	echo 'Found '.$count.' albums in '.number_format($queryTime, 3).' milliseconds<br/>';
	echo 'Total time taken: '.number_format($totalTime, 3).' milliseconds';
?>

If uploaded as a file http://yoursite.com/sqlite_performance.php, the time taken to run a query is reported.  A URL such as  http://yoursite.com/sqlite_performance.php?pragma tests with the variables that we have found to improve performance on hosts using network storage.  The results for my own site, with 30 albums is less than 2 milliseconds, whether pragma is set or not.

Hi Daniel,

thank you very much but unfortunately your css doesn't work for me, the whole album frame gets black and the color of the album description is not changing.

Best regards,
Oliver

I already tried it. It adds the script to the end of the head section. But even though I used $(document).ready(function() {
the script doesn't appear to work.

Are you using wp_enqueue_script() via a child theme?

Thank you so much. Great site you made by the way!

Sorry, I did not put in test.vuedailleurs.com, but http://phoneographie.com

Philippe