Sounds like a good idea to me, however i have some questions : 1) how would you convert a large system (200,000+) that uses SQL into one of these hybrid systems? 2) What kind of performance improvements are we likely to see? 3)It seems to me that account administration would be much mor difficult too because you would have to change things in 2 places?
----- Original Message ----- From: "Sanford Whiteman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 19, 2002 12:05 PM Subject: [IMail Forum] Poll re: Interest in SQL/Registry hybrid solution > 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/ > 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/
