php sql synchronous wait

Question

I'm relatively new to web programming. I hope this one is easy. I've got a server app running that's monitoring a SQL table. Whenever an integer field turns positive, the app reads the rest of the row and fills in a long text field in the same record. I've now got a php script that sets the int field, and needs to wait until the app sets the field back to zero and then read the text field and echo it back to the remote user. I tried this (odbc):

$processed = 0;
while ( !$processed )
    {
    $rs = odbc_exec( $conn, $sql );
    odbc_fetch_row($rs);
    $processed = odbc_result( $rs, "Processed");
    $output = odbc_result( $rs,"OutputSpec");
    }

I takes about 5 sec. to finish. Too slow. I put a counter in and it takes ~10000 iterations for 'processed' to change. I know my server app changes the field instantaneously. Similar result in the SqlServer. There must be something delaying the commit or something?

Web development, in my experience, is far more passive. At least the database layer is. I've never had to "listen" to a database table like this. All of that traffic to the database (fetching rows) seems like sledgehammering. There must be a better way. — Stephen
– Stephen, Commented Dec 16, 2010 at 4:17

Bnjmn · Accepted Answer · 2010-12-16 04:18:20Z

2

you need to use the observer pattern

use a known action to trigger an update.

Here are some PHP implementation details

answered Dec 16, 2010 at 4:18

Bnjmn

2,0091 gold badge21 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

php sql synchronous wait

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related