Re: Concurrent testing PostgreSQL Vs MySQL

Durai wrote:

> Hello Sridhar,
>
> Now, It works. Thanks lot.
>
> But Still I have doubt:
>
> 1. How MySQL works in this case? It has any default "autocommit"?

I am more worried what this test is testing at all and what MySQL
finally returns as a supposed to be correct result.

In particular, does the row after that test was running for some time
report the correct value? Looking at the test it should be the same
value the test started from.

Also, just as a side note, this sort of isolated, single table, single
row, as primitive a query as possible tests is usually the stuff where
MySQL beats PostgreSQL, so I wouldn't be surprised if one more "from
another world" test shows MySQL's strength over PostgreSQL.

Jan

>
> 2. Is there any other method to test for "concurrent testing"?
>
> Regs,
> Durai.
> ----- Original Message -----
> From: "Shridhar Daithankar" <shridhar_daithankar(at)myrealbox(dot)com>
> To: "Shridhar Daithankar" <shridhar_daithankar(at)myrealbox(dot)com>
> Cc: "Durai" <visolve_postgres(at)lycos(dot)co(dot)uk>; <pgsql-general(at)postgresql(dot)org>
> Sent: Friday, November 21, 2003 5:28 PM
> Subject: Re: [GENERAL] Concurrent testing PostgreSQL Vs MySQL
>
>
>> Damn.. I forgot to begin the transaction..
>>
>> Shridhar Daithankar wrote:
>> > Durai wrote:
>> >> Hello Shridhar,
>> >> The script content is:
>> >> ** *# cat te**stpgsql.php*
>> >> *
>> >> *<?php
>> >> $dbconn = pg_connect("host=172.16.1.158 port=5432 dbname=test
>> >> user=postgres");
>>
>> $result = pg_exec ($dbconn, "begin;");
>>
>> >> $result = pg_exec ($dbconn, "update table2 set C2=C2+1;");
>> >> $result = pg_exec ($dbconn, "update table2 set C2=C2-1;");
>> > $result = pg_exec ($dbconn, "commit;");
>> >> pg_close($dbconn);
>> >> ?>
>> >> #
>>
>> Check this..
>>
>> Shridhar
>>
>>
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.538 / Virus Database: 333 - Release Date: 11/11/2003
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #