Well I just ran a quick test to see what would happen:
CODE
<?php
error_reporting(E_ALL);
require_once('mimesis/Mimesis.php');
$start = microtime(true);
$cwd = realpath(dirname(__FILE__));
$tableName = 'dutyTable';
$rowLabel = str_pad(0, 8, '0', STR_PAD_LEFT);
$columnsFile = 'keys';
$mimesis = new Mimesis($cwd, $tableName, $rowLabel, $columnsFile);
$mimesis->lockTable();
$mimesis->createTable();
for($i = 0; $i <= 99999999; $i++){
$rowLabel = str_pad($i, 8, '0', STR_PAD_LEFT);
$mimesis->redefineRow($rowLabel);
$temp = array($i, time(), str_pad('x', 1024, 'x', STR_PAD_LEFT));
$mimesis->insertRow($temp);
}
$mimesis->releaseTable();
echo microtime(true) - $start;
?>
Script execution timed out (at 30 seconds) and only created 2353 entries before aborting. Ran it again it produced 2639 more entries before timing out.
Second test involved querying 4992 entries that were created as follows:
CODE
<?php
error_reporting(E_ALL);
require_once('mimesis/Mimesis.php');
$start = microtime(true);
$cwd = realpath(dirname(__FILE__));
$tableName = 'dutyTable';
$rowLabel = str_pad(0, 8, '0', STR_PAD_LEFT);
$columnsFile = 'keys';
$mimesis = new Mimesis($cwd, $tableName, $rowLabel, $columnsFile);
$temp = $mimesis->queryTable(array(array(0, SORT_ASC)), null, false, array('/^.*keys\.php$/i'));
echo microtime(true) - $start;
?>
The browser output a total time of 22.610347986221 seconds.
The table itself is 5,320,383 bytes of data.
The size on disk of the table is 20,451,328 bytes.
This post has been edited by grimpirate: 11 Jun, 2008 - 03:20 PM
8 May, 2008 - 10:34 PM
| 