traag script

Status
Niet open voor verdere reacties.
ecross

ecross

Gebruiker
Lid geworden
4 mrt 2009
Berichten
638
hallo,

ik heb een script gemaakt met de mysql tabellen schippers en bootrooster je kunt dingen wijzigen via een dropdown box met de namen van de schippers ook kun je komentaar invullen
alleen is het script erg traag (bij mij) weet iemand waar dit aanlicht?

script (index.php)
PHP: 
<?php
$database = "rooster";
$tabel_bootrooster = "bootrooster";
$tabel_schippers = "schippers";

function show_select($row, $result_schippers){
extract($row);

$query_boten = "SELECT * from bootrooster where id='$id'"
						 or die("query_boten");
$result_boten = mysql_query($query_boten)
							or die("result_boten");
$row_boten = mysql_fetch_array($result_boten)
					 	 or die("row_boten");
						 
$query_dag_week = "SELECT DAYNAME('$datum')";
$result_dag_week = mysql_query($query_dag_week);
$row_dag_week = mysql_fetch_array($result_dag_week);
			
echo "<form action='" . $_SERVER['PHP_SELF'] . "' method='GET'>";
echo "<input type='hidden' name='doe' value='verander'>";
echo "<input type='hidden' name='id' value='$id'>";
if ($_GET['alles'] == "alles"){echo "<input type='hidden' name='alles' value='alles'>";}
	
if (isset($_GET['doe'])){echo "<input type='hidden' name='doe_na' value='$_GET[doe]'>";}
if (isset($_GET['dag_maand'])){echo "<input type='hidden' name='dag_maand' value='$_GET[dag_maand]'>";}
if (isset($_GET['maand'])){echo "<input type='hidden' name='maand' value='$_GET[maand]'>";}
if (isset($_GET['hoe'])){echo "<input type='hidden' name='hoe' value='$_GET[hoe]'>";}
if (isset($_GET['dag'])){echo "<input type='hidden' name='dag' value='$_GET[dag]'>";}
if (isset($_GET['schipper'])){echo "<input type='hidden' name='schipper' value='$_GET[schipper]'>";}

echo '<tr>';
echo "<td>" . $datum . "</td>";
echo "<td>" . $row_dag_week['0'] . "</td>";

		mysql_data_seek ( $result_schippers, 0 );	
		echo "<td><select name='valk_ochtend'>";
		if ($row_boten['valk_ochtend'] == '0')
			{echo "<option selected>vrij</option>";}
		else
			{echo "<option>vrij</option>";}
		while ($row_schippers = mysql_fetch_array($result_schippers))
			{
			if ($row_schippers['schippers_id'] == $row_boten['valk_ochtend'])
				{echo "<option selected>" . $row_schippers['voornaam'] . "</option>";}
			else 
				{echo "<option>" . $row_schippers['voornaam'] . "</option>";}
			}
		echo "</select></td>";
		
		mysql_data_seek ( $result_schippers, 0 );
		echo "<td><select name='valk_middag'>";
		if ($row_boten['valk_middag'] == '0')
			{echo "<option selected>vrij</option>";}
		else
			{echo "<option>vrij</option>";}
		while ($row_schippers = mysql_fetch_array($result_schippers))
			{
			if ($row_schippers['schippers_id'] == $row_boten['valk_middag'])
				{echo "<option selected>" . $row_schippers['voornaam'] . "</option>";}
			else 
				{echo "<option>" . $row_schippers['voornaam'] . "</option>";}
			}
		echo "</select></td>";
		
		mysql_data_seek ( $result_schippers, 0 );
		echo "<td><select name='valk_avond'>";
		if ($row_boten['valk_avond'] == '0')
			{echo "<option selected>vrij</option>";}
		else
			{echo "<option>vrij</option>";}
		while ($row_schippers = mysql_fetch_array($result_schippers))
			{
			if ($row_schippers['schippers_id'] == $row_boten['valk_avond'])
				{echo "<option selected>" . $row_schippers['voornaam'] . "</option>";}
			else 
				{echo "<option>" . $row_schippers['voornaam'] . "</option>";}
			}
		echo "</select></td>";
		
		mysql_data_seek ( $result_schippers, 0 );
		echo "<td><select name='rm_ochtend'>";
		if ($row_boten['rm_ochtend'] == '0')
			{echo "<option selected>vrij</option>";}
		else
			{echo "<option>vrij</option>";}
		while ($row_schippers = mysql_fetch_array($result_schippers))
			{
			if ($row_schippers['schippers_id'] == $row_boten['rm_ochtend'])
				{echo "<option selected>" . $row_schippers['voornaam'] . "</option>";}
			else 
				{echo "<option>" . $row_schippers['voornaam'] . "</option>";}
			}
		echo "</select></td>";
		
		mysql_data_seek ( $result_schippers, 0 );
		echo "<td><select name='rm_middag'>";
		if ($row_boten['rm_middag'] == '0')
			{echo "<option selected>vrij</option>";}
			else
			{echo "<option>vrij</option>";}
		while ($row_schippers = mysql_fetch_array($result_schippers))
			{
			if ($row_schippers['schippers_id'] == $row_boten['rm_middag'])
				{echo "<option selected>" . $row_schippers['voornaam'] . "</option>";}
			else 
				{echo "<option>" . $row_schippers['voornaam'] . "</option>";}
			}
		echo "</select></td>";
		
		mysql_data_seek ( $result_schippers, 0 );
		echo "<td><select name='rm_avond'>";
		if ($row_boten['rm_avond'] == '0')
			{echo "<option selected>vrij</option>";}
		else
			{echo "<option>vrij</option>";}
		while ($row_schippers = mysql_fetch_array($result_schippers))
			{
			if ($row_schippers['schippers_id'] == $row_boten['rm_avond'])
				{echo "<option selected>" . $row_schippers['voornaam'] . "</option>";}
			else 
				{echo "<option>" . $row_schippers['voornaam'] . "</option>";}
			}
		
		echo "</select></td>";
		
		echo "<td><input type='text' id='lengte' value='$opm_schip' name='opm_schip'></td>";
		echo "<td><input type='text' id='lengte' value='$opm_bestuur' name='opm_bestuur'></td>";
		echo "<td><input type='submit' value='ok'></td>";
		echo "</form>";
}
######################################################################################################
function show_normaal($row){
extract($row);

$query_dag_week = "SELECT DAYNAME('$datum')";
$result_dag_week = mysql_query($query_dag_week);
$row_dag_week = mysql_fetch_array($result_dag_week);
			
echo "<form action='" . $_SERVER['PHP_SELF'] . "' method='GET'>";
echo "<input type='hidden' name='show' value='select'>";
echo "<input type='hidden' name='id' value='$id'>";

if (isset($_GET['doe'])){echo "<input type='hidden' name='doe' value='$_GET[doe]'>";}
if (isset($_GET['dag_maand'])){echo "<input type='hidden' name='dag_maand' value='$_GET[dag_maand]'>";}
if (isset($_GET['maand'])){echo "<input type='hidden' name='maand' value='$_GET[maand]'>";}
if (isset($_GET['hoe'])){echo "<input type='hidden' name='hoe' value='$_GET[hoe]'>";}
if (isset($_GET['dag'])){echo "<input type='hidden' name='dag' value='$_GET[dag]'>";}
if (isset($_GET['schipper'])){echo "<input type='hidden' name='schipper' value='$_GET[schipper]'>";}

if ($_GET['alles'] == "alles"){echo "<input type='hidden' name='alles' value='alles'>";}	
	if ($valk_ochtend == "0"){$valk_ochtend['voornaam'] = "vrij";}
	else {$valk_ochtend = mysql_query("select voornaam from schippers where schippers_id = '$valk_ochtend'");
	$valk_ochtend = mysql_fetch_array($valk_ochtend);}

	if ($valk_middag == "0"){$valk_middag['voornaam'] = "vrij";}
	else {$valk_middag = mysql_query("select voornaam from schippers where schippers_id = '$valk_middag'");
	$valk_middag = mysql_fetch_array($valk_middag);}
		
	if ($valk_avond == "0"){$valk_avond['voornaam'] = "vrij";}
	else {$valk_avond = mysql_query("select voornaam from schippers where schippers_id = '$valk_avond'");
	$valk_avond = mysql_fetch_array($valk_avond);}
		
	if ($rm_ochtend == "0"){$rm_ochtend['voornaam'] = "vrij";}
	else {$rm_ochtend = mysql_query("select voornaam from schippers where schippers_id = '$rm_ochtend'");
	$rm_ochtend = mysql_fetch_array($rm_ochtend);}
		
	if ($rm_middag == "0"){$rm_middag['voornaam'] = "vrij";}
	else {$rm_middag = mysql_query("select voornaam from schippers where schippers_id = '$rm_middag'");
	$rm_middag = mysql_fetch_array($rm_middag);}
	
	if ($rm_avond == "0"){$rm_avond['voornaam'] = "vrij";}
	else {$rm_avond = mysql_query("select voornaam from schippers where schippers_id = '$rm_avond'");
	$rm_avond = mysql_fetch_array($rm_avond);}

$vandaag = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d"),date("Y")));
$gister = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")-1,date("Y")));
$eergister = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")-2,date("Y")));
$morgen = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")+1,date("Y")));
$overmorgen = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")+2,date("Y")));
		
echo '<tr>';
echo "<td>" . $datum . "</td>";
echo "<td>" . $row_dag_week['0'] . "</td>";
echo "<td>" . $valk_ochtend['voornaam'] . "</td>";
echo "<td>" . $valk_middag['voornaam'] . "</td>";
echo "<td>" . $valk_avond['voornaam'] . "</td>";
echo "<td>" . $rm_ochtend['voornaam'] . "</td>";
echo "<td>" . $rm_middag['voornaam'] . "</td>";
echo "<td>" . $rm_avond['voornaam'] . "</td>";
echo "<td>" . $opm_schip . "</td>";
echo "<td>" . $opm_bestuur . "</td>";
echo "<td><input type='submit' value='wijzig'></td>";
echo '</tr>';
echo "</form>";
}
#######################################################################################################
function head(){
echo "<tr>";
echo "<td colspan='12' align='center'><b>botenrooster van Gooimeerzeilen</b><br>";
echo "<a href='" . $_SERVER['PHP_SELF'] . "'>toon vandaag</a></td>";
echo "</tr>";
echo "<tr>";

echo "<tr>
		<form action='" . $_SERVER['PHP_SELF'] . "' method='GET'>
		<input type='hidden' value='zoek' name='doe'>
		<input type='hidden' value='exact' name='hoe'>
		<tr>
		<td align='center'>zoek op exacte datum</td>
		<td align='center'>zoek op dag</td>
		<td align='center'>zoek op schipper</td>
		<td colspan='10' rowspan='2' align='center'>de kolom opm_schippers wordt ook zichtbaar voor de schippers.</td>
		</tr>
		<tr>
		<td align='center'><select name='dag_maand' value='$_GET[dag_maand]'>";
		$dag = date("d");
		
		for ($i = 1; $i <= 31; $i++) {
		if ($i == $_GET['dag_maand']){echo "<option selected>" . $i . "</option>";}
		elseif ($i == $dag){echo "<option selected>" . $i . "</option>";}
		else{echo "<option>" . $i . "</option>";}
		}
  echo "</select>
		<select name='maand'>";
		$maand = date("M");
		$month_names = array('Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec');
		foreach($month_names as $key => $value){
		if ($value == $_GET['maand']){echo "<option selected>".$value."</option>";}
		elseif ($value == $maand){echo "<option selected>".$value."</option>";}
		else {echo "<option>$value</option>";}}

  echo "</select>
		<input type='submit' value='zoek'></td>
		</form>
		
		<form action='" . $_SERVER['PHP_SELF'] . "' method='GET'>
		<input type='hidden' value='zoek' name='doe'>
		<input type='hidden' value='dag_week' name='hoe'>
		
		<td align='center'><select name='dag'>";
		$dag = date("D");
		$day_translate = array("Mon"=>"Monday", "Tue"=>"Tuesday", "Wed"=>"Wednesday", "Fri"=>"Friday", "Sat"=>"Saturday", "Sun"=>"Sunday");
		foreach($day_translate as $key => $value){
		if ($dag == $key){$dag = $value;}}
		
		$day_names = array(1=>'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday');
		foreach($day_names as $key => $value){
		if ($value == $_GET['dag']){echo "<option selected>".$value."</option>"; $t="1";}
		elseif ($value == $dag and $t != "1"){echo "<option selected>".$value."</option>";}
		else {echo "<option>".$value."</option>";}}
  echo "</select>
		<input type='submit' value='zoek'></td>
		
		</form>
		<form action='" . $_SERVER['PHP_SELF'] . "' method='GET'>
		<input type='hidden' value='zoek' name='doe'>
		<input type='hidden' value='schipper' name='hoe'>
		
		<td align='center'><select name='schipper'>";
		$query = "select voornaam from schippers";
		$result = mysql_query($query);
		while ($row = mysql_fetch_array($result)){
		if ($row['voornaam'] == $_GET['schipper']){echo "<option selected>".$row['voornaam']."</option>";}
		else {echo "<option>".$row['voornaam']."</option>";}}
	echo "</select>
		<input type='submit' value='zoek'></td>
		
		
		</tr>
		</form>";
echo "<td>datum<td>dag_week<td>valk_ochtend<td>valk_middag<td>valk_avond<td>rm_ochtend<td>rm_middag<td>rm_avond<td>opm_schip<td>opm_bestuur<td>wijzig";
echo "</tr>";			
}
?>
<html>
<head><title>Member</title></head>
</html>
<style type="text/css"> 

input#lengte {
	width:  5em;
	  }
</style>
<?php
$user="******";
$host="********";
$password="********";

$connection = mysql_connect($host,$user,$password)
       or die ("couldn't connect to server");
$db = mysql_select_db($database,$connection)
		or die ("Couldn't select database");


echo "<table border='1' align='center'>";
switch (@$_GET['doe'])
  {
  case "zoek":
		if ($_GET['hoe'] == "exact")
			{
			    if ($_GET['maand'] == "Jan"){$maand = "01";}
			elseif ($_GET['maand'] == "Feb"){$maand = "02";}
			elseif ($_GET['maand'] == "Mar"){$maand = "03";}
			elseif ($_GET['maand'] == "Apr"){$maand = "04";}
			elseif ($_GET['maand'] == "May"){$maand = "05";}
			elseif ($_GET['maand'] == "Jun"){$maand = "06";}
			elseif ($_GET['maand'] == "Jul"){$maand = "07";}
			elseif ($_GET['maand'] == "Aug"){$maand = "08";}
			elseif ($_GET['maand'] == "Sep"){$maand = "09";}
			elseif ($_GET['maand'] == "Oct"){$maand = "10";}
			elseif ($_GET['maand'] == "Nov"){$maand = "11";}
			elseif ($_GET['maand'] == "Dec"){$maand = "12";}
			
				$datum = "2009-" . $maand . "-" . $_GET['dag_maand'];
				$query = "select * from $tabel_bootrooster where datum = '$datum'";
				$result = mysql_query($query);
				
				head();
				
				$query_schippers = "SELECT schippers_id, voornaam FROM $tabel_schippers"
					or die("query_schippers");
				$result_schippers = mysql_query($query_schippers)
					or die("result_schippers");
				
				if (@$_GET['show'] == "select")
				{
				while($row = mysql_fetch_array($result)) 
					{
					if ($row['id'] < $_GET['id'])
						{show_normaal($row);}
					elseif ($row['id'] == $_GET['id'])
						{show_select($row, $result_schippers);}
					elseif ($row['id'] > $_GET['id'])
						{show_normaal($row);}
					}
				}
				else 
				{
				while($row = mysql_fetch_array($result)) 
					{
					show_normaal($row);
					}
				}
				

			}
		elseif ($_GET['hoe'] == "dag_week")
			{
			head();

			$query = "select * from bootrooster"
				or die("298");
			$result = mysql_query($query)
				or die("wrong2");

			$query_schippers = "SELECT schippers_id, voornaam FROM $tabel_schippers"
				or die("query_schippers");
			$result_schippers = mysql_query($query_schippers)
				or die("result_schippers");
				if (@$_GET['show'] == "select")
				{
				while($row = mysql_fetch_array($result)) 
					{
					extract($row);
					$query_dagweek = "SELECT DAYNAME('$datum')";
					$result_dagweek = mysql_query($query_dagweek);
					$row_dagweek = mysql_fetch_array($result_dagweek);
					if ($row_dagweek['0'] == $_GET['dag'])
						{
						if ($row['id'] < $_GET['id'])
							{show_normaal($row);}
						elseif ($row['id'] == $_GET['id'])
							{show_select($row, $result_schippers);}
						elseif ($row['id'] > $_GET['id'])
							{show_normaal($row);}
						}
					}
				}
				else 
				{
				while($row = mysql_fetch_array($result)) 
					{
					extract($row);
					$query_dagweek = "SELECT DAYNAME('$datum')";
					$result_dagweek = mysql_query($query_dagweek);
					$row_dagweek = mysql_fetch_array($result_dagweek);
					if ($row_dagweek['0'] == $_GET['dag'])
						{show_normaal($row);}
					}
				}
			}
		elseif ($_GET['hoe'] == "schipper")
			{
			if ($_GET['schipper'] == "vrij"){$schipper['voornaam'] = "0";}
			else {$schipper = mysql_query("select schippers_id from schippers where voornaam = '$_GET[schipper]'");
			$schipper = mysql_fetch_array($schipper);}
			
			$query = "select * from bootrooster where valk_ochtend='$schipper[schippers_id]' or valk_middag='$schipper[schippers_id]' or valk_avond='$schipper[schippers_id]' or rm_ochtend='$schipper[schippers_id]' or rm_middag='$schipper[schippers_id]' or rm_avond='$schipper[schippers_id]'";
			$result = mysql_query($query);
			head();
			$query_schippers = "SELECT schippers_id, voornaam FROM $tabel_schippers"
					or die("query_schippers");
			$result_schippers = mysql_query($query_schippers)
					or die("result_schippers");
					
			if (@$_GET['show'] == "select")
				{
				while($row = mysql_fetch_array($result)) 
					{
					if ($row['id'] < $_GET['id'])
						{show_normaal($row);}
					elseif ($row['id'] == $_GET['id'])
						{show_select($row, $result_schippers);}
					elseif ($row['id'] > $_GET['id'])
						{show_normaal($row);}
					}
				}
			else 
				{
				while($row = mysql_fetch_array($result)) 
					{
					show_normaal($row);
					}
				}
			}
  break;
  case "verander":

		if ($_GET['valk_ochtend'] == "vrij"){$row_valk_ochtend['schippers_id'] = "0";}
		else{$result_valk_ochtend = mysql_query("select schippers_id from schippers where voornaam = '$_GET[valk_ochtend]'");
		$row_valk_ochtend = mysql_fetch_array($result_valk_ochtend);}
		
		if ($_GET['valk_middag'] == "vrij"){$row_valk_middag['schippers_id'] = "0";}
		else {$result_valk_middag = mysql_query("select schippers_id from schippers where voornaam = '$_GET[valk_middag]'");
		$row_valk_middag = mysql_fetch_array($result_valk_middag);}
		
		if ($_GET['valk_avond'] == "vrij"){$row_valk_avond['schippers_id'] = "0";}
		else {$result_valk_avond = mysql_query("select schippers_id from schippers where voornaam = '$_GET[valk_avond]'");
		$row_valk_avond = mysql_fetch_array($result_valk_avond);}
		
		if ($_GET['rm_ochtend'] == "vrij"){$row_rm_ochtend['schippers_id'] = "0";}
		else {$result_rm_ochtend = mysql_query("select schippers_id from schippers where voornaam = '$_GET[rm_ochtend]'");
		$row_rm_ochtend = mysql_fetch_array($result_rm_ochtend);}
		
		if ($_GET['rm_middag'] == "vrij"){$row_rm_middag['schippers_id'] = "0";}
		else {$result_rm_middag = mysql_query("select schippers_id from schippers where voornaam = '$_GET[rm_middag]'");
		$row_rm_middag = mysql_fetch_array($result_rm_middag);}
		
		if ($_GET['rm_avond'] == "vrij"){$row_rm_avond['schippers_id'] = "0";}
		else {$result_rm_avond = mysql_query("select schippers_id from schippers where voornaam = '$_GET[rm_avond]'");
		$row_rm_avond = mysql_fetch_array($result_rm_avond);}
		echo $_GET['opm_schip'];
		echo $_GET['opm_bestuur'];
		$query_verander = "UPDATE bootrooster SET valk_ochtend='$row_valk_ochtend[schippers_id]', valk_middag='$row_valk_middag[schippers_id]', valk_avond='$row_valk_avond[schippers_id]', rm_ochtend='$row_rm_ochtend[schippers_id]', rm_middag='$row_rm_middag[schippers_id]', rm_avond='$row_rm_avond[schippers_id]', opm_schip='$_GET[opm_schip]', opm_bestuur='$_GET[opm_bestuur]' WHERE id='$_GET[id]'";
		$result_verander = mysql_query($query_verander);
		echo "<script language='javascript'>";
		echo "window.location = '".$_server['php_self']."?";
		if(isset($_GET['doe_na'])){ echo "doe=".$_GET['doe_na'];} 
		if(isset($_GET['dag_maand'])){echo"&dag_maand=".$_GET['dag_maand'];} 
		if (isset($_GET['schipper'])){echo"&schipper=".$_GET['schipper'];}  
		if(isset($_GET['maand'])){echo"&maand=".$_GET['maand'];} 
		if (isset($_GET['dag'])){echo"&dag=".$_GET['dag'];} 
		if(isset($_GET['hoe'])){echo"&hoe=".$_GET['hoe'];}
		echo"'";		
		echo "</script>";

  break;
  default:
		$vandaag = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d"),date("Y")));
		$gister = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")-1,date("Y")));
		$eergister = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")-2,date("Y")));
		$morgen = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")+1,date("Y")));
		$overmorgen = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")+2,date("Y")));
		
		if ($_GET['alles'] != "alles"){
		$query = "SELECT * FROM $tabel_bootrooster where datum='$vandaag' or datum='$morgen' or datum='$overmorgen' or datum='$gister' or datum='$eergister'"
			or die("query");}
		elseif ($_GET['alles'] == "alles"){
		$query = "SELECT * FROM $tabel_bootrooster";}
		$result = mysql_query($query)
		or die("result");
		
   
		$query_schippers = "SELECT schippers_id, voornaam FROM $tabel_schippers"
			or die("query_schippers");
		$result_schippers = mysql_query($query_schippers)
			or die("result_schippers");
		head();
		if (@$_GET['show'] == "select")
		{
			
		while($row = mysql_fetch_array($result)) 
			{
			if ($row['id'] < $_GET['id'])
				{show_normaal($row);}
			elseif ($row['id'] == $_GET['id'])
				{show_select($row, $result_schippers);}
			elseif ($row['id'] > $_GET['id'])
				{show_normaal($row);}
			}
		}
		else 
		{
		while($row = mysql_fetch_array($result)) 
			{
			show_normaal($row);
			}
		}
	break;
   }
	?>

iemand een iedee?
groet ecross
 
Er zijn heel veel dingen die anders/beter/sneller kunnen, maar het is eerst zaak dat je gaat monitoren waar het traag is. Gebruik microtime() op meerdere plaatsen in je script om te bereken hoe lang welk deel duurt.

PHP: 
$iStart = microtime();

// Code

$iEind = microtime();

$iVerschil = $iEind - $iStart;
// $iVerschil bevat het aantal milliseconden dat de uitvoer tussen de twee punten heeft geduurd.
 
dat is in seconden?
als ik iets wijzig tel ik zelf iets van 4 seconden en er staat: 0.068221

en na dat hij alles laat zien laat hij zien dat ie nog bezig is(draaiende dingetje) en na nog wat seconden komt dan de tijd die hij erover deed.

groet ecross
 
Laatst bewerkt:
Je moet wel even goed bekijken waar je het neer zet hè? Dus niet vlak onder elkaar, maar om een stuk code zoals SvU al aangaf.

Ook is het niet in seconden, maar in milliseconde (zoals SvU al aangaf).

Je kunt wel:

PHP: 
microtime ( getasfloat );

gebruiken, dan krijg je het in seconden (met een bende decimalen).
 
ik had ze neer gezet bij 285 (na de functie's) en aan het einde
nu bij regel 1 en met die getasfloat nu krijg ik bij veranderen: 0.11009812355
terwijl het echt wel minimaal een seconde duurt
 
Laatst bewerkt:
Vreemd, dat zou betekenen dat het heel lang duurt om de functies te initializeren??

Post anders je hele code eens met de microtime()'s. Misschien heb je toch een onvoorziene vergissing gemaakt.
 
alsje:

PHP: 
<?php
$iStart = microtime(getasfloat);
$database = "rooster";
$tabel_bootrooster = "bootrooster";
$tabel_schippers = "schippers";

function show_select($row, $result_schippers){
extract($row);

$query_boten = "SELECT * from bootrooster where id='$id'"
						 or die("query_boten");
$result_boten = mysql_query($query_boten)
							or die("result_boten");
$row_boten = mysql_fetch_array($result_boten)
					 	 or die("row_boten");
						 
$query_dag_week = "SELECT DAYNAME('$datum')";
$result_dag_week = mysql_query($query_dag_week);
$row_dag_week = mysql_fetch_array($result_dag_week);
			
echo "<form action='" . $_SERVER['PHP_SELF'] . "' method='GET'>";
echo "<input type='hidden' name='doe' value='verander'>";
echo "<input type='hidden' name='id' value='$id'>";
if ($_GET['alles'] == "alles"){echo "<input type='hidden' name='alles' value='alles'>";}
	
if (isset($_GET['doe'])){echo "<input type='hidden' name='doe_na' value='$_GET[doe]'>";}
if (isset($_GET['dag_maand'])){echo "<input type='hidden' name='dag_maand' value='$_GET[dag_maand]'>";}
if (isset($_GET['maand'])){echo "<input type='hidden' name='maand' value='$_GET[maand]'>";}
if (isset($_GET['hoe'])){echo "<input type='hidden' name='hoe' value='$_GET[hoe]'>";}
if (isset($_GET['dag'])){echo "<input type='hidden' name='dag' value='$_GET[dag]'>";}
if (isset($_GET['schipper'])){echo "<input type='hidden' name='schipper' value='$_GET[schipper]'>";}

echo '<tr>';
echo "<td>" . $datum . "</td>";
echo "<td>" . $row_dag_week['0'] . "</td>";

		mysql_data_seek ( $result_schippers, 0 );	
		echo "<td><select name='valk_ochtend'>";
		if ($row_boten['valk_ochtend'] == '0')
			{echo "<option selected>vrij</option>";}
		else
			{echo "<option>vrij</option>";}
		while ($row_schippers = mysql_fetch_array($result_schippers))
			{
			if ($row_schippers['schippers_id'] == $row_boten['valk_ochtend'])
				{echo "<option selected>" . $row_schippers['voornaam'] . "</option>";}
			else 
				{echo "<option>" . $row_schippers['voornaam'] . "</option>";}
			}
		echo "</select></td>";
		
		mysql_data_seek ( $result_schippers, 0 );
		echo "<td><select name='valk_middag'>";
		if ($row_boten['valk_middag'] == '0')
			{echo "<option selected>vrij</option>";}
		else
			{echo "<option>vrij</option>";}
		while ($row_schippers = mysql_fetch_array($result_schippers))
			{
			if ($row_schippers['schippers_id'] == $row_boten['valk_middag'])
				{echo "<option selected>" . $row_schippers['voornaam'] . "</option>";}
			else 
				{echo "<option>" . $row_schippers['voornaam'] . "</option>";}
			}
		echo "</select></td>";
		
		mysql_data_seek ( $result_schippers, 0 );
		echo "<td><select name='valk_avond'>";
		if ($row_boten['valk_avond'] == '0')
			{echo "<option selected>vrij</option>";}
		else
			{echo "<option>vrij</option>";}
		while ($row_schippers = mysql_fetch_array($result_schippers))
			{
			if ($row_schippers['schippers_id'] == $row_boten['valk_avond'])
				{echo "<option selected>" . $row_schippers['voornaam'] . "</option>";}
			else 
				{echo "<option>" . $row_schippers['voornaam'] . "</option>";}
			}
		echo "</select></td>";
		
		mysql_data_seek ( $result_schippers, 0 );
		echo "<td><select name='rm_ochtend'>";
		if ($row_boten['rm_ochtend'] == '0')
			{echo "<option selected>vrij</option>";}
		else
			{echo "<option>vrij</option>";}
		while ($row_schippers = mysql_fetch_array($result_schippers))
			{
			if ($row_schippers['schippers_id'] == $row_boten['rm_ochtend'])
				{echo "<option selected>" . $row_schippers['voornaam'] . "</option>";}
			else 
				{echo "<option>" . $row_schippers['voornaam'] . "</option>";}
			}
		echo "</select></td>";
		
		mysql_data_seek ( $result_schippers, 0 );
		echo "<td><select name='rm_middag'>";
		if ($row_boten['rm_middag'] == '0')
			{echo "<option selected>vrij</option>";}
			else
			{echo "<option>vrij</option>";}
		while ($row_schippers = mysql_fetch_array($result_schippers))
			{
			if ($row_schippers['schippers_id'] == $row_boten['rm_middag'])
				{echo "<option selected>" . $row_schippers['voornaam'] . "</option>";}
			else 
				{echo "<option>" . $row_schippers['voornaam'] . "</option>";}
			}
		echo "</select></td>";
		
		mysql_data_seek ( $result_schippers, 0 );
		echo "<td><select name='rm_avond'>";
		if ($row_boten['rm_avond'] == '0')
			{echo "<option selected>vrij</option>";}
		else
			{echo "<option>vrij</option>";}
		while ($row_schippers = mysql_fetch_array($result_schippers))
			{
			if ($row_schippers['schippers_id'] == $row_boten['rm_avond'])
				{echo "<option selected>" . $row_schippers['voornaam'] . "</option>";}
			else 
				{echo "<option>" . $row_schippers['voornaam'] . "</option>";}
			}
		
		echo "</select></td>";
		
		echo "<td><input type='text' id='lengte' value='$opm_schip' name='opm_schip'></td>";
		echo "<td><input type='text' id='lengte' value='$opm_bestuur' name='opm_bestuur'></td>";
		echo "<td><input type='submit' value='ok'></td>";
		echo "</form>";
}
######################################################################################################
function show_normaal($row){
extract($row);

$query_dag_week = "SELECT DAYNAME('$datum')";
$result_dag_week = mysql_query($query_dag_week);
$row_dag_week = mysql_fetch_array($result_dag_week);
			
echo "<form action='" . $_SERVER['PHP_SELF'] . "' method='GET'>";
echo "<input type='hidden' name='show' value='select'>";
echo "<input type='hidden' name='id' value='$id'>";

if (isset($_GET['doe'])){echo "<input type='hidden' name='doe' value='$_GET[doe]'>";}
if (isset($_GET['dag_maand'])){echo "<input type='hidden' name='dag_maand' value='$_GET[dag_maand]'>";}
if (isset($_GET['maand'])){echo "<input type='hidden' name='maand' value='$_GET[maand]'>";}
if (isset($_GET['hoe'])){echo "<input type='hidden' name='hoe' value='$_GET[hoe]'>";}
if (isset($_GET['dag'])){echo "<input type='hidden' name='dag' value='$_GET[dag]'>";}
if (isset($_GET['schipper'])){echo "<input type='hidden' name='schipper' value='$_GET[schipper]'>";}

if ($_GET['alles'] == "alles"){echo "<input type='hidden' name='alles' value='alles'>";}	
	if ($valk_ochtend == "0"){$valk_ochtend['voornaam'] = "vrij";}
	else {$valk_ochtend = mysql_query("select voornaam from schippers where schippers_id = '$valk_ochtend'");
	$valk_ochtend = mysql_fetch_array($valk_ochtend);}

	if ($valk_middag == "0"){$valk_middag['voornaam'] = "vrij";}
	else {$valk_middag = mysql_query("select voornaam from schippers where schippers_id = '$valk_middag'");
	$valk_middag = mysql_fetch_array($valk_middag);}
		
	if ($valk_avond == "0"){$valk_avond['voornaam'] = "vrij";}
	else {$valk_avond = mysql_query("select voornaam from schippers where schippers_id = '$valk_avond'");
	$valk_avond = mysql_fetch_array($valk_avond);}
		
	if ($rm_ochtend == "0"){$rm_ochtend['voornaam'] = "vrij";}
	else {$rm_ochtend = mysql_query("select voornaam from schippers where schippers_id = '$rm_ochtend'");
	$rm_ochtend = mysql_fetch_array($rm_ochtend);}
		
	if ($rm_middag == "0"){$rm_middag['voornaam'] = "vrij";}
	else {$rm_middag = mysql_query("select voornaam from schippers where schippers_id = '$rm_middag'");
	$rm_middag = mysql_fetch_array($rm_middag);}
	
	if ($rm_avond == "0"){$rm_avond['voornaam'] = "vrij";}
	else {$rm_avond = mysql_query("select voornaam from schippers where schippers_id = '$rm_avond'");
	$rm_avond = mysql_fetch_array($rm_avond);}

$vandaag = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d"),date("Y")));
$gister = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")-1,date("Y")));
$eergister = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")-2,date("Y")));
$morgen = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")+1,date("Y")));
$overmorgen = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")+2,date("Y")));
		
echo '<tr>';
echo "<td>" . $datum . "</td>";
echo "<td>" . $row_dag_week['0'] . "</td>";
echo "<td>" . $valk_ochtend['voornaam'] . "</td>";
echo "<td>" . $valk_middag['voornaam'] . "</td>";
echo "<td>" . $valk_avond['voornaam'] . "</td>";
echo "<td>" . $rm_ochtend['voornaam'] . "</td>";
echo "<td>" . $rm_middag['voornaam'] . "</td>";
echo "<td>" . $rm_avond['voornaam'] . "</td>";
echo "<td>" . $opm_schip . "</td>";
echo "<td>" . $opm_bestuur . "</td>";
echo "<td><input type='submit' value='wijzig'></td>";
echo '</tr>';
echo "</form>";
}
#######################################################################################################
function head(){
echo "<tr>";
echo "<td colspan='12' align='center'><b>botenrooster van Gooimeerzeilen</b><br>";
echo "<a href='" . $_SERVER['PHP_SELF'] . "'>toon vandaag</a></td>";
echo "</tr>";
echo "<tr>";

echo "<tr>
		<form action='" . $_SERVER['PHP_SELF'] . "' method='GET'>
		<input type='hidden' value='zoek' name='doe'>
		<input type='hidden' value='exact' name='hoe'>
		<tr>
		<td align='center'>zoek op exacte datum</td>
		<td align='center'>zoek op dag</td>
		<td align='center'>zoek op schipper</td>
		<td colspan='10' rowspan='2' align='center'>de kolom opm_schippers wordt ook zichtbaar voor de schippers.</td>
		</tr>
		<tr>
		<td align='center'><select name='dag_maand' value='$_GET[dag_maand]'>";
		$dag = date("d");
		
		for ($i = 1; $i <= 31; $i++) {
		if ($i == $_GET['dag_maand']){echo "<option selected>" . $i . "</option>";}
		elseif ($i == $dag){echo "<option selected>" . $i . "</option>";}
		else{echo "<option>" . $i . "</option>";}
		}
  echo "</select>
		<select name='maand'>";
		$maand = date("M");
		$month_names = array('Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec');
		foreach($month_names as $key => $value){
		if ($value == $_GET['maand']){echo "<option selected>".$value."</option>";}
		elseif ($value == $maand){echo "<option selected>".$value."</option>";}
		else {echo "<option>$value</option>";}}

  echo "</select>
		<input type='submit' value='zoek'></td>
		</form>
		
		<form action='" . $_SERVER['PHP_SELF'] . "' method='GET'>
		<input type='hidden' value='zoek' name='doe'>
		<input type='hidden' value='dag_week' name='hoe'>
		
		<td align='center'><select name='dag'>";
		$dag = date("D");
		$day_translate = array("Mon"=>"Monday", "Tue"=>"Tuesday", "Wed"=>"Wednesday", "Fri"=>"Friday", "Sat"=>"Saturday", "Sun"=>"Sunday");
		foreach($day_translate as $key => $value){
		if ($dag == $key){$dag = $value;}}
		
		$day_names = array(1=>'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday');
		foreach($day_names as $key => $value){
		if ($value == $_GET['dag']){echo "<option selected>".$value."</option>"; $t="1";}
		elseif ($value == $dag and $t != "1"){echo "<option selected>".$value."</option>";}
		else {echo "<option>".$value."</option>";}}
  echo "</select>
		<input type='submit' value='zoek'></td>
		
		</form>
		<form action='" . $_SERVER['PHP_SELF'] . "' method='GET'>
		<input type='hidden' value='zoek' name='doe'>
		<input type='hidden' value='schipper' name='hoe'>
		
		<td align='center'><select name='schipper'>";
		$query = "select voornaam from schippers";
		$result = mysql_query($query);
		while ($row = mysql_fetch_array($result)){
		if ($row['voornaam'] == $_GET['schipper']){echo "<option selected>".$row['voornaam']."</option>";}
		else {echo "<option>".$row['voornaam']."</option>";}}
	echo "</select>
		<input type='submit' value='zoek'></td>
		
		
		</tr>
		</form>";
echo "<td>datum<td>dag_week<td>valk_ochtend<td>valk_middag<td>valk_avond<td>rm_ochtend<td>rm_middag<td>rm_avond<td>opm_schip<td>opm_bestuur<td>wijzig";
echo "</tr>";			
}
?>
<html>
<head><title>Member</title></head>
</html>
<style type="text/css"> 

input#lengte {
	width:  5em;
	  }
</style>
<?php

 

$user="master";
$host="localhost";
$password="gmzmaster6";

$connection = mysql_connect($host,$user,$password)
       or die ("couldn't connect to server");
$db = mysql_select_db($database,$connection)
		or die ("Couldn't select database");


echo "<table border='1' align='center'>";
switch (@$_GET['doe'])
  {
  case "zoek":
		if ($_GET['hoe'] == "exact")
			{
			    if ($_GET['maand'] == "Jan"){$maand = "01";}
			elseif ($_GET['maand'] == "Feb"){$maand = "02";}
			elseif ($_GET['maand'] == "Mar"){$maand = "03";}
			elseif ($_GET['maand'] == "Apr"){$maand = "04";}
			elseif ($_GET['maand'] == "May"){$maand = "05";}
			elseif ($_GET['maand'] == "Jun"){$maand = "06";}
			elseif ($_GET['maand'] == "Jul"){$maand = "07";}
			elseif ($_GET['maand'] == "Aug"){$maand = "08";}
			elseif ($_GET['maand'] == "Sep"){$maand = "09";}
			elseif ($_GET['maand'] == "Oct"){$maand = "10";}
			elseif ($_GET['maand'] == "Nov"){$maand = "11";}
			elseif ($_GET['maand'] == "Dec"){$maand = "12";}
			
				$datum = "2009-" . $maand . "-" . $_GET['dag_maand'];
				$query = "select * from $tabel_bootrooster where datum = '$datum'";
				$result = mysql_query($query);
				
				head();
				
				$query_schippers = "SELECT schippers_id, voornaam FROM $tabel_schippers"
					or die("query_schippers");
				$result_schippers = mysql_query($query_schippers)
					or die("result_schippers");
				
				if (@$_GET['show'] == "select")
				{
				while($row = mysql_fetch_array($result)) 
					{
					if ($row['id'] < $_GET['id'])
						{show_normaal($row);}
					elseif ($row['id'] == $_GET['id'])
						{show_select($row, $result_schippers);}
					elseif ($row['id'] > $_GET['id'])
						{show_normaal($row);}
					}
				}
				else 
				{
				while($row = mysql_fetch_array($result)) 
					{
					show_normaal($row);
					}
				}
				

			}
		elseif ($_GET['hoe'] == "dag_week")
			{
			head();

			$query = "select * from bootrooster"
				or die("298");
			$result = mysql_query($query)
				or die("wrong2");

			$query_schippers = "SELECT schippers_id, voornaam FROM $tabel_schippers"
				or die("query_schippers");
			$result_schippers = mysql_query($query_schippers)
				or die("result_schippers");
				if (@$_GET['show'] == "select")
				{
				while($row = mysql_fetch_array($result)) 
					{
					extract($row);
					$query_dagweek = "SELECT DAYNAME('$datum')";
					$result_dagweek = mysql_query($query_dagweek);
					$row_dagweek = mysql_fetch_array($result_dagweek);
					if ($row_dagweek['0'] == $_GET['dag'])
						{
						if ($row['id'] < $_GET['id'])
							{show_normaal($row);}
						elseif ($row['id'] == $_GET['id'])
							{show_select($row, $result_schippers);}
						elseif ($row['id'] > $_GET['id'])
							{show_normaal($row);}
						}
					}
				}
				else 
				{
				while($row = mysql_fetch_array($result)) 
					{
					extract($row);
					$query_dagweek = "SELECT DAYNAME('$datum')";
					$result_dagweek = mysql_query($query_dagweek);
					$row_dagweek = mysql_fetch_array($result_dagweek);
					if ($row_dagweek['0'] == $_GET['dag'])
						{show_normaal($row);}
					}
				}
			}
		elseif ($_GET['hoe'] == "schipper")
			{
			if ($_GET['schipper'] == "vrij"){$schipper['voornaam'] = "0";}
			else {$schipper = mysql_query("select schippers_id from schippers where voornaam = '$_GET[schipper]'");
			$schipper = mysql_fetch_array($schipper);}
			
			$query = "select * from bootrooster where valk_ochtend='$schipper[schippers_id]' or valk_middag='$schipper[schippers_id]' or valk_avond='$schipper[schippers_id]' or rm_ochtend='$schipper[schippers_id]' or rm_middag='$schipper[schippers_id]' or rm_avond='$schipper[schippers_id]'";
			$result = mysql_query($query);
			head();
			$query_schippers = "SELECT schippers_id, voornaam FROM $tabel_schippers"
					or die("query_schippers");
			$result_schippers = mysql_query($query_schippers)
					or die("result_schippers");
					
			if (@$_GET['show'] == "select")
				{
				while($row = mysql_fetch_array($result)) 
					{
					if ($row['id'] < $_GET['id'])
						{show_normaal($row);}
					elseif ($row['id'] == $_GET['id'])
						{show_select($row, $result_schippers);}
					elseif ($row['id'] > $_GET['id'])
						{show_normaal($row);}
					}
				}
			else 
				{
				while($row = mysql_fetch_array($result)) 
					{
					show_normaal($row);
					}
				}
			}
  break;
  case "verander":

		if ($_GET['valk_ochtend'] == "vrij"){$row_valk_ochtend['schippers_id'] = "0";}
		else{$result_valk_ochtend = mysql_query("select schippers_id from schippers where voornaam = '$_GET[valk_ochtend]'");
		$row_valk_ochtend = mysql_fetch_array($result_valk_ochtend);}
		
		if ($_GET['valk_middag'] == "vrij"){$row_valk_middag['schippers_id'] = "0";}
		else {$result_valk_middag = mysql_query("select schippers_id from schippers where voornaam = '$_GET[valk_middag]'");
		$row_valk_middag = mysql_fetch_array($result_valk_middag);}
		
		if ($_GET['valk_avond'] == "vrij"){$row_valk_avond['schippers_id'] = "0";}
		else {$result_valk_avond = mysql_query("select schippers_id from schippers where voornaam = '$_GET[valk_avond]'");
		$row_valk_avond = mysql_fetch_array($result_valk_avond);}
		
		if ($_GET['rm_ochtend'] == "vrij"){$row_rm_ochtend['schippers_id'] = "0";}
		else {$result_rm_ochtend = mysql_query("select schippers_id from schippers where voornaam = '$_GET[rm_ochtend]'");
		$row_rm_ochtend = mysql_fetch_array($result_rm_ochtend);}
		
		if ($_GET['rm_middag'] == "vrij"){$row_rm_middag['schippers_id'] = "0";}
		else {$result_rm_middag = mysql_query("select schippers_id from schippers where voornaam = '$_GET[rm_middag]'");
		$row_rm_middag = mysql_fetch_array($result_rm_middag);}
		
		if ($_GET['rm_avond'] == "vrij"){$row_rm_avond['schippers_id'] = "0";}
		else {$result_rm_avond = mysql_query("select schippers_id from schippers where voornaam = '$_GET[rm_avond]'");
		$row_rm_avond = mysql_fetch_array($result_rm_avond);}
		$query_verander = "UPDATE bootrooster SET valk_ochtend='$row_valk_ochtend[schippers_id]', valk_middag='$row_valk_middag[schippers_id]', valk_avond='$row_valk_avond[schippers_id]', rm_ochtend='$row_rm_ochtend[schippers_id]', rm_middag='$row_rm_middag[schippers_id]', rm_avond='$row_rm_avond[schippers_id]', opm_schip='$_GET[opm_schip]', opm_bestuur='$_GET[opm_bestuur]' WHERE id='$_GET[id]'";
		$result_verander = mysql_query($query_verander);
		echo "<script language='javascript'>";
		echo "window.location = '".$_server['php_self']."?";
		if(isset($_GET['doe_na'])){ echo "doe=".$_GET['doe_na'];} 
		if(isset($_GET['dag_maand'])){echo"&dag_maand=".$_GET['dag_maand'];} 
		if (isset($_GET['schipper'])){echo"&schipper=".$_GET['schipper'];}  
		if(isset($_GET['maand'])){echo"&maand=".$_GET['maand'];} 
		if (isset($_GET['dag'])){echo"&dag=".$_GET['dag'];} 
		if(isset($_GET['hoe'])){echo"&hoe=".$_GET['hoe'];}
		echo"'";		
		echo "</script>";

  break;
  default:
		$vandaag = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d"),date("Y")));
		$gister = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")-1,date("Y")));
		$eergister = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")-2,date("Y")));
		$morgen = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")+1,date("Y")));
		$overmorgen = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")+2,date("Y")));
		
		if ($_GET['alles'] != "alles"){
		$query = "SELECT * FROM $tabel_bootrooster where datum='$vandaag' or datum='$morgen' or datum='$overmorgen' or datum='$gister' or datum='$eergister'"
			or die("query");}
		elseif ($_GET['alles'] == "alles"){
		$query = "SELECT * FROM $tabel_bootrooster";}
		$result = mysql_query($query)
		or die("result");
		
   
		$query_schippers = "SELECT schippers_id, voornaam FROM $tabel_schippers"
			or die("query_schippers");
		$result_schippers = mysql_query($query_schippers)
			or die("result_schippers");
		head();
		if (@$_GET['show'] == "select")
		{
			
		while($row = mysql_fetch_array($result)) 
			{
			if ($row['id'] < $_GET['id'])
				{show_normaal($row);}
			elseif ($row['id'] == $_GET['id'])
				{show_select($row, $result_schippers);}
			elseif ($row['id'] > $_GET['id'])
				{show_normaal($row);}
			}
		}
		else 
		{
		while($row = mysql_fetch_array($result)) 
			{
			show_normaal($row);
			}
		}
	break;
   }
    
$iEind = microtime("getasfloat");
 
$iVerschil = $iEind - $iStart;
echo $iVerschil;
	?>
 
Je doet nu precies wat ik zei dat je niet moest doen, het alleen boven- en onderaan neerzetten. Plaats het op meerdere plekken in je code om te zien waar de bottleneck zit.
 
Oh ja, het moest trouwens

PHP: 
microtime ( true );

zijn. Slordig van me.
 
ik wou eerst even testen hoelang alles er overdoet dit lijkt niet te werken
ik heb nu ook het zelfde (met andere variablenaam) om de functies gezet
resultaat: 4.60147857666E-5

wat is E-5 ?
 
Ik weet het niet. Heb je de tip van SvU opgevolgd?

Je moet het ongeveer zo doen:

PHP: 
<?php
$iTime = microtime ( true );

/* Heel veel code ;) */

echo 'Blok 1 duurde: ', ( microtime( true ) - $iTime ), ' seconden<br />';

$iTime = microtime( true );

/* Weer heel veel code ;) */

echo 'Blok 2 duurde: ', ( microtime( true ) - $iTime ), ' seconden<br />';

$iTime = microtime( true );

/* Nog eens heel veel code ;) */

echo 'Blok 3 duurde: ', ( microtime( true ) - $iTime ), ' seconden<br />';

?>
 
ik gebruik een switch dus hij gebruikt maar 1 van de cases is het dan zinvol om bij elke case een tijd test te maken?

uitslag:

functies=4.50611114502E-5
switch=0.0397188663483
totaal=0.039979934692
 
Laatst bewerkt:
Nee, je hoeft niet voor elke case een duratie vast te leggen. Maar lijkt het ongeveer te kloppen dan, dat het script er ongeveer 0.1s over doet?
 
nee eerder 3 seconden, met 0.1 seconden zou ik wel tevreden zijn!
 
Dit vind ik maar vreemd, ik kan zo niet zeggen waar het aan ligt.
 
dit is het waarschijnlijk:

als je iets laat veranderen is het eerst $_GET['doe'] = "verander"
en $_Get['doe_na'] = wat eerst doe was
na het veranderen word je door gestuur naar wat het eerst was $_GET['doe'] = $_Get['doe_na']

hij laat alleen de tijd zien na het doorsturen na het veranden,
de tijd van het veranderen kun je dus niet zien.

uitslag:
verandertijd=0.0242488384247
 
Laatst bewerkt:
heeft misschien iemand een iedee om dit te versnellen?
 
Welke browser ben je aan het gebruiken?
Als je Firefox hebt, raad ik je aan om eens de add-on FireBug te installeren, en dan naar de net-tab te gaan. Daarin krijg je goed te zien wat de laadtijd van elk onderdeel van je pagina is, alsook rendertijd.
Het lijkt me namelijk dat als je script duidelijk snel uitgevoerd wordt (binnen enkele milliseconden), de traagheid zit in de overdracht van server naar je browser en het evt renderen van het resultaat.
 
Status
Niet open voor verdere reacties.
                    Steun ons                    

Nieuwste berichten

Terug
Bovenaan Onderaan