>The Registry is faster than SQL.

Preemptive: note that I am not talking about the Imail Admin's DISPLAY
of  your  userbase,  but  the  speed  of  the  DAEMONS'  access to the
userbase. The display of Registry users is slower than SQL for a large
userbase because the Registry API's key enumeration functions are like
entry-by-entry  cursors, whereas SELECT * against a client/server back
is much more efficient.

In  other  words:  Registry excels at seek, SQL at scan. The former is
used  to  check  to  perform  tasks (send/receive) for specific users,
while  the latter is used to get all the users in a domain. And if you
need  to  get  at  your userbase for reporting or billing or any other
integration need, SQL is the only functional way.

Sandy


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/

Reply via email to