Hi,
does anyone know if there is a way to control the number of records read by PHP when using the unified ODBC calls to fetch records from a result set ?
The problem we see is this: when a long result set is retrieved, we see that the server fetches it fast enogh, but then the processing by PHP takes a long time. We are not really sure about this, but our guess is that the fetching of records from the result set is done one record at a time, using a cursor. This could be optimized by using a larger buffer into which larger chunks of records would be read.
Any help would be appreciated.
Yaron Yogev
does anyone know if there is a way to control the number of records read by PHP when using the unified ODBC calls to fetch records from a result set ?
The problem we see is this: when a long result set is retrieved, we see that the server fetches it fast enogh, but then the processing by PHP takes a long time. We are not really sure about this, but our guess is that the fetching of records from the result set is done one record at a time, using a cursor. This could be optimized by using a larger buffer into which larger chunks of records would be read.
Any help would be appreciated.
Yaron Yogev