If HAVE_SQL_EXTENDED_FETCH is defined, then the odbc ext will use the ODBC API function SQLExtendedFetch instead of SQLFetch to retrieve records. SQLExtendedFetch is only necessary if a forward-only cursor is not being used. In the case of the odbc ext, it uses a dynamic cursor if HAVE_SQL_EXTENDED_FETCH is defined. The problem is that dynamic cursors have the worst performance, while forward-only cursors have the best performance. However, forward-only cursors do not allow you to predetermine the number of rows. This is why you are getting -1 from odbc_num_rows(). A static cursor should have been used instead of a dynamic cursor. While it is not faster than forward-only, it is faster than dynamic, and still allows you to get a row count.
-- bob On Thu, 26 Aug 2004, Mahmut Eren wrote: > Hi, > I'm using php-4.3.3 on mandrake Linux. I had a performance problem accessing to DB2 > databases on As400 systems. When I searched the internet I found out that commenting > out '#define HAVE_SQL_EXTENDED_FETCH 1' lines from php_odbc_includes.h file could > solve the problem. I edited the file and recompiled php; the result was a much > better performance. But this time odbc_num_rows() statement fails and always returns > -1. How can I solve this problem? Any suggestions? > Thanks in advance > Mahmut Eren > > ==========================================================- > Bu e-posta sadece yukarida isimleri belirtilen kisiler arasinda özel haberlesme > amacini tasimaktadir. Size yanlislikla ulasmissa lütfen gönderen kisiyi > bilgilendiriniz ve mesaji sisteminizden siliniz. Turkiye Cumhuriyet Merkez Bankasi > A.S. bu mesajin icerigi ile ilgili olarak hicbir hukuksal sorumlulugu kabul etmez. > > This e-mail communication is intended for the private use of the people named above. > If you received this message in error, please immediately notify the sender and > delete it from your system. The Central Bank of The Republic of Turkey does not > accept legal responsibility for the contents of this message. > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
