I think pipeline may be a good solution. How can I use it? tks again and sorry for the inconvenience.
>From: "Jeroen T. Vermeulen" <[EMAIL PROTECTED]> >To: "Luis Silva" <[EMAIL PROTECTED]> >CC: [email protected] >Subject: Re: [libpqxx-general] transaction >Date: Fri, 6 Jan 2006 18:12:32 +0700 (ICT) > >On Fri, January 6, 2006 16:44, Luis Silva wrote: > > The problem is that if you do this you'll access the database twice. I'm > > trying to do what you told me but only with one access. tks a lot > >You could use a pipeline to reduce that effect. Pump in queries on one >end, and read results out the other. One extreme case is to make the >pipeline retain as many queries as you have, insert all queries, and then >start reading results until you encouter an empty one; the other extreme >is just to insert the next query before reading the result of the last >one. The optimal may lie somewhere in between, and depend on the queries, >whether the database is local or remote, system configuration, etc. > > >Jeroen > > _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ _______________________________________________ Libpqxx-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/libpqxx-general
