Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

PostgreSQL Equivalent of mysql_unbuffered_query

 
   Database Help (Home) -> PHP RSS
Next:  Extracting Databoss data  
Author Message
Roberto

External


Since: Jan 27, 2008
Posts: 3



(Msg. 1) Posted: Thu Oct 09, 2008 10:31 am
Post subject: PostgreSQL Equivalent of mysql_unbuffered_query
Archived from groups: comp>lang>php (more info?)

Is there such a thing as the equivalent of a mysql_unbuffered_query
for PostgreSQL for doing fast inserts, updates, and deletes (one
liners, not bulk) in cases where you don't care about the outcome
immediately? (Such as deleting a user account from a users table.)

All I could find was pg_send_query, but:

(a) You must check to see if the connection is busy with
pg_connection_busy before sending stuff or you could lose your data
that you're sending or error out.

(b) You must call pg_get_result() after sending the query and before
sending your next query or you could end up getting an error or losing
that next data you are trying to write.

Seems to me that if I have to make two extra API calls and a while
loop on pg_connection_busy with a counter failsafe just to use
pg_send_query, then it's not going to give me the performance boost
that I'm looking for.

 >> Stay informed about: PostgreSQL Equivalent of mysql_unbuffered_query 
Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> PHP All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]