/**
* @access public
*/
protected function runTest()
{
$timer = new Benchmark_Timer();
$timer->start();
parent::runTest();
$timer->stop();
if ($this->fMaxRunningTime != 0 && $timer->timeElapsed() > $this->fMaxRunningTime) {
PHPUnit_Framework_Assert::fail(sprintf('expected running time: <= %s but was: %s', $this->fMaxRunningTime, $timer->timeElapsed()));
}
}
/**
* Runs a test suite.
*
* @param PHPUnit_Framework_Test $suite
* @param optional boolean $wait
* @return PHPUnit_Framework_TestResult
* @access public
*/
public function doRun(PHPUnit_Framework_Test $suite, $wait = false)
{
printf("PHPUnit %s by Sebastian Bergmann.\n\n", PHPUnit_Framework_Version);
$result = new PHPUnit_Framework_TestResult();
$result->addListener($this->fPrinter);
$timer = new Benchmark_Timer();
$timer->start();
$suite->run($result);
$timer->stop();
$this->pause($wait);
$this->fPrinter->printResult($result, $timer->timeElapsed());
return $result;
}
/**
* Cleanly end the current test
*/
protected function endCurrentTest()
{
if (!$this->currentTest || !$this->currentSuite) {
return;
}
// Time the current test
$testDuration = microtime(true) - $this->startTestTime;
$this->testSpeeds[$this->currentSuite['suite']->getName() . '.' . $this->currentTest['name']] = $testDuration;
if ($this->hasTimer) {
$this->timer->stop();
$this->currentTest['timeElapsed'] = $this->timer->timeElapsed();
}
// Save and reset current state
array_push($this->currentSuite['tests'], $this->currentTest);
$this->currentTest = null;
}
<?php
//testA
require_once "Benchmark/Timer.php";
require_once "./sampleData.php";
$timer = new Benchmark_Timer();
$timer->start();
//$r = array_search("kFJeaj08OKSMc7jD", $array);
//var_dump($array[$r]);
$_flip = array_flip($array);
$timer->setMarker('function END');
var_dump($_flip["kFJeaj08OKSMc7jD"]);
$timer->stop();
$timer->display();
error_reporting(E_ALL);
$conf_path = realpath(dirname(__FILE__) . '/../projects/bookstore/build/conf/bookstore-conf.php');
if (!file_exists($conf_path)) {
print "Make sure that you specify properties in conf/bookstore.properties and " . "build propel before running this script.\n";
exit;
}
// Add PHP_CLASSPATH, if set
if (getenv("PHP_CLASSPATH")) {
set_include_path(getenv("PHP_CLASSPATH") . PATH_SEPARATOR . get_include_path());
}
// Add build/classes/ and classes/ to path
set_include_path(realpath(dirname(__FILE__) . '/../projects/bookstore/build/classes') . PATH_SEPARATOR . dirname(__FILE__) . '/../../runtime/classes' . PATH_SEPARATOR . get_include_path());
// Require classes.
require 'propel/Propel.php';
include_once 'Benchmark/Timer.php';
$timer = new Benchmark_Timer();
$timer->start();
// Some utility functions
function boolTest($cond)
{
if ($cond) {
return "[OK]\n";
} else {
return "[FAILED]\n";
}
}
try {
// Initialize Propel
Propel::init($conf_path);
} catch (Exception $e) {
die("Error initializing propel: " . $e->__toString());
print "You must provide connection information to a database in order to test\n";
print "driver classes. The database should be temporary or disposable. The \n";
print "unit tests will create and drop tables within the specified database.\n";
print "\nYou can also specify this on the commmandline:\n";
print "\t\$> php -f run-tests.php mysql://root@localhost/mytempdb\n";
print "\nPlease enter the DSN URL (e.g. sqlite://localhost/:memory:)\n";
print "DSN: ";
$dsn = trim(fgets(STDIN));
} else {
$dsn = $argv[1];
}
$testSuite = new PHPUnit2_Framework_TestSuite($dsn);
// ----------------------------------------------------------------------------
// TESTS ----------------------------------------------------------------------
// ----------------------------------------------------------------------------
$timer = new Benchmark_Timer();
$timer->start();
// (1) Add Generic (non-Driver) Tests
// ----------------------------------
require_once 'creole/CreoleTest.php';
$testSuite->addTestSuite(new ReflectionClass('CreoleTest'));
require_once 'creole/util/sql/SQLStatementExtractorTest.php';
$testSuite->addTestSuite(new ReflectionClass('SQLStatementExtractorTest'));
// (2) Driver Tests
// ----------------
include_once 'creole/drivers/DriverTestManager.php';
print "--------------------------------------\n";
print "| Running driver tests |\n";
print "--------------------------------------\n";
$timer->setMarker("start driver tests");
print "DSN: " . $dsn . "\n\n";
*
* @category Main
* @package Loris
* @author Loris Team <*****@*****.**>
* @license http://www.gnu.org/licenses/gpl-3.0.txt GPLv3
* @link https://www.github.com/aces/Loris/
*/
set_include_path(get_include_path() . ":../project/libraries:../php/libraries:");
require_once __DIR__ . "/../vendor/autoload.php";
ini_set('default_charset', 'utf-8');
ob_start('ob_gzhandler');
// Create an output buffer to capture console output, separately from the
// gzip handler.
ob_start();
// start benchmarking
$timer = new Benchmark_Timer();
$timer->start();
// load the client
$client = new NDB_Client();
$client->initialize();
// require additional libraries
$TestName = isset($_REQUEST['test_name']) ? $_REQUEST['test_name'] : 'dashboard';
$subtest = isset($_REQUEST['subtest']) ? $_REQUEST['subtest'] : '';
// make local instances of objects
$config =& NDB_Config::singleton();
$timer->setMarker('Loaded client');
//--------------------------------------------------
/**
* Extracts a parameter from request in a safe way,
* and sets the $tpl_data to said request. If request does
* not contain parameter, will set the smarty variable to
h1{ color: red; rotation: 77 }
}
h1{ color\$: red; rotation: 77 }
h1{ foo:; bar; baz: fuschia; }
h1{ color: red; rotation: 77\$\$ }
p { color:green; color{;color:maroon} color:blue; color:yellow; border:none }
p{color:red}
p{ foo:bar; bar:calc(2 + 5 * (3-6)); baz:boo }
*/
/* Discards the rule til end of stylesheet, since no matching bracket can be found */
/*p{ foo:bar; foo{;bar("baz)};"; baz:boo }
h1{}*/
EOS;
$timer = new Benchmark_Timer();
//$nb_iterations = 1;
$timer->start();
$source = new Source\String($css);
$timer->setMarker(sprintf("Source init: %s", $source->getEncoding()));
$lexer = new Css\Lexer();
$lexer->setSource($source);
$timer->setMarker("Lexer init");
//$token = $lexer->nextToken();
//while ($token->type !== Css\Lexer::T_EOF) {
//echo $lexer->getLiteral($token) . PHP_EOL;
//$token = $lexer->nextToken();
//}
//echo $lexer->getLiteral($token) . PHP_EOL;
//$timer->setMarker("Tokenization end");
$parser = new Css\Parser($lexer);
//
// +----------------------------------------------------------------------+
// | MoleCMS |
// +----------------------------------------------------------------------+
// | Copyright (c) 2000-2002 MoleManMedia Tim Franz |
// +----------------------------------------------------------------------+
// | Authors: Tim Franz <*****@*****.**> |
// +----------------------------------------------------------------------+
//
// $Id: index.php,v 1.2 2002/09/03 16:06:58 moleman Exp $
//error_reporting(E_ALL & ~E_NOTICE);
//error_reporting(E_ALL);
define("BENCHMARK", false);
if (BENCHMARK) {
include_once 'Benchmark/Timer.php';
$timer = new Benchmark_Timer();
$timer->start();
}
/*
* Output Compression;
*/
//ob_start("ob_gzhandler");
define("CACHE", false);
define("DEBUG", false);
define("BANNER_ADS", false);
define('GERMAN', 1);
define('ENGLISH', 2);
define('TRUE', 1);
define('FALSE', 0);
define('FORM_FILE_DIR', '../include/pear/');
require_once 'Cache/OutputCompression.php';
<?php
require_once 'Benchmark/Timer.php';
$timer = new Benchmark_Timer();
$timer->start();
$id = 9919;
$conn = pg_connect("user=juno dbname=sandbox");
$result = pg_query($conn, "SELECT * FROM people WHERE id = " . $id);
$person = pg_fetch_array($result);
$timer->setMarker('fetched');
pg_close($conn);
print_r($person);
$timer->stop();
$timer->display();
<?php
##goparallel runs multiple S3QL queries simulatenously using curl library.
#Part of S3DB (http://s3db.org)
#Helena Deus (helenadeus@gmail.com), 2009-08-10
if (is_file('../pearlib/PEAR.php')) {
require_once '../pearlib/PEAR.php';
require_once '../pearlib/Benchmark/Timer.php';
$timer = new Benchmark_Timer();
$timer->start();
}
$S3QL = array('http://ibl.mdanderson.org/edu/S3QL.php?key=xxxxx&query=<S3QL><from>items</from><where><collection_id>26969</collection_id></where></S3QL>', 'http://ibl.mdanderson.org/edu/S3QL.php?key=xxxxx&query=<S3QL><from>items</from><where><collection_id>26971</collection_id></where></S3QL>', 'http://ibl.mdanderson.org/edu/S3QL.php?key=xxxxx&query=<S3QL><from>items</from><where><collection_id>26973</collection_id></where></S3QL>', 'http://ibl.mdanderson.org/edu/S3QL.php?key=xxxxx&query=<S3QL><from>items</from><where><collection_id>26975</collection_id></where></S3QL>');
$results = goparallel($S3QL, 1);
echo "Your queries results:<BR>";
echo '<pre>';
print_r($results);
$timer->display();
function goparallel($S3QL, $goparallel = true)
{
global $timer;
if (extension_loaded('curl') && $goparallel) {
// Create cURL handlers
if ($timer) {
$timer->setMarker('Starting queries from group ' . $it);
}
foreach ($S3QL as $k => $url) {
$qURL = $url . '&format=php';
$ch[$k] = curl_init();
// Set options
curl_setopt($ch[$k], CURLOPT_URL, $qURL);
curl_setopt($ch[$k], CURLOPT_RETURNTRANSFER, 1);
/**
* @param PHPUnit2_Framework_Test $suite
* @param boolean $wait
* @return PHPUnit2_Framework_TestResult
* @access public
*/
public function doRun(PHPUnit2_Framework_Test $suite, $wait = false)
{
$result = $this->createTestResult();
if ($this->printer === null) {
$this->printer = new PHPUnit2_TextUI_ResultPrinter();
}
$this->printer->write(PHPUnit2_Runner_Version::getVersionString() . "\n\n");
$result->addListener($this->printer);
if (class_exists('Benchmark_Timer')) {
$timer = new Benchmark_Timer();
}
if (isset($timer)) {
$timer->start();
}
$suite->run($result);
if (isset($timer)) {
$timer->stop();
$timeElapsed = $timer->timeElapsed();
} else {
$timeElapsed = false;
}
$this->pause($wait);
$this->printer->printResult($result, $timeElapsed);
return $result;
}
<?php
require_once 'Benchmark/Timer.php';
$timer = new Benchmark_Timer(true);
$timer->start();
// some setup code here
$timer->setMarker('setup');
// some more code executed here
$timer->setMarker('middle');
// even yet still more code here
$timer->setmarker('done');
// and a last bit of code here
$timer->stop();
$timer->display();
function viewUpload()
{
$form = new SessionUploadForm();
$view = Core_View::factory('sessionsfileupload');
$view->UploadStatusMsg = "";
$view->UploadStatus = "Error";
if ($form->validate()) {
$timer = new Benchmark_Timer();
$timer->start();
$upload = $form->getSubmitValue('upload');
$timer->setMarker('Decode Sessions - Start');
exec('/usr/local/bin/fitdecode -s ' . $upload['tmp_name'], $xml_session);
$xml_session = implode("\n", $xml_session);
$sessions = parseSessions($xml_session);
$timer->setMarker('Decode Sessions - End');
/* There should only be one session */
if (is_array($sessions)) {
$session = $sessions[0];
unset($sessions);
}
$db = Zend_Registry::get('db');
$db->beginTransaction();
try {
$api = new Module_Sessions_API();
/* Insert the session data into the database */
$api->createSessionFull($session->start_time, 'E1', 'Untitled', $session->total_timer_time, $session->total_distance, $session->total_calories, $session->avg_heart_rate, $session->max_heart_rate, $session->avg_speed, $session->max_speed, $session->total_ascent, $session->total_descent, '');
/* Find the seconds since epoch so we can do simple maths */
$ftime = strptime($session->start_time, '%FT%T%z');
$session_epoch = mktime($ftime['tm_hour'], $ftime['tm_min'], $ftime['tm_sec'], 1, $ftime['tm_yday'] + 1, $ftime['tm_year'] + 1900);
$session_timestamp = $session->start_time;
unset($session);
unset($sessions);
$timer->setMarker('Decode Records - Start');
exec('/usr/local/bin/fitdecode -r ' . $upload['tmp_name'], $xml_records);
$xml_records = implode("\n", $xml_records);
$records_input = parseRecords($xml_records, $session_epoch);
$timer->setMarker('Decode Records - End');
if (is_array($records_input)) {
$record_prev = $records_input[0];
}
/* Get the array of records, removing duplicates */
$records = array();
foreach ($records_input as $record) {
if (!isset($record_last) || $record_last->interval != $record->interval) {
$records[] = $record;
}
$record_last = $record;
}
unset($records_input);
unset($record_last);
$UserAPI = Module_UserManagement_API::getInstance();
$user = $UserAPI->getUser();
/* Add the matching data points */
foreach ($records as $record) {
/* Skip duplicates, they will cause issues in graphs */
if (!isset($record->power)) {
$record->power = $api->getPower($record->gradient, $record->temperature, $record->altitude, $record->speed, $record->speed - $record_prev->speed, $record->interval - $record_prev->interval, $user['rider_weight'], $user['bike_weight']);
}
$record_prev = $record;
}
unset($user);
unset($UserAPI);
$timer->setMarker('Record insertion - start');
$api->insertAllSessionData($session_timestamp, $records);
/* Insert all the data */
$timer->setMarker('Record insertion - end');
/* Calculate the climbs */
$climbs = $api->getClimbCategories();
$timer->setMarker('Climb - Start');
$min_climb = $climbs[0];
/* 500m with an average gradient of more than 3% (cat 5)*/
/* Find the points that have a distance of 500m */
$window_distance = 0;
$window_altitude = 0;
$cat = -1;
$climb_num = 1;
$num_records = count($records);
$num_climbs = count($climbs);
for ($front = 0, $back = 0; $front < $num_records; $front++) {
$window_distance += $records[$front]->delta_distance * 1000;
$window_altitude += $records[$front]->delta_altitude;
if ($window_distance > $min_climb['min_distance']) {
$window_gradient = $window_altitude / $window_distance * 100;
/* Check if we have found the start of a climb */
if ($cat == -1 && $window_gradient >= $climbs[$cat + 1]['min_gradient']) {
$cat++;
/* Go through and find the minimum height */
$min = $back;
for ($i = $back; $i < $front; $i++) {
if ($records[$i]->altitude <= $records[$min]->altitude) {
$min = $i;
}
}
$climb['bottom'] = $records[$min]->interval;
$climb['min_altitude'] = $records[$min]->altitude;
}
/* Check if we have finished the climb */
if ($cat != -1 && $window_gradient < $climbs[$cat]['min_gradient']) {
/* Need to go back and find the maximum altitude */
$max = $back;
for ($i = $back; $i < $front; $i++) {
if ($records[$i]->altitude > $records[$max]->altitude) {
$max = $i;
}
}
$climb['top'] = $records[$max]->interval;
$climb['max_altitude'] = $records[$max]->altitude;
/* Get the max gradient */
$climb['gradient_max'] = $records[$min]->gradient;
for ($i = $min; $i <= $max; $i++) {
if ($climb['gradient_max'] < $records[$i]->gradient) {
$climb['gradient_max'] = $records[$i]->gradient;
}
}
/* Tally the totals */
$climb['total_climbed'] = 0;
for ($i = $min + 1; $i <= $max; $i++) {
$climb['total_climbed'] += $records[$i]->delta_altitude;
}
$climb['total_distance'] = round($records[$max]->distance - $records[$min]->distance, 2);
$climb['gradient_avg'] = round($climb['total_climbed'] / ($climb['total_distance'] * 1000) * 100, 2);
/* Find the category of the climb */
$cat = -1;
while ($cat + 1 < $num_climbs && $climb['gradient_avg'] >= $climbs[$cat + 1]['min_gradient'] && $climb['total_distance'] * 1000 >= $climbs[$cat + 1]['min_distance'] && $climb['total_climbed'] >= $climbs[$cat + 1]['min_height']) {
$cat++;
}
$climb['cat'] = $cat;
if ($cat != -1) {
/* Store it into the database */
$api->insertClimb($session_timestamp, $climb_num++, $climb['bottom'], $climb['top'], $climb['gradient_avg'], $climb['gradient_max'], $climb['total_distance'], $climb['total_climbed'], $climb['min_altitude'], $climb['max_altitude']);
/* Start search for the next climb */
$front = $max;
$back = $max;
$window_distance = 0;
$window_altitude = 0;
} else {
/* It was a false climb, either not steep enough,
* too short, and the window just masked this
* Keep searching for the next climb
*/
}
$cat = -1;
}
/* Move the back of the window up */
while ($window_distance > $min_climb['min_distance'] && $back < $num_records) {
$window_distance -= $records[$back]->delta_distance * 1000;
$window_altitude -= $records[$back]->delta_altitude;
$back++;
}
}
}
$timer->setMarker('Climb - End');
/*
* Bikes
* userid
* name
* description
* type, TT or Road
* weight
* picture?
* Assign a bike to an exercise session at creation time?
*/
unset($records);
$timer->setMarker('Laps - Start');
exec('/usr/local/bin/fitdecode -l ' . $upload['tmp_name'], $xml_laps);
$xml_laps = implode("\n", $xml_laps);
$laps = parseLaps($xml_laps);
$timer->setMarker('Laps - End');
$lap_num = 1;
foreach ($laps as $lap) {
$ftime = strptime($lap->start_time, '%FT%T%z');
$start_epoch = mktime($ftime['tm_hour'], $ftime['tm_min'], $ftime['tm_sec'], 1, $ftime['tm_yday'] + 1, $ftime['tm_year'] + 1900);
$lap_start = $start_epoch - $session_epoch;
$api->insertLap($session_timestamp, $lap_num, $lap_start, $lap->start_position_lat, $lap->start_position_long, $lap->total_timer_time, $lap->total_elapsed_time, $lap->total_calories, $lap->avg_heart_rate, $lap->max_heart_rate, $lap->avg_speed, $lap->max_speed, $lap->total_ascent, $lap->total_descent, $lap->total_distance);
$lap_num++;
}
//$timer->display();
$db->commit();
$plans = Module_Plans_API::getInstance();
$view->planned = $plans->getClosestPlan($session_timestamp);
$view->session_timestamp = $session_timestamp;
$view->UploadStatusMsg = "Is this session the planned exercise session on at ere";
$view->UploadStatus = "Success";
} catch (Exception $e) {
$db->rollback();
$view->UploadStatusMsg = "Failed to upload";
$view->UploadStatus = "Error";
echo $e->getMessage();
}
$timer->display();
}
$view->addForm($form);
$view->subTemplate = 'genericForm.tpl';
echo $view->render();
}
* @package Benchmark
* @author Sebastian Bergmann <*****@*****.**>
* @copyright 2002-2005 Sebastian Bergmann <*****@*****.**>
* @license http://www.php.net/license/3_0.txt The PHP License, Version 3.0
* @version CVS: $Id: timer_example.php 268884 2008-11-12 20:57:49Z clockwerx $
* @link http://pear.php.net/package/Benchmark
*/
require '../library/Timer.php';
/**
* Wait
*
* @param int $amount Amount to wait
*
* @return void
*/
function wait($amount)
{
for ($i = 0; $i < $amount; $i++) {
for ($i = 0; $i < 100; $i++) {
}
}
}
// Pass the param "true" to constructor to automatically display the results
$timer = new Benchmark_Timer();
$timer->start();
wait(10);
$timer->setMarker('Mark1');
echo "Elapsed time between Start and Mark1: " . $timer->timeElapsed('Start', 'Mark1') . "\n";
wait(50);
$timer->stop();
$timer->display();
<!DOCTYPE html>
<html lang="ja">
<head>
<meta charset="UTF-8">
<title>ベンチマークを取得したい（１）</title>
</head>
<body>
<div>
<?php
// PEAR::Benchmark_Timerをインクルードします
require_once 'Benchmark/Timer.php';
// タイマーオブジェクトをnew演算子で作成する
$timer = new Benchmark_Timer();
// 計測を開始する
$timer->start();
// 計測対象（１）（sha1()関数を1000回実行)
for ($i = 0; $i < 1000; $i++) {
sha1($i);
}
// マーカーをセットする
$timer->setMarker('sha1()関数を1000回位実行');
// b計測対象（２）（md()関数を1000回実行)
for ($i = 0; $i < 1000; $i++) {
md5($i);
}
$timer->setMarker('md5()関数を1000回実行');
// 計測を終了し、結果を表示する
$timer->stop();
$timer->display();
?>
</div>
}
$t->stop();
//$t->display();
$profiling = $t->getProfiling();
unset($t);
$igbinary_pack += $profiling[1]['diff'];
$igbinary_unpack += $profiling[2]['diff'];
$igbinary_size += strlen($pack);
if ($unpack === $value || is_object($value) && $unpack == $value) {
$igbinary_status = 'OK';
}
}
//msgpack
$pack = null;
$unpack = null;
$t = new Benchmark_Timer();
$t->start();
for ($i = 0; $i < $loop; $i++) {
$pack = msgpack_serialize($value);
}
$t->setMarker('msgpack_serialize');
for ($i = 0; $i < $loop; $i++) {
$unpack = msgpack_unserialize($pack);
}
$t->stop();
//$t->display();
$profiling = $t->getProfiling();
unset($t);
$msgpack_pack += $profiling[1]['diff'];
$msgpack_unpack += $profiling[2]['diff'];
$msgpack_size += strlen($pack);
KEY `key_user_article_its_mine` (`its_mine`),
KEY `key_user_article_deleted` (`deleted`),
KEY `key_user_article_read_later` (`read_later`),
KEY `key_user_article_followed` (`followed`),
KEY `key_user_article_uid` (`uid`),
KEY `key_user_article_aid` (`aid`)
);
`comments` varchar(10) NOT NULL DEFAULT '',
*/
require_once 'benchmarks.php';
require_once 'FbAuth.php';
require_once 'model_user.php';
//###To make more secure ajax call look use this: http://insecureweb.com/web-security/secure-your-ajax-request-with-jquery/
//I create timer object and start it (TRUE)
$timer = new Benchmark_Timer();
$timer->start();
//Establish connection
try {
DB::get()->connect();
} catch (Exception $e) {
print_r($e);
//### It must be handle better: writing in the log file (that must be set) and
}
$realUser = 0;
$u = FbAuth::requireAuthenticate(true, false, $realUser);
//### This must change later to true and take vcare to pass the cookie
if (!$u) {
error('Not logged in: Try to refresh the page');
}
//In order to debug XML add "?T3ST=1" in the URL
@define("APP_LIGHT_COLOR", "#DDDDDD");
@define("APP_MIDDLE_COLOR", "#CACACA");
@define("APP_DARK_COLOR", "#CACACA");
@define("APP_CYCLE_COLORS", "#DDDDDD,#CACACA");
@define("APP_INTERNAL_COLOR", "#9C494B");
// define the user_id of system user
@define("APP_SYSTEM_USER_ID", 1);
// define the type of password hashing to use (MD5, MD5-64)
@define('APP_HASH_TYPE', 'MD5');
// if full text searching is enabled
@define("APP_ENABLE_FULLTEXT", '%{APP_ENABLE_FULLTEXT}%');
@define("APP_BENCHMARK", false);
if (APP_BENCHMARK) {
// always benchmark the scripts
include_once "Benchmark/Timer.php";
$bench = new Benchmark_Timer();
$bench->start();
}
include_once APP_INC_PATH . "class.misc.php";
if (isset($_GET)) {
$HTTP_POST_VARS = $_POST;
$HTTP_GET_VARS = $_GET;
$HTTP_SERVER_VARS = $_SERVER;
$HTTP_ENV_VARS = $_ENV;
$HTTP_POST_FILES = $_FILES;
// seems like PHP 4.1.0 didn't implement the $_SESSION auto-global...
if (isset($_SESSION)) {
$HTTP_SESSION_VARS = $_SESSION;
}
$HTTP_COOKIE_VARS = $_COOKIE;
}
/**
* Выполнение sql-запроса
*
* @param string запрос
*
* @global $nc_core
*
* @return bool выполнился запрос или нет
*/
function ExecuteSQLQuery($Query)
{
global $nc_core;
$SHOW_MYSQL_ERRORS = $nc_core->SHOW_MYSQL_ERRORS;
$db = $nc_core->db;
// таймер
$nccttimer = new Benchmark_Timer();
$Query = trim(stripslashes($Query));
$db->query("DELETE FROM `SQLQueries` WHERE MD5(`SQL_text`) = '" . md5($Query) . "' ");
// если в истории запросов больше 15, то нужно удалить
if ($db->get_var("SELECT COUNT(`SQL_ID`) FROM `SQLQueries`") >= 15) {
$db->query("DELETE FROM `SQLQueries` ORDER BY `SQL_ID` LIMIT 1");
}
$db->query("INSERT INTO SQLQueries (SQL_ID, SQL_text) VALUES ('', '" . $db->escape($Query) . "')");
// скроем ошибки в случае неправильного запроса, чтобы вывести свое сообщение об ошибке
$db->hide_errors();
// выполение запроса
$nccttimer->start();
$res = $db->get_results(stripslashes($Query), ARRAY_A);
$nccttimer->stop();
// если показ ошибок MySQL включен, то включим его обратно
if ($SHOW_MYSQL_ERRORS == 'on') {
$db->show_errors();
}
if ($db->captured_errors) {
echo "<br /><b>Query:</b> " . $db->captured_errors[0][query] . "<br><br><b>Error:</b> " . $db->captured_errors[0][error_str] . "<br /><br />";
return false;
}
$count = $db->num_rows;
// вывод таблицы с результатом, если нет ошибок
if ($res && $count) {
echo "<br /><b>" . htmlspecialchars(stripslashes($Query)) . "</b><br /><br />";
$data = $res;
echo "<table border='0' cellpadding='0' cellspacing='0' width='100%'>\n <tr><td>\n <table class='admin_table sql_table' width='100%'><tr>";
//вывод полей
while (list($key, $val) = each($res[0])) {
echo "<td><font>" . $key . "</td>";
}
echo "</tr>";
reset($res[0]);
for ($i = 0; $i < $count; $i++) {
echo "<tr>";
while (list($key, $val) = each($res[$i])) {
echo "<td><font> " . htmlspecialchars($res[$i][$key]) . "</td>";
}
echo "</tr>";
}
echo "</table></td></tr></table><br>";
$res_num = $count ? $count : $db->rows_affected;
} elseif (!$res) {
if (preg_match("/^(insert|delete|update|replace)\\s+/i", $db->last_query)) {
$res_num = $db->rows_affected;
} else {
$res_num = $db->num_rows;
}
}
echo "<div>" . TOOLS_SQL_OK . "</div>";
echo "<div>" . TOOLS_SQL_TOTROWS . ": " . $res_num . "</div>";
echo "<div>" . TOOLS_SQL_BENCHMARK . ": " . $nccttimer->timeElapsed() . "</div>";
echo "<br />";
}
require_once "setup.php";
//session_start();
if (!isset($files_path)) {
$files_path = '';
}
if (!isset($server_encoding)) {
$server_encoding = '';
}
if (!isset($browser_encoding)) {
$browser_encoding = '';
}
include $files_path . 'date_time.php';
//---------------------------------------
if (isset($use_benchmark) && $use_benchmark) {
require_once $_SERVER['DOCUMENT_ROOT'] . '/' . $root_folder . '_modules/benchmark/library/Timer.php';
$timer = new Benchmark_Timer();
$timer->start();
$timer->setMarker('Mark1');
}
//---------------------------------------
//
if (!$site_blocked) {
include $files_path . 'week.php';
}
$metaKeywords = '';
$pg_author = '';
$pg_description = '';
$q_val = 'select pu.`description`,pu.`meta_keywords`, pu.`title`,u.fio_short as author
from `pg_uploads` pu left join users u on u.id=pu.user_id_insert
where pu.`name` like "' . $curpage . '"';
$pg_stat = getRowSqlVar($q_val);
/**
* Add a profile message that can be displayed after executing the script
*
* You can add benchmark markers by calling
*
* Ak::profile('Searching for books');
*
* To display the results you need to call
*
* Ak::profile(true);
*
* You might also find handy adding this to your application controller.
*
* class ApplicationController extends BaseActionController
* {
* function __construct(){
* $this->afterFilter('_displayBenchmark');
* parent::__construct();
* }
* public function _displayBenchmark(){
* Ak::profile(true);
* }
* }
*
* IMPORTANT NOTE: You must define AK_ENABLE_PROFILER to true for this to work.
*/
function profile($message = '')
{
if(AK_ENABLE_PROFILER){
if(!$ProfileTimer = $Timer = Ak::getStaticVar('ProfileTimer')){
require_once 'Benchmark/Timer.php';
$ProfileTimer = new Benchmark_Timer();
$ProfileTimer->start();
Ak::setStaticVar('ProfileTimer', $ProfileTimer);
}elseif($message === true){
$ProfileTimer->display();
}else {
$ProfileTimer->setMarker($message);
}
}
}
<?php
declare (ticks=1);
if (PHP_SAPI != 'cli') {
die('Hey, CLI only!');
}
define('TEST_ITERATIONS', 1000);
define('TEST_CREATIVES', 10);
define('TEST_ZONES', 10);
require "Benchmark/Timer.php";
require 'testCases/BucketDB.php';
$t = new Benchmark_Timer();
$t->start();
$aTests = array(25, 50, 75, 100);
$t->setMarker('Script init');
foreach ($aTests as $concurrency) {
$oTest = bucketDB::factory(array('type' => 'MySQL', 'host' => 'localhost', 'user' => 'root', 'password' => 'password', 'dbname' => 'test_bucket', 'engine' => 'MyISAM'));
test_update($oTest, $concurrency, $t, 'MyISAM');
$oTest = bucketDB::factory(array('type' => 'MySQL', 'host' => 'localhost', 'user' => 'root', 'password' => '', 'dbname' => 'test_bucket', 'engine' => 'MyISAM', 'pkIndexType' => 'USING HASH'));
test_update($oTest, $concurrency, $t, 'MyISAMHashPk');
$oTest = bucketDB::factory(array('type' => 'MySQL', 'host' => 'localhost', 'user' => 'root', 'password' => '', 'dbname' => 'test_bucket', 'engine' => 'InnoDB'));
test_update($oTest, $concurrency, $t, 'InnoDB');
$oTest = bucketDB::factory(array('type' => 'MySQL', 'host' => 'localhost', 'user' => 'root', 'password' => '', 'dbname' => 'test_bucket', 'engine' => 'InnoDB', 'pkIndexType' => 'USING HASH'));
test_update($oTest, $concurrency, $t, 'InnoDBHashPk');
$oTest = bucketDB::factory(array('type' => 'MySQL', 'host' => 'localhost', 'user' => 'root', 'password' => '', 'dbname' => 'test_bucket', 'engine' => 'MEMORY'));
test_update($oTest, $concurrency, $t, 'MEMORY');
$oTest = bucketDB::factory(array('type' => 'MySQL', 'host' => 'localhost', 'user' => 'root', 'password' => 'password', 'dbname' => 'test_bucket', 'engine' => 'MEMORY', 'additionalIndexes' => ', INDEX USING BTREE (date_time)'));
//Test using additional B-TREE index on date_time - slower than MEMORY
//test_update($oTest, $concurrency, $t, 'MEMBTR');
$oTest = bucketDB::factory(array('type' => 'MySQL', 'host' => 'localhost', 'user' => 'root', 'password' => 'password', 'dbname' => 'test_bucket', 'engine' => 'MEMORY', 'pkIndexType' => 'USING BTREE'));
//Test using Primay Key as B-TREE index
define('LANG', BASE . DS . 'Uthando-Lib' . DS . 'langs' . DS);
define('FUNCS', BASE . DS . 'Uthando-Lib' . DS . 'functions' . DS);
define('TEMPLATES', BASE . DS . 'Uthando-Templates' . DS);
define('JS', BASE . DS . 'Uthando-JS' . DS);
define('CSS', BASE . DS . 'Uthando-CSS' . DS);
define('IMAGE', BASE . DS . 'Uthando-Images' . DS);
define('SCHEME', isset($_SERVER['HTTPS']) ? 'https://' : 'http://');
define('HOST', $_SERVER['HTTP_HOST']);
define('REQUEST_URI', $_SERVER['REQUEST_URI']);
// Set include paths.
$ini_path = get_include_path() . PS . CLASSES . PS . FUNCS . PS . MODULES . PS . COMPONENTS;
set_include_path($ini_path);
// Include functions.
require_once 'functions.php';
require_once 'admin_functions.php';
$timer = new Benchmark_Timer();
$timer->start();
$registry = new Admin_Registry();
$registry->setSite(BASE . DS . 'Uthando-ini' . DS . 'UthandoSites.ini' . EXT);
$registry->loadIniFiles(array('admin_config' => 'uthandoAdmin', 'config' => 'uthando'));
$registry->setDefaults();
$uthando = new Admin_Uthando($registry);
$registry->template = new HTML_Template($registry, $registry->get('admin_config.site.template'));
require 'Dbug/FirePHP.class.php';
$registry->firephp = FirePHP::getInstance(true);
try {
$registry->db = new DB_Admin($registry);
$registry->session = new Session($registry);
UthandoUser::setUserInfo();
if ($uthando->authorize()) {
$registry->template->addParameter('login_status', 'You are logged in as: ' . $_SESSION['username']);
<?php
/*
This test script requires PEAR/Benchmark to measure the script runtime.
*/
if (function_exists('xdebug_start_code_coverage')) {
xdebug_start_code_coverage();
}
require_once 'Benchmark/Timer.php';
$timer = new Benchmark_Timer();
$timer->start();
require '../xajax_core/xajax.inc.php';
//require( '../xajax_core/xajaxAIO.inc.php' );
$timer->setMarker('xajax included');
// -- testing session serialization for xajax object
//session_start();
//
//unset($_SESSION['xjxcore']);
//
//$xajax = null;
//
//if (false == isset($_SESSION['xjxcore']))
//{
// $xajax = new xajax();
//
// $_SESSION['xjxcore'] = $xajax;
//}
//else
//{
// $xajax = $_SESSION['xjxcore'];
require 'Benchmark/Timer.php';
$shortopts = "h";
$options = getopt($shortopts);
if (isset($options['h'])) {
print "usage: php build_tables.php <rows> <partitions> <mysql|drizzle>\n";
die;
}
$max_rows = $_SERVER['argv'][1];
$parts = $_SERVER['argv'][2];
$db_type = $_SERVER['argv'][3];
// db select is contained with bmark_connect
if (strlen($db_type) <= 0) {
$db_type = 'drizzle';
}
$dbh = bmark_connect($db_type);
$timer = new Benchmark_Timer();
$timer->start();
// build it 3 types of tables
// 1) a table with 5000 users indexed
// 2) a table with 5000 users code partitioned and indexed
// 3) a table with 5000 users mysql partitioned
/*
$max_rows = 500;
$parts = 5;
*/
$perpart = ceil($max_rows / $parts);
$mid_perpart = ceil($perpart / 2);
$mid_id = ceil($max_rows / 2);
$mid_table = ceil($parts / 2);
$s_mid_table = padNumber($mid_table, 2);
$sql = "drop table if exists users_no_partition";
<?php
include_once dirname(__FILE__) . '/../code/PEG.php';
include_once 'Benchmark/Timer.php';
/**
* メモ化の有無での処理時間の差を見るサンプル
* ここではメモ化するのとしないのとでは著しく違いが出る文法規則を元にパーサを組み立てている
*/
$t = new Benchmark_Timer();
$str = '((((((((1))))))))';
$t->start();
// メモ化していないパーサ
$a = PEG::ref($a_ref);
$p = PEG::ref($p_ref);
$a_ref = PEG::choice(PEG::seq($p, '+', $a), PEG::seq($p, '-', $a), $p);
$p_ref = PEG::choice(PEG::seq('(', $a, ')'), '1');
$a->parse(PEG::context($str));
$t->setMarker('no memoize');
// メモ化しているパーサ
$a = PEG::ref($a_ref);
$p = PEG::ref($p_ref);
$a_ref = PEG::memo(PEG::choice(PEG::seq($p, '+', $a), PEG::seq($p, '-', $a), $p));
$p_ref = PEG::memo(PEG::choice(PEG::seq('(', $a, ')'), '1'));
$a->parse($c = PEG::context($str));
$t->setMarker('memoize');
$t->stop();
$t->display();
/* 結果
---------------------------------------------------------
marker time index ex time perct
---------------------------------------------------------
<?php
require_once 'Benchmark/Timer.php';
require_once __DIR__ . '/../../vendor/autoload.php';
use ju1ius\Text\Source;
use ju1ius\Css;
$timer = new Benchmark_Timer();
$timer->start();
$dir = dir(__DIR__ . '/../files/full/');
$files = array();
while ($file = $dir->read()) {
if ($file === '.' || $file === '..') {
continue;
}
$path = $dir->path . '/' . $file;
$size = filesize($path);
echo "Loading file {$file} ({$size} bytes) \n";
$files[$size] = file_get_contents($path);
}
ksort($files, SORT_NUMERIC);
$timer->setMarker("Files loaded");
foreach ($files as $size => $string) {
$before = memory_get_usage();
$lines = mb_split('\\r\\n|\\n', $string);
$after = memory_get_usage();
$size /= 1024;
printf("Split %s lines, filesize: %s\n", count($lines), $size);
printf("Memory allocated: %s Ko\n", ($after - $before) / 1024);
$timer->setMarker("Splitting " . count($lines) . " lines - {$size} Ko total");
unset($lines);
}
function sparql($I)
{
##Parse the query and build the dataset
#global $timer;
if (is_file(S3DB_SERVER_ROOT . '/pearlib/Benchmark/Timer.php')) {
require_once S3DB_SERVER_ROOT . '/pearlib/Benchmark/Timer.php';
$timer = new Benchmark_Timer();
$timer->start();
}
extract($I);
##To use SPARQL with ARC library, we will need it to work with a remote endpoint. That means that we do not want to configure ARC as a datastore, but rather to retrieve the data from s3db deployments, convert it to RDF and then use ARC to run the query on it
/* ARC2 static class inclusion */
ini_set("include_path", S3DB_SERVER_ROOT . "/pearlib/arc" . PATH_SEPARATOR . ini_get("include_path"));
include_once "ARC2.php";
$s3ql['url'] = $in['url'] != '' ? $in['url'] : $default_uri;
$s3ql['key'] = $in['key'] != '' ? $in['key'] : get_user_key($user_id, $db);
$q = $in['query'];
list($query, $triples, $prefixes) = parse_sparql_query($q, $s3ql);
$bq .= "PREFIX " . implode("\n PREFIX ", $query['prefix']) . "\n ";
$bq .= "SELECT " . $query['select'][0] . "\n ";
$bq .= "FROM" . implode(" FROM ", $query['from']) . "\n ";
$bq .= "WHERE " . $query['where'][0] . "\n ";
preg_match_all('(\\?[A-Za-z0-9]+) ', $bq, $vars);
if ($vars[0]) {
$vars = array_unique($vars[0]);
$sparql_vars = implode(" ", $vars);
}
if ($query['select'][0] != "" && $query['select'][0] != "*") {
$outputCols = explode(" ", trim($query['select'][0]));
$outputCols = array_filter($outputCols);
$outputCols = array_intersect($vars, $outputCols);
}
$sparql = ereg_replace("FROM(.*)WHERE", "WHERE", $bq);
#lets preprocess the order by which the must be queries must be performed to optimize speedness
list($iterations, $scrambled) = iterationOrder($triples, $prefixes, true);
##$rdf_results will contain the totality of triples retrieved from s3db;
##Start a rdf-api model
$iterations = array_values($iterations);
$rdf = S3DB_URI_BASE . '/s3dbcore/model.n3';
#base s3db rdf model
$filename = md5($rdf);
$file_place = $GLOBALS['uploads'] . '/';
#$queryModel = rdf2php($rdf);
#$data = $queryModel->sparqlQuery($sparql);
#echo '<pre>';print_r($data);exit;
if ($timer) {
$timer->setMarker('Core model read into results');
}
$rdf_results = array();
$performedQueries = array();
$r = 0;
foreach ($iterations as $it => $triples2query) {
$S3QL = array();
$S3QLfinal = array();
foreach ($triples2query as $i => $tripleInd) {
$tripleString = $tripleInd;
list($subject, $predicate, $object) = explode(' ', trim($tripleString));
$subject = ereg_replace('^<|>$', '', $subject);
$predicate = ereg_replace('^<|>$', '', $predicate);
$object = ereg_replace('^<|>$', '', $object);
$triple = compact('subject', 'predicate', 'object');
#sparql triple is used to calculate the values of the variables in the triple
#$sparql_triple = $sparql_prefixes_default.' SELECT * WHERE { '.ltrim($tripleString).' . }';
#now lets interpret the triple to explore the space of possible queries on S3QL
$pack = compact('triple', 's3ql', 'user_id', 'db', 'prefixes', 'varType', 'discoveredData', 'it', 'varTypeWhere', 'collected_data', 'performedQueries');
$sp = sparql_navigator($pack);
extract($sp);
# if($timer) $timer->setMarker('Built query '.$i);
##Remove queries that were already performed
if ($S3QL[0]) {
foreach ($S3QL as $s => $q) {
$S3QLfinal[] = $q;
$queried_elements[] = $element[$s];
}
$localQueries[$tripleString] = $localQueries[0];
$remoteQueries[$tripleString] = $remoteQueries[0];
$localQueries = array_filter($localQueries);
$remoteQueries = array_filter($remoteQueries);
}
}
$S3QL = $S3QLfinal;
##Remove repeated queries
$S3QL = array_unique($S3QL);
#if only the s3ql is requested, we can return it now
if ($in['output'] == 'S3QL') {
foreach ($localQueries as $sparqlVersion => $s3qlVersion) {
$Q[]['S3QL'] = S3QLQuery($s3qlVersion);
}
foreach ($remoteQueries as $rq) {
$Q[]['S3QL'] = $rq;
}
$root = 's3ql';
#root is just the word that xml should parse as the root for each entry
$data = $Q;
$cols = array('S3QL');
$format = $in['format'] == '' ? 'html' : $in['format'];
$z = compact('data', 'cols', 'format', 'root');
$out = outputFormat($z);
return array(true, $out);
}
#If paralel library is activated, use it for the data. Otherwise use the custom version
#$query_answers_file = 'sparql_query_ans'.rand(100,200); $a=fopen($query_answers_file, 'a');
if (!empty($S3QL)) {
if (extension_loaded('curl') && $goparallel) {
// Create cURL handlers
if ($timer) {
$timer->setMarker('Starting queries from group ' . $it);
}
foreach ($S3QL as $k => $url) {
$qURL = $url;
$ch[$k] = curl_init();
// Set options
curl_setopt($ch[$k], CURLOPT_URL, $qURL . '&format=php');
curl_setopt($ch[$k], CURLOPT_RETURNTRANSFER, 1);
}
$mh = curl_multi_init();
foreach ($S3QL as $k => $url) {
curl_multi_add_handle($mh, $ch[$k]);
}
$running = null;
do {
curl_multi_exec($mh, $running);
if ($timer) {
$timer->setMarker('Query ' . $k . ' of group ' . $it . ' executed');
}
} while ($running > 0);
foreach ($S3QL as $k => $url) {
$answer[$k] = curl_multi_getcontent($ch[$k]);
if (!empty($answer[$k])) {
#@fwrite($a, $answer[$k]);
##This is what takes the longest after the query, can it be replaced?
$ans = unserialize($answer[$k]);
$letter = $queried_elements[$r][0];
if (empty($ans)) {
##is this query part is not optional, then the result will be null
##TO BE DEVELOPED SOON
} else {
$rdf_results[$letter][] = $ans;
}
$r++;
##Add the triples to already existing triples
#Line up the answer with the model
if ($timer) {
$timer->setMarker('Query ' . $it . '=>' . $k . ' converted to php ');
}
}
}
curl_multi_close($mh);
####Time count
#$time_end = microtime(true);
#$time = $time_end - $time_start;
#echo "Query took ".$time." seconds\n";exit;
###
} else {
#Now solve the remaining triples with the constants found in this one
if (is_array($localQueries) && !empty($localQueries)) {
foreach ($localQueries as $sparql_triple => $s3ql) {
$s3ql = array_filter(array_diff_key($s3ql, array('url' => '')));
$answer = localQ($s3ql);
if (!empty($answer)) {
$rdfanswer = rdf2php($answer);
#Line up the answer with the model
$queryModel->addModel($rdfanswer);
#Now perform the query on the small model to find a constant for the remaining queries
#list($data,$discovered, $discoveredData,$queryModel) = executeQuery($queryModel,$sparql_triple,$discovered,$format);
}
}
}
if (is_array($remoteQueries) && !empty($remoteQueries)) {
foreach ($remoteQueries as $remoteQuery) {
$answer = remoteQ($remoteQuery);
if (!empty($answer)) {
$rdfanswer = rdf2php($answer);
#Line up the answer with the model
$queryModel->addModel($rdfanswer);
#Now perform the query on the small model to find a constant for the remaining queries
#list($data,$discovered, $discoveredData,$queryModel) = executeQuery($queryModel,$sparql_triple,$discovered,$format);
}
}
}
}
}
}
##Get the data from the file
##Now, add the dictionary data
if ($complete) {
include_once S3DB_SERVER_ROOT . '/s3dbcore/dictionary.php';
$s3qlN = compact('user_id', 'db');
$s3qlN['from'] = 'link';
$s3qlN['format'] = 'php';
$links = query_user_dictionaries($s3qlN, $db, $user_id);
$links = unserialize($links);
$rdf_results['E'][0] = $links;
$s3qlN = compact('user_id', 'db');
$s3qlN['from'] = 'namespaces';
$s3qlN['format'] = 'php';
$ns = query_user_dictionaries($s3qlN, $db, $user_id);
$ns = unserialize($ns);
if ($timer) {
$timer->setMarker('Dictionary links retrieved');
}
}
##Convert the result into an RDF file
$data_triples = array();
if (is_array($rdf_results)) {
foreach ($rdf_results as $letter => $results2rdfize) {
$dont_skip_core_name = false;
$dont_skip_serialized = true;
if (ereg('S', $letter)) {
$dont_skip_serialized = false;
}
if (ereg('C|R|P', $letter)) {
$dont_skip_core_name = true;
}
foreach ($results2rdfize as $k => $data) {
$tmp_triples = rdf_encode($data, $letter, 'array', $s3ql['db'], $ns, $collected_data, $dont_skip_serialized, $dont_skip_core_name);
if (is_array($tmp_triples)) {
$data_triples = array_merge($data_triples, $tmp_triples);
}
}
}
}
if (!empty($data_triples)) {
$tmp['ns'] = $prefixes;
/*
#this one for turtle
$parser = ARC2::getComponent('TurtleParser', $a);
$index = ARC2::getSimpleIndex($triples, false) ; # false -> non-flat version
$rdf_doc = $parser->toTurtle($index,$prefixes);
*/
$parser = ARC2::getComponent('RDFXMLParser', $tmp);
$index = ARC2::getSimpleIndex($data_triples, false);
/* false -> non-flat version */
$rdf_doc = $parser->toRDFXML($index, $prefixes);
$filename = S3DB_SERVER_ROOT . '/tmp/' . random_string(15) . '.rdf';
$rr = fopen($filename, 'a+');
fwrite($rr, $rdf_doc);
fclose($rr);
if ($timer) {
$timer->setMarker(count($data_triples) . ' triples written to file ' . $filename);
}
##The better strategy would be to let the client cpu resolve the query; return the graphs with the rdf so that a sparql on the client can handle it
if ($return_file_name) {
if (filesize($filename) > 0) {
return array(true, $filename);
} else {
return array(false);
}
exit;
}
if ($redirect) {
##And now use an external service ( I gave up with ARC) to parse the query
$url2search = str_replace(S3DB_SERVER_ROOT, S3DB_URI_BASE, $filename);
##Giving up on ARC, surrender to sparql.com
$remote_endpoint = "http://sparql.org/sparql?query=";
$bq = ereg_replace("FROM <.*>", "FROM <" . $url2search . ">", $bq);
$bq = urlencode($bq);
$remote_endpoint .= $bq . '&default-graph-uri=&stylesheet=/xml-to-html.xsl';
return array(true, $remote_endpoint);
}
#echo $filename;exit;
#And finally perform the query on the model.
$queryModel = rdf2php($filename);
$format = $in['format'] != '' ? $in['format'] : 'html';
unlink($filename);
if ($timer) {
$timer->setMarker('Data converted to a model the rdf-api can query');
}
if (eregi('^(sparql-xml|sparql-html)$', $format)) {
switch ($format) {
case 'sparql-xml':
$result = $queryModel->sparqlQuery($sparql, 'XML');
break;
case 'sparql-html':
$result = $queryModel->sparqlQuery($sparql, 'HTML');
if ($_REQUEST['su3d']) {
$timer->stop();
$profiling = $timer->getProfiling();
echo "Query took " . $profiling[count($profiling) - 1]['total'] . ' sec';
}
break;
}
if ($result) {
return array(true, $result);
} else {
return false;
}
} elseif ($format == 'html.form') {
$form .= '
<html>
<head>
</head><body>
<form method="GET" action="sparql.php" id="sparqlform">
<h5>Target Deployment(s)</h5>
<input type="hidden" name="key" value="' . $s3ql['key'] . '"/>
<input type="hidden" name="format" value="' . $_REQUEST['format'] . '"/>
<input type = "text" id="url" size = "100%" value="' . $GLOBALS['url'] . '" name="url">
<h5>SPARQL <a href="http://www.w3.org/TR/rdf-sparql-query/" target="_blank">(help!!)</a></h5>
<br />
<textarea cols="100" id="sparql" rows="10" name = "query">' . stripslashes($sparql) . '</textarea><br />
<input type="submit" value="SPARQL this!" id="submitsparql"></body>
</form>
';
$form .= '<br />' . count($data) . " rows";
$form .= '<br />Query took ' . (strtotime(date('His')) - $start) . ' sec';
if (count($data) > 0) {
return array(true, $form);
} else {
return array(false);
}
} else {
#and output the result according to requested format
$data = $queryModel->sparqlQuery($sparql);
if ($timer) {
$timer->setMarker('Query on SPARQL data executed by rdf-api.');
}
if (is_array($outputCols) && !empty($outputCols)) {
##only this one are to be shown in the final result
$vars = $outputCols;
}
$cleanCols = array();
foreach ($vars as $varname) {
$cleanCols[] = ereg_replace('^\\?', '', $varname);
}
$outputData = array();
if (is_array($data)) {
foreach ($data as $s => $sparql_line) {
foreach ($sparql_line as $sparql_var => $sparql_var_value) {
if ($sparql_var_value->uri != '') {
$outputData[$s][ereg_replace('^\\?', '', $sparql_var)] = $sparql_var_value->uri;
} elseif ($sparql_var_value->label != '') {
$outputData[$s][ereg_replace('^\\?', '', $sparql_var)] = $sparql_var_value->label;
} else {
$outputData[$s][ereg_replace('^\\?', '', $sparql_var)] = "";
}
}
}
}
if ($timer) {
$timer->setMarker('Data converted in a format that fun outputformat can read');
}
#$timer ->display();
#root is just the word that xml should parse as the root for each entry
$root = 'sparql';
if ($timer) {
$timer->setMarker('All variables fitted into their places to represent in the final output');
}
$data = $outputData;
$cols = $cleanCols;
if ($_REQUEST['su3d']) {
$timer->stop();
$profiling = $timer->getProfiling();
echo "Query took " . $profiling[count($profiling) - 1]['total'] . ' sec<br>';
}
$z = compact('data', 'cols', 'format', 'root');
$out = outputFormat($z);
echo $out;
exit;
if (count($data) > 0) {
return array(true, $out);
} else {
return array(false);
}
}
} else {
return array(false);
}
#else {
#$out= formatReturn($GLOBALS['error_codes']['no_results'], 'Your query did not return any results.', $format,'');
#}
}
<?php
require 'Benchmark/Timer.php';
$timer = new Benchmark_Timer();
$mysql = new mysqli("localhost", "testuser", "testpass", "test");
$points = array(1000, 10000, 100000, 500000, 1000000);
foreach ($points as $val) {
flush_mysql();
$startmark = $val . ' start';
$stopmark = $val . ' stop';
$timer->setMarker($startmark);
cycle($val);
$timer->setMarker($stopmark);
print $val . ': ' . $timer->timeElapsed($startmark, $stopmark) . "\n";
}
$mysql->close();
function flush_mysql()
{
global $mysql;
$mysql->query("DROP TABLE IF EXISTS `php_insert_bm`");
$mysql->query("DROP TABLE IF EXISTS `php_insert_bm_coords`");
$mysql->query("CREATE TABLE `php_insert_bm_coords`(\n `id` int unsigned not null auto_increment,\n `x` int not null,\n `y` int not null,\n PRIMARY KEY (`id`)\n )");
$mysql->query("CREATE TABLE `php_insert_bm`(\n `id` int unsigned not null auto_increment,\n `text` varchar(255) not null,\n `count` int not null,\n `coords_id` int unsigned not null,\n PRIMARY KEY (`id`)\n )");
# empty init entries
$mysql->query("INSERT php_insert_bm_coords(x,y) VALUES(0, 0)");
$mysql->query("INSERT php_insert_bm(text, count, coords_id) VALUES('', 0, " . $mysql->insert_id . ')');
}
function cycle($c)
{
global $mysql;
for ($i = 0; $i < $c; $i++) {
