Two DB questions - Make that Three
Posted: Sat Apr 01, 2006 7:25 pm
1) What is the purpose of DSN??
I've searched Google and I read about it and understand it's basically just an easy to expedite connection to RDBMS but it doesn't seem to serve a purpose in a web application environment - especially on Linux???
When would I use DSN?
2) I know what persistent connections are, but I never used them in web application development.
When would one use persistent MySQL database connections?
3) Recordsets. I know what they are and have used them, but wonder if their really worth it? I mean is it that more difficult to work with an associative array, than a resultset object?
What is your opinion on recordsets in abstraction layers like AdoDB? Overkill or nice feature?
Thanks
I've searched Google and I read about it and understand it's basically just an easy to expedite connection to RDBMS but it doesn't seem to serve a purpose in a web application environment - especially on Linux???
When would I use DSN?
2) I know what persistent connections are, but I never used them in web application development.
When would one use persistent MySQL database connections?
3) Recordsets. I know what they are and have used them, but wonder if their really worth it? I mean is it that more difficult to work with an associative array, than a resultset object?
What is your opinion on recordsets in abstraction layers like AdoDB? Overkill or nice feature?
Thanks