very well put.
-----Original Message----- From: Chris Terrebonne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 4:03 PM To: [EMAIL PROTECTED] Subject: Re: [IMail Forum] Poll re: Interest in SQL/Registry hybrid solution We have been down this road before but... Registry performance is faster than SQL performance yes, but that performance gain is lost when user counts reach the 100's of thousands of users and beyond. Although access to components external to the system is required of SQL, the speed is compensated by the indexing benefits that an enterprise level database can provide. The indexing mechanism of the registry was simply not created to handle such a large volume of data effectively. An equal analogy would be that if you have a couple of hundred books scattered in your house, it would be quicker to find one than it would be to drive to the library and find the same book. But, if you have several thousand book in your house, it would be faster to drive to the library and use their indexing to find the same book. I think the hybrid idea is sound for the vast majority of users. But for those anticipating a very large volume, I believe the performance will be unflattering. Chris ---------------------------------------------- Original Message From: "Adam (Snowboard)"<[EMAIL PROTECTED]> Subject: Re: [IMail Forum] Poll re: Interest in SQL/Registry hybrid solution Date: Tue, 19 Mar 2002 13:04:28 -0800 >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/ > 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/
