Re: [PHP] huge PHP file, hardcore processing
Note: if you hit the stop button and php doesn't stop, that probably means it's either in the middle of a query and can't stop, or more likely it means that "ignore.user.abort" has been set to true. Turn off ignore user abort in your php.ini, and that should solve your problem. As for accessing any database on any system configuration, yes PHP can do it. You can have a DB running on a Super Nintendo accessed by PHP on a FreeBSD box, and it should work fine. ;) In other words it doesn't matter what platform it's running on...in a perfect world. -- Plutarck Should be working on something... ...but forgot what it was. "Christian Dechery" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I have a huge (at least I think, for a script anyway) PHP script... it is over 1.000 lines of code. And it updates (do an entire DELETE-ALL / LOAD-ALL) an SQL Server database (over 35MB). It runs for over an hour (sometimes 2hs)... and I divided it into steps... so each step is a function in the script that when is over calls a javascript function that reloads the script to the next step. I was wondering if this is enough to get a good 'memory-cleaning'. Or it would be better to have lots of files (in total, there are 27 separate steps). I began noticing some processing slowness after the first 35 mins... it get's 'tired'. The script starts running and with ob_implicit_flush() on, the output is flushed almost at real time... but after 10 or 12 steps it starts to get slow and do NO FLUSHING at all... only showing the entire output at once after the whole step has ended. Should I split it into files? Is because it's running on (eek!) IIS? Maybe the size of the file is getting in the way? Can someone help me out? Ah... one other thing. Has anybody experienced very weird behaviours of PHP with IIS? Sometimes I press 'stop' at the browser but PHP is still running. I can see it eating up memory in the TaskManager. And it won't stop until I kill it. And the most weird part is, as soon as I call a script (any script) PHP returns to the TaskManager with the same amount of memory it had when it was running tha massive script mentioned above. Does IIS really suck, or is there something very wrong with my config? . Christian Dechery (lemming) . http://www.tanamesa.com.br . Gaita-L Owner / Web Developer -- 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] huge PHP file, hardcore processing
At 12:06 10/4/2001 +0900, you wrote: You should be able to use ODBC under UNIX. I guess. Source code for MS SQL Server modules seems it does not compile under UNIX. I guess it may work with Apache under Windows. From mssql_win32_howto.txt in PHP source. 24 Start Visual Studio, load php_modules.dsw, select the MSSQL projects, 25 configuration and build it. 26 27 This module requires ntwdblib.dll and one or more of the following dll's 28 29 dbmsadsn.dll 30 dbmsrpcn.dll 31 dbmsshrn.dll 32 dbmssocn.dllfor tcp/ip connections 33 dbmsspxn.dllfor ipx/spx connections 34 dbmsvinn.dll 35 dbnmpntw.dllfor netbios connections Sorry I don't use MS SQL Server. well... I don't have Visual Studio here... so I guess I'm stuck with shitty-old IIS... :( . Christian Dechery (lemming) . http://www.tanamesa.com.br . Gaita-L Owner / Web Developer -- 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] huge PHP file, hardcore processing
Yes - look at freetds.org. sorry... I did not make myself clear. I don't intend to switch from IIS to Apache, cuz I can't. The server runs a whole site in ASP... this is the only PHP script that runs on it, I was thinking more of running it in Linux... can I access a MS SQL server from within Apache/PHP under Linux??? . Christian Dechery (lemming) . http://www.tanamesa.com.br . Gaita-L Owner / Web Developer -- 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] huge PHP file, hardcore processing
At 10:20 11/4/2001 +0900, you wrote: I think DLL for MS SQL Server will work with Apache for Windows/PHP for Windows. There are many basic functions are not supported under PHP for Windows, but it work fine for me other than those missing functions. If your server may have multiple IP addressees, it's easy to co-exist with IIS. How about give it a try? I guess I don't have multiple IP adresses on my server... can't I just install Apache and have it listen on port 8080 instead? Will it co-exist nicely with IIS? . Christian Dechery (lemming) . http://www.tanamesa.com.br . Gaita-L Owner / Web Developer -- 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] huge PHP file, hardcore processing
I have a huge (at least I think, for a script anyway) PHP script... it is over 1.000 lines of code. And it updates (do an entire DELETE-ALL / LOAD-ALL) an SQL Server database (over 35MB). It runs for over an hour (sometimes 2hs)... and I divided it into steps... so each step is a function in the script that when is over calls a javascript function that reloads the script to the next step. I was wondering if this is enough to get a good 'memory-cleaning'. Or it would be better to have lots of files (in total, there are 27 separate steps). I began noticing some processing slowness after the first 35 mins... it get's 'tired'. The script starts running and with ob_implicit_flush() on, the output is flushed almost at real time... but after 10 or 12 steps it starts to get slow and do NO FLUSHING at all... only showing the entire output at once after the whole step has ended. Should I split it into files? Is because it's running on (eek!) IIS? Maybe the size of the file is getting in the way? Can someone help me out? Ah... one other thing. Has anybody experienced very weird behaviours of PHP with IIS? Sometimes I press 'stop' at the browser but PHP is still running. I can see it eating up memory in the TaskManager. And it won't stop until I kill it. And the most weird part is, as soon as I call a script (any script) PHP returns to the TaskManager with the same amount of memory it had when it was running tha massive script mentioned above. Does IIS really suck, or is there something very wrong with my config? . Christian Dechery (lemming) . http://www.tanamesa.com.br . Gaita-L Owner / Web Developer -- 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] huge PHP file, hardcore processing
IIS ISAPI(PHP4.0.4pl1 and PHP4.0.5RC1) does not work well for me and too many problems. So I switched to Apache. However, ob_implicit_flush() seems slows things down on W2K/Apache/PHP4.0.4RC1 also. (ob_implicit_flush() may slow things down, but it's more apparent than my Linux/Apache box) You may get better result on UNIX/Apache. Someone mentioned he/she does not have any problem with W2K/IIS ISAPI/PHP4.0.3pl1 with more than 250,000 hits/day. You may want to down grade your PHP to 4.0.3pl1. Regards, -- Yasuo Ohgaki "Christian Dechery" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I have a huge (at least I think, for a script anyway) PHP script... it is over 1.000 lines of code. And it updates (do an entire DELETE-ALL / LOAD-ALL) an SQL Server database (over 35MB). It runs for over an hour (sometimes 2hs)... and I divided it into steps... so each step is a function in the script that when is over calls a javascript function that reloads the script to the next step. I was wondering if this is enough to get a good 'memory-cleaning'. Or it would be better to have lots of files (in total, there are 27 separate steps). I began noticing some processing slowness after the first 35 mins... it get's 'tired'. The script starts running and with ob_implicit_flush() on, the output is flushed almost at real time... but after 10 or 12 steps it starts to get slow and do NO FLUSHING at all... only showing the entire output at once after the whole step has ended. Should I split it into files? Is because it's running on (eek!) IIS? Maybe the size of the file is getting in the way? Can someone help me out? Ah... one other thing. Has anybody experienced very weird behaviours of PHP with IIS? Sometimes I press 'stop' at the browser but PHP is still running. I can see it eating up memory in the TaskManager. And it won't stop until I kill it. And the most weird part is, as soon as I call a script (any script) PHP returns to the TaskManager with the same amount of memory it had when it was running tha massive script mentioned above. Does IIS really suck, or is there something very wrong with my config? . Christian Dechery (lemming) . http://www.tanamesa.com.br . Gaita-L Owner / Web Developer -- 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] huge PHP file, hardcore processing
At 10:23 10/4/2001 +0900, you wrote: IIS ISAPI(PHP4.0.4pl1 and PHP4.0.5RC1) does not work well for me and too many problems. So I switched to Apache. However, ob_implicit_flush() seems slows things down on W2K/Apache/PHP4.0.4RC1 also. (ob_implicit_flush() may slow things down, but it's more apparent than my Linux/Apache box) You may get better result on UNIX/Apache. Someone mentioned he/she does not have any problem with W2K/IIS ISAPI/PHP4.0.3pl1 with more than 250,000 hits/day. You may want to down grade your PHP to 4.0.3pl1. but how can I access an MS SQL database from Apache??? . Christian Dechery (lemming) . http://www.tanamesa.com.br . Gaita-L Owner / Web Developer -- 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] huge PHP file, hardcore processing
On 4/9/01 6:38 PM, "Christian Dechery" [EMAIL PROTECTED] wrote: At 10:23 10/4/2001 +0900, you wrote: IIS ISAPI(PHP4.0.4pl1 and PHP4.0.5RC1) does not work well for me and too many problems. So I switched to Apache. However, ob_implicit_flush() seems slows things down on W2K/Apache/PHP4.0.4RC1 also. (ob_implicit_flush() may slow things down, but it's more apparent than my Linux/Apache box) You may get better result on UNIX/Apache. Someone mentioned he/she does not have any problem with W2K/IIS ISAPI/PHP4.0.3pl1 with more than 250,000 hits/day. You may want to down grade your PHP to 4.0.3pl1. but how can I access an MS SQL database from Apache??? . Christian Dechery (lemming) . http://www.tanamesa.com.br . Gaita-L Owner / Web Developer with PHP Apache/PHP combo will run just fine on Windows, and you should be able use PHP's ODBC functions to access Access databases. see: http://www.php.net/manual/en/ref.odbc.php -- 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] huge PHP file, hardcore processing
At 18:40 9/4/2001 -0700, you wrote: On 4/9/01 6:38 PM, "Christian Dechery" [EMAIL PROTECTED] wrote: At 10:23 10/4/2001 +0900, you wrote: IIS ISAPI(PHP4.0.4pl1 and PHP4.0.5RC1) does not work well for me and too many problems. So I switched to Apache. However, ob_implicit_flush() seems slows things down on W2K/Apache/PHP4.0.4RC1 also. (ob_implicit_flush() may slow things down, but it's more apparent than my Linux/Apache box) You may get better result on UNIX/Apache. Someone mentioned he/she does not have any problem with W2K/IIS ISAPI/PHP4.0.3pl1 with more than 250,000 hits/day. You may want to down grade your PHP to 4.0.3pl1. but how can I access an MS SQL database from Apache??? . Christian Dechery (lemming) . http://www.tanamesa.com.br . Gaita-L Owner / Web Developer with PHP Apache/PHP combo will run just fine on Windows, and you should be able use PHP's ODBC functions to access Access databases. sorry... I did not make myself clear. I don't intend to switch from IIS to Apache, cuz I can't. The server runs a whole site in ASP... this is the only PHP script that runs on it, I was thinking more of running it in Linux... can I access a MS SQL server from within Apache/PHP under Linux??? . Christian Dechery (lemming) . http://www.tanamesa.com.br . Gaita-L Owner / Web Developer -- 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]