php4 on WinXP vs. Linux -- memory problems

[cmills28@yahoo.com]

Hi.

I'm developing a php 4.3.10 script, extracting data from webpages.
Using string functions (strpos, substr) alot, some arrays (both static
& dynamic) also data is going to a MySQL 5 DB. Am using
mysql_free_resu lt() function to free memory, but I'm still having
memory problems -- keep getting the memory exhausted error. I'm
developing this on Windows XP, but the live site is on Linux. Would
this problem be a glitch in my code, in php itself, or a server
problem??

any thoughts/suggestions?

Thanks in advance.
Chris

[cmills28@yahoo.com]

Re: php4 on WinXP vs. Linux -- memory problems

PS.

I forgot to mention that the memory problems are in the Linux server.
I haven't run my script fully on WinXP yet so I don't know if I'll get
the same error.

Chris

[Iván Sánchez Ortega]

Re: php4 on WinXP vs. Linux -- memory problems

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

cmills28@yahoo. com wrote:

I'm developing a php 4.3.10 script, extracting data from webpages.
Using string functions (strpos, substr) alot, some arrays (both static
& dynamic) also data is going to a MySQL 5 DB. Am using
mysql_free_resu lt() function to free memory, but I'm still having
memory problems -- keep getting the memory exhausted error. I'm
developing this on Windows XP, but the live site is on Linux. Would
this problem be a glitch in my code, in php itself, or a server
problem??
>
any thoughts/suggestions?

How many rows are there (in comparison) in the development and production
databaes? Are you loading all that data into memory anywhere in your code?
Are you unset()ting the variables holding the result data?

- --
- ----------------------------------
Iván Sánchez Ortega -i-punto-sanchez--arroba-mirame-punto-net

"People demand freedom of speech to make up for the freedom of thought which
they avoid."
- Soren Aabye Kierkegaard (1813-1855)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)

iD8DBQFEqlmW3jc Q2mg3Pc8RAgjuAJ 4vCk2KW/EWaRuG7GMy3lWXd eVBIQCeK4Qb
hjHizik9aCytu4m 9JDvwNsI=
=xtsI
-----END PGP SIGNATURE-----

[Karel de Vos]

Re: php4 on WinXP vs. Linux -- memory problems

Is this memory exhausted error from PHP or from the MySQL server.

cmills28@yahoo. com wrote:

Hi.
>
I'm developing a php 4.3.10 script, extracting data from webpages.
Using string functions (strpos, substr) alot, some arrays (both static
& dynamic) also data is going to a MySQL 5 DB. Am using
mysql_free_resu lt() function to free memory, but I'm still having
memory problems -- keep getting the memory exhausted error. I'm
developing this on Windows XP, but the live site is on Linux. Would
this problem be a glitch in my code, in php itself, or a server
problem??
>
any thoughts/suggestions?
>
Thanks in advance.
Chris
>