SiT Tracking
Here is a sneak preview of my new PHP driven application:
This is early alpha phase of development, expect more pictures soon. ;]
Jul 17, 2006
Jul 7, 2006
MySQL vs PostgreSQL vs EnterpriseDB
in this test I used:
php 4.x
mysql 5.0.18
postgreSQL 8.0.3
EnterpriseDB 8.1.3.12
Results:
Using unixODBC + EnterpriseDB odbc drivers
+----------------+---------------+---------------+--------------+
|# of inserts |MySQL |EnterpriseDB |PostgreSQL |
+----------------+---------------+---------------+--------------+
|20.000 |6.32 sec |35.4 sec |27.2 |
|10.000 |3.11 sec |16.6 sec |14.0 |
|5.000 |1.51 sec |08.7 sec |06.1 |
|2.000 |0.62 sec |03.5 sec |02.2 |
|1.000 |0.34 sec |01.5 sec |01.1 |
+----------------+---------------+---------------+--------------+
As you can see, MySQL is aprox 5 timer faster than Pgsql, EnterpriseDB is tested
using unixODBC drivers, so that migh slow proces a little bit.
May 16, 2006
AJAX in 60 seconds with My-BIC and PHP
My-BIC os one of the simplest AJAX frameworks today.
After you download script all you need to do is to put mybic.js and mybic_server.php in some directory on your web server and you are ready to go.
Here is the simple example of getting time from the server with ajax.
First we create test.html file:
<html>
<head>
<title>AJAX TEST</title>
<script type="text/javascript" src="mybic.js"></script>
<script>
var ajaxObj = new XMLHTTP("mybic_server.php");
function get_time(){
ajaxObj.call('action=get_time', 'content');
}
</script>
</head>
<body>
<div onmouseover="get_time();"> Show me the time ! </div>
<div id="content"> </div>
</body>
</html>
Now when we have frontend, we need to create php file to do background job. Since our function and action are named get_time we must create php file with same name.
So we create get_time.php:
<?
class get_time
{
var $queryVars;
function get_time($queryVars)
{
$this->qv = $queryVars;
}
/**
* Method to return the status of the AJAX transaction
*
* @return string A string of raw HTML fetched from the Server
*/
function return_response()
{
$a=date("H:i:s D-M-Y", time());
return ($a);
}
function is_authorized()
{
return true;
}
}
?>
Now all you need to do is to go with your mouse cursor over "show me the time" text and My-BIC will return time vie innerHTML into content div.
More info on My-Bic homepage
http://www.litfuel.net/mybic/
May 15, 2006
Subscribe to:
Posts (Atom)
