PHP and ODBC leaving lots of files open
Mike Prudence <[email protected]> Mon, 21 Jan 2013 18:26:18 +0000
| Newsgroups | gmane.comp.db.mdb-tools.devel |
|---|---|
| Message-ID | <[email protected]> |
Hi guys, Bit of a stab in the dark, but I thought I'd ask the list if anyone has seen anything like this - Google hasn't helped me thus far. We've got a bunch of PHP scripts using mbdtools via odbc. I've just noticed that if I use 'lsof -ap' on one of the httpd processes running the scripts, I discover that none of my 'odbc_close()' calls appear to have closed the .mdb file that I assume 'odbc_open()' has opened. This has become a problem because with more people using the scripts, the open files build up and up until the process breaks because it has too many open files. Surely if I use odbc_close() it should be closing the .mdb file it has opened, no ? Or have I missed something blindingly obvious ? Thanks, as always, for any hints/help... -- Cheers, Mike [email protected] http://www.filmsat59.com Films at 59 Ltd, 59 Cotham Hill, Bristol. BS6 6JR ENGLAND +44 117 906 4300 ------------------------------------------------------------------------------ Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122412