As of PHP 4.0.6, the default maximum number of result sets for Frontbase is 128. When your PHP script finishes or is terminated, the result sets are NOT cleaned up as stated above (or at least Frontbase is not aware that the result sets have been destroyed). Therefore, you need to make sure you call fbsql_free_result() after every SELECT, or you will hit the default 128 set limit in a hurry.
Hopefully a future version of PHP will improve the result set cleanup so that the result set limitation doesn't rear its ugly head in the middle of a script.
fbsql_free_result
说明
bool fbsql_free_result ( resource result )fbsql_free_result() will free all memory associated with the result identifier result.
fbsql_free_result() only needs to be called if you are concerned about how much memory is being used for queries that return large result sets. All associated result memory is automatically freed at the end of the script's execution.
add a note
User Contributed Notes
mneugebauer at omaha dot com
09-Mar-2002 02:21
09-Mar-2002 02:21