Wayne,
We were infrequently hit with the problem at around 2,000 users so I've
been looking into it. It turns out that how often the problem occurs
depends on how evenly the users are distributed among virtual hosts. It
may also be less of a problem if the DB is on a remote PC because of the
network communications delay.
According to the SQL server 7 online help, the SQL Server ODBC driver
supports only a single active statement per connection. I got around this
by forcing a server side cursor. I have also posted this fix at
http://home.att.net/~niceman/
Note: although this appears to be a correct solution, it drops the
performance of the IMail Administrator user list refresh by 1/2. So a
couple thousand users may take 30 seconds to display on a single processor
PC. It would take a redesign to explore other solutions such as mass
query or a connection per query to see if those are faster.
In <[EMAIL PROTECTED]>, on 01/01/00 at
12:00 AM,
"Wayne Maw" <[EMAIL PROTECTED]> said:
>not enough simultaneous pop3 sessions to cause the cursor problem.
>(we hit the problem at 20,000+)
>-----Original Message-----
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]]On Behalf Of GTOnline Support
>Sent: 29 March 2000 13:48
>To: Wayne Maw
>Subject: Re[2]: [IMail Forum] IMail w/SQL Database
>We may be an exception, we have Compaq Proliant 2 x 500Mhz Processor
>Machines running IMail which in turn uses an SQL database on other
>machines. We have had no problems in this area and have been running
>since last October with 2500 accounts.
>Wednesday, March 29, 2000, 10:06:09 AM, you wrote:
>> If your using a machine with more than 1 processor, look elsewhere, Imail
>> don't work right with multiprocessor machines against SQL.
>> And it keeps losing connectivity to DBase at least once a day.
>> And they just ignore the fact.
--
-----------------------------------------------------------
Mike Nice <[EMAIL PROTECTED]>
-----------------------------------------------------------
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
