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: (view raw, whole thread or download thread mbox)
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, but it didn't apply to adodb. 
in the example, begin and commit were transmitted to
the db via the the pg_query function.


Do you Yahoo!? 
Make Yahoo! your home page

In response to


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-2017 The PostgreSQL Global Development Group