DROP TABLE IF EXISTS TTest;
CREATE TABLE TTest (
    id BIGINT NOT NULL auto_increment	, 
	p1 BIGINT NOT NULL DEFAULT  0 , 
	p2 CHAR ( 254 ) NOT NULL DEFAULT ''		, 
	p3 CHAR ( 254 ) NOT NULL DEFAULT ''		, 
	p4 CHAR ( 254 ) NOT NULL DEFAULT ''		,
	p5 SMALLINT NOT NULL DEFAULT  0 		, 
	PRIMARY KEY(id) 
);

   
delimiter //

DROP PROCEDURE IF EXISTS SaveTest;
//

CREATE PROCEDURE SaveTest( IN pp0 BIGINT, IN pp1 BIGINT , IN pp2 CHAR( 254 ) ,IN pp3 CHAR( 254 ) , IN pp4 CHAR( 254 ) , IN pp5 BIGINT )
LANGUAGE SQL
BEGIN

IF pp0 IS NULL THEN SET pp0 =  0 ; END IF; 
IF pp1 IS NULL THEN SET pp1 =  0 ; END IF; 	   
IF pp2 IS NULL THEN SET pp2 = ''; END IF;  	   
IF pp3 IS NULL THEN SET pp3 = ''; END IF;  	   
IF pp4 IS NULL THEN SET pp4 = ''; END IF;  	   
IF pp5 IS NULL THEN SET pp5 =  0 ; END IF; 

SELECT id INTO @return_id
FROM TTest
WHERE p1 = pp1 AND
p2 = pp2 AND
p3 = pp3 AND
p4 = pp4 AND
p5 = pp5
LIMIT  1 ;

IF @return_id IS NULL THEN

INSERT INTO TTest (p1,p2,p3,p4,p5)
VALUES (pp1,pp2,pp3,pp4,pp5);

SET @return_id=LAST_INSERT_ID();

END IF;


END;
//

<?
$ttt = time();

$t = time();
$link = mysql_connect("127.0.0.1", "SYSADMIN", "")
    or die("Could not connect : " . mysql_error());
echo "Connected successfully";
mysql_select_db("TEMPLATE") or die("Could not select database");

$t = ((time()-$t));
echo '<hr>'.$t.'<hr>';

$r = array();
$t = time();
for($i =  0 ; $i <  10 ; $i++){

	$query = "CALL SaveTest(1,1,\"".rand().time()."\",\"\",\"\",1);";
	$result = mysql_query($query) or die("Query failed : " . mysql_error());
	$query = "SELECT IF(@return_id=0,LAST_INSERT_ID(),@return_id);";
	$result = mysql_query($query) or die("Query failed : " . mysql_error());
	$r[$i] = mysql_result($result,  0 );
	mysql_free_result($result);
	
}

$t = ((time()-$t));

echo '<hr>'.$t.'<hr>';

print_r($r);

$t = time();

$query = "SELECT COUNT(*) FROM TTest";
$result = mysql_query($query) or die("Query failed : " . mysql_error());

echo "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
    echo "\t<tr>\n";
    foreach ($line as $col_value) {
        echo "\t\t<td>$col_value</td>\n";
    }
    echo "\t</tr>\n";
}
echo "</table>\n";

mysql_free_result($result);
$t = ((time()-$t));


echo '<hr>'.$t.'<hr>';


mysql_close($link);

echo '<hr>'.((time()-$ttt)).'<hr>';
?>