Perl under MS IIS with access to MySQL

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

I have been working with MS IIS, ASP, SQL Server, Oracle for several years.
I currently try to migrate that experience to another environment. I am
about to use Perl under MS IIS with access to a MySQL database.

I did some testing. That worked well. However, sometimes a detailed
background-knowledge is missing.

[1] For accessing MySQL I included and used a library with "use MySQL".
Afterwards I found out that there are other components for database access.
Here I can give the keywords DBI/DBD.

  - What I have used is a low-level component, correct?

  - DBI/DBD can be regarded as above that component, correct?

  - Does DBI/DBD use the component that I used?

  - Is one of those components better than the other for usage under MS IIS?

[2] If I open a connection under IIS/ASP/SQLServer, later close that
connection, it won't actually be closed. A caching will take place, so that
the next connection/open might get the returned connection. This is very
usefull when working under an internet server.

  - Will IIS / Perl / use MySQL offer such a caching?

  - Will IIS / Perl / DBI/DBD offer such a caching?

  - If no caching takes place, how do you achieve caching?

Michael G. Schneider
Movable Type Weblog

Site Timeline