All, Recent threads re: Imail's database options have surfaced the concept of a hybrid solution that combines the best of the Registry with the best of SQL. Targeted benchmarks and empirical evidence suggest that the Registry is faster by 10x or more; on the other hand, only with SQL support can true accounting, auditing, and integration take place.
So our proposal is for a synchronization technology that, through two-phase commit, can preserve the speed of in-memory local storage for OLTP and the openness of SQL queries for OLAP and general administration. We already have proof-of-concept through DLLs we whipped together last week. The first release of such technology would only support MSSQL/MSDE on the SQL side; bridging the same gap with MySQL on *nix has significant obstacles, so we'd put that off until sufficient results are in from the Win32 release. So, while our guess is that anything that speeds up Imail would be useful to systems already under stress, I'm reaching out to the list to see if there is sufficient interest out there to continue coding toward a full-fledged product. Anybody with a question or personal viewpoint on this, please speak up. Thanks and regards, Sandy ___| Sanford Whiteman, Chief Technologist ___| Broadleaf Systems + Support, Inc. ___| mailto:[EMAIL PROTECTED] 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/ Please visit the Knowledge Base for answers to frequently asked questions: http://www.ipswitch.com/support/IMail/
