Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 1.5.0b4

Request #6807 PgSQL Async Query
Submitted: 2006-02-17 10:22 UTC
From: thomas at ecommerce dot com Assigned:
Status: Closed Package: MDB2_Driver_pgsql (version 1.7.6)
PHP Version: Irrelevant OS: SuSE 10.0
Roadmaps: (Not assigned)    
Subscription  


 [2006-02-17 10:22 UTC] thomas at ecommerce dot com
Description: ------------ PostgreSQL is Supporting Asyncron Query execution. http://de.php.net/manual/en/function.pg-send-query.php Please implement such methods, to send querys async as thay can be very usfull. Test script: --------------- /* Example script how it can looks like */ $db = ( connected DB::PgSQL object ) //-- run query NOW ( with pg_Send_query() ) $db->queryAsync("SELECT * FROM TABLE"); while(1 != 2) { //-- do somthing here that will take some time //-- during this run, also PgSQL query gets executed } //-- enshure query is done ( using pg_connection_busy function ) if($db->isQueryRunning()) { //-- query still running, kill it $db->canelQuery(); } else { //-- query done, get results now $result = $db->getAllAsync(DB_FETCHMODE_ASSOC); /* there can be functions like getAssocAsync(), getColAsync(), ... Each function returning the last runned Async query. */ }

Comments

 [2006-02-25 12:18 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send
MANUAL CONFIRMATION IS NOT POSSIBLE.  Write a message to pear-dev@lists.php.net
to request the confirmation link.  All bugs/comments/patches associated with this

email address will be deleted within 48 hours if the account request is not confirmed!
 [2006-03-03 15:53 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send
MANUAL CONFIRMATION IS NOT POSSIBLE.  Write a message to pear-dev@lists.php.net
to request the confirmation link.  All bugs/comments/patches associated with this

email address will be deleted within 48 hours if the account request is not confirmed!
 [2006-03-07 17:43 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send
MANUAL CONFIRMATION IS NOT POSSIBLE.  Write a message to pear-dev@lists.php.net
to request the confirmation link.  All bugs/comments/patches associated with this

email address will be deleted within 48 hours if the account request is not confirmed!