Memory usage exceeded on php / mysql_fetch_assoc and how to understand and fix it

Allowed memory size of 33554432 bytes exhausted error occurred and the line that is the killer is mysql_fetch_assoc and the files are very very large (many thousands of rows).

I am moving servers and the new one is a standard server while the older one on another host (who lost a backup on me) used as much resources as I needed as long as certain metrics were not breeched. Well, there is a lot less memory available, so I have to think outside the box. I’m getting the ‘out of memory’ error in php. I know it can be fixed with the likes of ini_set(“memory_limit”,”64M”), but lets see if we can be more efficient – I am thinking that the above code – wasn’t. Continue reading

Large Corps love using ASP.NET – if you are using for yourself – don’t as it will cost you $$ in wasted time. Web.Config gets cached and ASP.NET does NOT necessarily pick up on the change

So, I was debugging things for over an hour and … like often in Microsoft things, nothing was wrong or amiss. I changed the web.config file to point to another appConfig file. It didn’t care! It just used the old web.config file from over an hour ago. Ideally ASP.NET picks up on the change, but every so oftern (I have noticed over 2+ years, one gets caught in believing that things are working OK. Yes the config settings ARE CACHED.

Continue reading