Thread: Do an Update without waiting for the result
Hi, I'm looking for the "pg_exec", i want to do a query (update or insert) without waiting for the result (true or false) of the query. Is there anyone know how do it ? system : postgres on linux RedHat, PHP4 LP.
Just to clarify what you mean. Say you do an insert that takes 20 minutes, you want to be able to do other stuff while it is running? Or are you just saying you don't care about the result? Adam Lang Systems Engineer Rutgers Casualty Insurance Company http://www.rutgersinsurance.com ----- Original Message ----- From: "Laurent Patureau" <lpatureau@idfr.net> To: <pgsql-php@postgresql.org> Sent: Thursday, June 21, 2001 5:42 AM Subject: [PHP] Do an Update without waiting for the result > Hi, > > I'm looking for the "pg_exec", > > i want to do a query (update or insert) without waiting for the result > (true or false) of the query. > > Is there anyone know how do it ? > > system : postgres on linux RedHat, PHP4 > > LP. > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly
At 09:07 21/06/01 -0400, Adam Lang wrote: Hi, I don't care about the result. My script is particular, I need to have the smallest time I can and my update take 0.1s. on 0.12s for my script. LP >Just to clarify what you mean. > >Say you do an insert that takes 20 minutes, you want to be able to do other >stuff while it is running? Or are you just saying you don't care about the >result? > >Adam Lang >Systems Engineer >Rutgers Casualty Insurance Company >http://www.rutgersinsurance.com >----- Original Message ----- >From: "Laurent Patureau" <lpatureau@idfr.net> >To: <pgsql-php@postgresql.org> >Sent: Thursday, June 21, 2001 5:42 AM >Subject: [PHP] Do an Update without waiting for the result > > >> Hi, >> >> I'm looking for the "pg_exec", >> >> i want to do a query (update or insert) without waiting for the result >> (true or false) of the query. >> >> Is there anyone know how do it ? >> >> system : postgres on linux RedHat, PHP4 >> >> LP. >> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 3: if posting/reading through Usenet, please send an appropriate >> subscribe-nomail command to majordomo@postgresql.org so that your >> message can get through to the mailing list cleanly > > >---------------------------(end of broadcast)--------------------------- >TIP 6: Have you searched our list archives? > >http://www.postgresql.org/search.mpl
That's a tough one... The only thing I can think of is to have a script/program outside of php to do your insert and call that from your php script. I don't think it will wait for a return code before it moves on to the rest of the code in the script. You are that positive your script will succeed everytime? Adam Lang Systems Engineer Rutgers Casualty Insurance Company http://www.rutgersinsurance.com ----- Original Message ----- From: "Laurent Patureau" <lpatureau@idfr.net> To: "pgsql-php" <pgsql-php@postgresql.org> Sent: Thursday, June 21, 2001 9:24 AM Subject: Re: [PHP] Do an Update without waiting for the result > At 09:07 21/06/01 -0400, Adam Lang wrote: > Hi, > > I don't care about the result. > My script is particular, I need to have the smallest time I can and my update take 0.1s. on 0.12s for my script. > > LP > > > >Just to clarify what you mean. > > > >Say you do an insert that takes 20 minutes, you want to be able to do other > >stuff while it is running? Or are you just saying you don't care about the > >result? > > > >Adam Lang > >Systems Engineer > >Rutgers Casualty Insurance Company > >http://www.rutgersinsurance.com > >----- Original Message ----- > >From: "Laurent Patureau" <lpatureau@idfr.net> > >To: <pgsql-php@postgresql.org> > >Sent: Thursday, June 21, 2001 5:42 AM > >Subject: [PHP] Do an Update without waiting for the result > > > > > >> Hi, > >> > >> I'm looking for the "pg_exec", > >> > >> i want to do a query (update or insert) without waiting for the result > >> (true or false) of the query. > >> > >> Is there anyone know how do it ? > >> > >> system : postgres on linux RedHat, PHP4 > >> > >> LP. > >> > >> > >> ---------------------------(end of broadcast)--------------------------- > >> TIP 3: if posting/reading through Usenet, please send an appropriate > >> subscribe-nomail command to majordomo@postgresql.org so that your > >> message can get through to the mailing list cleanly > > > > > >---------------------------(end of broadcast)--------------------------- > >TIP 6: Have you searched our list archives? > > > >http://www.postgresql.org/search.mpl > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
If you do that, you can also use PHP since it can also run as a standalone scripting language (not launched by the web server). Ciao --Louis <louis@bertrandtech.on.ca> On Thu, 21 Jun 2001, Adam Lang wrote: > That's a tough one... The only thing I can think of is to have a > script/program outside of php to do your insert and call that from your php > script. I don't think it will wait for a return code before it moves on to > the rest of the code in the script. > > You are that positive your script will succeed everytime? > > Adam Lang > Systems Engineer > Rutgers Casualty Insurance Company > http://www.rutgersinsurance.com > ----- Original Message ----- > From: "Laurent Patureau" <lpatureau@idfr.net> > To: "pgsql-php" <pgsql-php@postgresql.org> > Sent: Thursday, June 21, 2001 9:24 AM > Subject: Re: [PHP] Do an Update without waiting for the result > > > > At 09:07 21/06/01 -0400, Adam Lang wrote: > > Hi, > > > > I don't care about the result. > > My script is particular, I need to have the smallest time I can and my > update take 0.1s. on 0.12s for my script. > > > > LP > > > > > > >Just to clarify what you mean. > > > > > >Say you do an insert that takes 20 minutes, you want to be able to do > other > > >stuff while it is running? Or are you just saying you don't care about > the > > >result? > > > > > >Adam Lang > > >Systems Engineer > > >Rutgers Casualty Insurance Company > > >http://www.rutgersinsurance.com > > >----- Original Message ----- > > >From: "Laurent Patureau" <lpatureau@idfr.net> > > >To: <pgsql-php@postgresql.org> > > >Sent: Thursday, June 21, 2001 5:42 AM > > >Subject: [PHP] Do an Update without waiting for the result > > > > > > > > >> Hi, > > >> > > >> I'm looking for the "pg_exec", > > >> > > >> i want to do a query (update or insert) without waiting for the result > > >> (true or false) of the query. > > >> > > >> Is there anyone know how do it ? > > >> > > >> system : postgres on linux RedHat, PHP4 > > >> > > >> LP. > > >> > > >> > > >> ---------------------------(end of > broadcast)--------------------------- > > >> TIP 3: if posting/reading through Usenet, please send an appropriate > > >> subscribe-nomail command to majordomo@postgresql.org so that your > > >> message can get through to the mailing list cleanly > > > > > > > > >---------------------------(end of broadcast)--------------------------- > > >TIP 6: Have you searched our list archives? > > > > > >http://www.postgresql.org/search.mpl > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >