pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Do an Update without waiting for the result
5+ messages / 3 participants
[nested] [flat]

* Do an Update without waiting for the result
@ 2001-06-21 09:42  Laurent Patureau <lpatureau@idfr.net>
  0 siblings, 2 replies; 5+ messages in thread

From: Laurent Patureau @ 2001-06-21 09:42 UTC (permalink / raw)
  To: pgsql-php

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.




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Do an Update without waiting for the result
@ 2001-06-21 13:07  Adam Lang <aalang@rutgersinsurance.com>
  parent: Laurent Patureau <lpatureau@idfr.net>
  1 sibling, 0 replies; 5+ messages in thread

From: Adam Lang @ 2001-06-21 13:07 UTC (permalink / raw)
  To: pgsql-php

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




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Do an Update without waiting for the result
@ 2001-06-21 13:24  Laurent Patureau <lpatureau@idfr.net>
  parent: Laurent Patureau <lpatureau@idfr.net>
  1 sibling, 1 reply; 5+ messages in thread

From: Laurent Patureau @ 2001-06-21 13:24 UTC (permalink / raw)
  To: pgsql-php

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




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Do an Update without waiting for the result
@ 2001-06-21 20:03  Adam Lang <aalang@rutgersinsurance.com>
  parent: Laurent Patureau <lpatureau@idfr.net>
  0 siblings, 1 reply; 5+ messages in thread

From: Adam Lang @ 2001-06-21 20:03 UTC (permalink / raw)
  To: pgsql-php

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




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Do an Update without waiting for the result
@ 2001-06-23 02:50  Louis Bertrand <louis@bertrandtech.on.ca>
  parent: Adam Lang <aalang@rutgersinsurance.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Louis Bertrand @ 2001-06-23 02:50 UTC (permalink / raw)
  To: pgsql-php

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
> 




^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2001-06-23 02:50 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-06-21 09:42 Do an Update without waiting for the result Laurent Patureau <lpatureau@idfr.net>
2001-06-21 13:07 ` Adam Lang <aalang@rutgersinsurance.com>
2001-06-21 13:24 ` Laurent Patureau <lpatureau@idfr.net>
2001-06-21 20:03   ` Adam Lang <aalang@rutgersinsurance.com>
2001-06-23 02:50     ` Louis Bertrand <louis@bertrandtech.on.ca>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox