Skip site navigation (1) Skip section navigation (2)

Re: Transactions

From: <operationsengineer1(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Transactions
Date: 2005-06-27 20:09:39
Message-ID: 20050627200939.22683.qmail@web33307.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
i have the following two queries i would like to run. 


$sql_product = 'SELECT product_id, product_number FROM
t_product ' .
'ORDER BY product_number ASC';

$sql_employee = 'SELECT employee_id, employee_name
FROM t_employee ORDER BY LOWER(employee_name) ASC';

$rs_product = $db->Execute($sql_product);
$rs_employee = $db->Execute($sql_employee);

i read somewhere that a transaction will speed up the
process b/c only one db
connection/hit/request/whatever is made (i may have
said it wrong, but hopefully you get the meaning)
instead of two.

how do i implement the BEGIN and COMMIT in php?  i saw
an example on php.net, but it didn't apply to adodb. 
in the example, begin and commit were transmitted to
the db via the the pg_query function.

tia...


		
__________________________________ 
Do you Yahoo!? 
Make Yahoo! your home page 
http://www.yahoo.com/r/hs

In response to

Responses

pgsql-novice by date

Next:From: Michael GlaesemannDate: 2005-06-27 20:41:07
Subject: Re: PostGis Extension
Previous:From: Joel da SilvaDate: 2005-06-27 20:08:14
Subject: PostGis Extension

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group