memory leak tracking

[delphi123]

hi folks,

 

I suspect my code may be leaking memory (according to my host) - can anyone give me pointers on how you test whether it is leaking and how you can track down/isolate the cause?

[gerkintrigg]

and what exactly is your host referring to? If they mean you're using too much memory, try to consolidate your code. Make it more efficient. There's no real way of knowing what the problem is without a bit more info.

 

Sorry.

 

However a hint might be to start looking at SQL queries... Are you grabbing a million files or so, then using mysql_num_rows() or are you counting in the SQL Query using SELECT COUNT(*) as records?

 

The first is bloated and takes a LOT more effort than the second. This might be what they're on about...

 

Hope this helps.

[delphi123]

thanks for the reply - they were saying that there was a while statement that caused it:

 

'The reason your while loop does not work is because you do not define the $column_counter variable before using it, nor do you increase it at all in the loop. So, the loop just continues to run until it eventually uses all the memory on the server.'

 

I didn't realise you needed to increment while statements?!  most tutorials seem to just say things like:

 

while ($table = mysql_fetch_array($result)){

//do code

}

 

am I wrong?

 

Also how can I check how much memory is being used?  I'm running the code on localhost and I was wondering if there's any software that'll tell you what load the server is under etc?