Hi,
Looking back on my earlier email it was a bit of a sweeping statement
considering my relative lack of experience with SQL server, however I was
always told that anything that causes table locks i.e. cursors, was a bad
idea on proper relational databases such as SQL 7. I'll happily bow to
superior wisdom on this :-)
My main concern is that IMail is not the only thing talking to the
particular database in question because we have written a custom set of COM+
components to handle the interaction from a ASP based admin interface to the
SQL server. Part of this system is allowing bulk user addition /
modification / deletion which can mean a reasonable amount of activity on
the SQL server ( though it should be no where near the SQL 7 limits). We
also use the SQL database to build configuration for other parts of the mail
system.
I haven't actually tried the latest cut of the dll, though we have been
using the first modification and it has worked very well for a while now so
I trust it and like many people on the list I have staked some reputation on
it being a solution to the problem.
I am not particularly worried about the Imail admin app being slower as we
are not planning to use it at all. I am more worried about things like the
IMAP4 authentication being slower (already a pretty slow process from what I
have seen). The Imap client we use is web based so it does not hold open
IMAP4 sessions like Outlook Express so authentification times can become an
issue.
Please don't get me wrong I did not mean to criticise the decision, just
wanted to get more feedback on how it was going for other users.
Thanks
Steve
Steven Moore
Internet Development Engineer
Research Machines PLC
+44 1235 823522
----- Original Message -----
From: Mike Nice <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 06, 2000 7:40 PM
Subject: Re: [IMail Forum] Mike Nice's new version of the dll w/ server side
cursors
> In
> <[EMAIL PROTECTED]>,
> on 01/01/00 at 12:00 AM,
> "STEVEN MOORE (IFL)" <[EMAIL PROTECTED]> said:
>
> >I get really concerned when server side cursors get mentioned in the same
> >sentence as SQL so I was wondering if anyone has seen marked improvements
> >to the reliability or performance.
>
> There is definitely a reliability improvement and a performance
> degradation. I can't detect an overall % server load change but the IMail
> administrator is slower with thousands of users.
>
> The SQL 7 ODBC docs are pretty clear that they only support a single
> active statement per connection. (This might be related to the SQL 6.5
> bug mentioned at
>
http://support.microsoft.com/support/kb/articles/Q175/9/04.ASP?LNG=ENG&SA=AL
LKB&FR=0
>
> and Microsoft just decided not to fix it). Then they steer you towards
> server side cursors. The only other solutions might involve more drastic
> rewrites or would limit the performance of multiprocessor systems.
>
> What types of issues have you run into in the past with server side
> cursors?
>
> --
> -----------------------------------------------------------
> Mike Nice <[EMAIL PROTECTED]>
> -----------------------------------------------------------
>
> Please visit http://www.ipswitch.com/support/mailing-lists.html
> to be removed from this list.
>
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
