Michael Thomas wrote:
>
> I was interested in Sandy's response regarding performance as I have never
> measured the difference.
>
> There are other issues you may wish to be concerned about. I have subscribed
> to this list and have seen the various "SQL/MySql issues" that people have
> run into when integrating IMail and SQL. For example, ODBC driver
> compatibility (MySql) and user authentication (I don't recall if this was
> fixed in 7.x. Anybody?)
I'd guess that the registry is much faster. Why? Because all IMail
modules dynamically connect and disconnect from the DLL each time they
need to do something. For example EmerAuth has a smart cache built into
it to alleviate some redundant queries and such over time to the SQL
server. However, its never used as the DLL is constantly unloaded. :(
A typically process attach (ie, user lookup) requires:
1) Load connection information from the registry (ie, DSN, user,
password) so we know where we are connecting to.
2) Connect to the SQL Server with that information.
3) Pre-fetch other configuration and cache options from the DB.
4) Respond to the IMail request.
1-3 should only happen once for the life of the module being used, making
4 the only overhead to get/set user information from the DLL.
I've been bringing this up since V5 when the first DB connector was
released. It does remind me of the old RadiusNT 0.x days, when RadiusNT
did this connect/disconnect for each accounting request. :)
--
Dale E. Reed Jr. Emerald and RadiusNT/X
__________________________________________
IEA Software, Inc. www.iea-software.com
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
An Archive of this list is available at:
http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
