RE: [PHP] ODBC Oracle
Joe, I love you!! (In a 'Happy I now have something working' sort of way of course) :) It hasn't finished (it's still running now), but it is sure going *alot* further than it had before. -ken -Original Message- From: Joe Brown [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 5:33 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] ODBC Oracle There is a timeout, that should halt a script if it runs too long. If you can, check php.ini set max_execution_time to something greater than 30 seconds, see if that helps. ""Brooks, Ken"" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I thought maybe the php script was running to fast for the network connection. So i put in a sleep(1) It still only ran for about the same amount of time (less records pulled of course). Could it be losing the connection instead because of lack of activity? Would a persistent connection make any difference? -Original Message- From: Brooks, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 4:04 PM To: [EMAIL PROTECTED] Subject: [PHP] ODBC Oracle Are there any limitations on how many records I can pull from an Oracle Database over ODBC? I have it pulling one record just fine, but when I tell it to pull all records, which should be about 75,000, it only gets about 600 or so. Does the php script time out (i'm running it thru a web browser). What could it be?... thanks, ken -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] ODBC Oracle
Are there any limitations on how many records I can pull from an Oracle Database over ODBC? I have it pulling one record just fine, but when I tell it to pull all records, which should be about 75,000, it only gets about 600 or so. Does the php script time out (i'm running it thru a web browser). What could it be?... thanks, ken -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] ODBC Oracle
I thought maybe the php script was running to fast for the network connection. So i put in a sleep(1) It still only ran for about the same amount of time (less records pulled of course). Could it be losing the connection instead because of lack of activity? Would a persistent connection make any difference? -Original Message- From: Brooks, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 4:04 PM To: [EMAIL PROTECTED] Subject: [PHP] ODBC Oracle Are there any limitations on how many records I can pull from an Oracle Database over ODBC? I have it pulling one record just fine, but when I tell it to pull all records, which should be about 75,000, it only gets about 600 or so. Does the php script time out (i'm running it thru a web browser). What could it be?... thanks, ken -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] ODBC Oracle
Okay, I'm baffled. I told it to Connect to the database. I then started a loop of (odbc_fetch_row) I get about 6000 records returned (that i'm just plopping into an array for speed). That's all, much more than when i process each one, but I would think it is more than possible to grab more than 6000 records from a database. right? thanks, ken -Original Message- From: Brooks, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 4:21 PM To: [EMAIL PROTECTED] Subject: RE: [PHP] ODBC Oracle I thought maybe the php script was running to fast for the network connection. So i put in a sleep(1) It still only ran for about the same amount of time (less records pulled of course). Could it be losing the connection instead because of lack of activity? Would a persistent connection make any difference? -Original Message- From: Brooks, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 4:04 PM To: [EMAIL PROTECTED] Subject: [PHP] ODBC Oracle Are there any limitations on how many records I can pull from an Oracle Database over ODBC? I have it pulling one record just fine, but when I tell it to pull all records, which should be about 75,000, it only gets about 600 or so. Does the php script time out (i'm running it thru a web browser). What could it be?... thanks, ken -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] ODBC Oracle
There is a timeout, that should halt a script if it runs too long. If you can, check php.ini set max_execution_time to something greater than 30 seconds, see if that helps. ""Brooks, Ken"" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I thought maybe the php script was running to fast for the network connection. So i put in a sleep(1) It still only ran for about the same amount of time (less records pulled of course). Could it be losing the connection instead because of lack of activity? Would a persistent connection make any difference? -Original Message- From: Brooks, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 4:04 PM To: [EMAIL PROTECTED] Subject: [PHP] ODBC Oracle Are there any limitations on how many records I can pull from an Oracle Database over ODBC? I have it pulling one record just fine, but when I tell it to pull all records, which should be about 75,000, it only gets about 600 or so. Does the php script time out (i'm running it thru a web browser). What could it be?... thanks, ken -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]