<!doctype html public "-//W3C//DTD HTML 4.0 //EN"> 
<html>
<head>
       <title>Title here!</title>
</head>
<body>
    <?php
        $resource = pg_connect("user=dorwardv dbname=OSSOutputDB1 host=localhost");
        if ($resource)
        {

//code to create the table
//            pg_exec($resource,"CREATE TABLE CUSTINFO( userid serial primary key, FormatVersion varchar(3), password text, EWId char, GCCode char(8), OffNameKanji varchar(128), OffNameRomaji varchar(128), DSLAMPortNumber integer, CustomerCode char(8), DSLAMOffice integer, userNameKanji varchar(64), MDFNumber varchar(8), ISPName char(128), ContextName char(128), IntProAddMethod char, IPAddress varchar(15), NextHop varchar(15),UpStreamSpeed varchar(4), DOWNStreamSpeed varchar(4), MaintenanceDivision char, QOS char, SlotNumber varchar(2), POrtNumberInSlot varchar(2), CertificationFlag char);");

//code to insert records
            $starttime=time();
            echo "inserting record starts at $starttime";
            $i=0;
            for(;$i<2000000;$i++)
            {
                pg_exec($resource,"INSERT INTO custinfo(formatversion,password,ewid,gccode,offnamekanji,offnameromaji,DSLAMPortNumber,customercode,DSLAMOffice,usernamekanji,mdfnumber,ispname,contextname,intproaddmethod,ipaddress,nexthop,upstreamspeed,downstreamspeed,maintenancedivision,qos,slotnumber,portnumberinslot,certificationflag) values('FMT','hello there','E','GCCCODE8','kanji','romaji',2000,'cust1234',3000,'usernamekanji','mdfnumber','ispname','contextname','1','172.28.61.4','172.28.61.4','1234','1234','1','2','12','21','F');");
            }
            $endtime=time();
            $totaltime = $endtime - $starttime;
            echo "writing is ends at $endtime";
            echo "time consumed is $totaltime seconds";

        }
    ?>
</body>
</html>

