> Definitely interested, I have been looking into doing a similar thing
myself
> (just caching), but I'm not really a C++ programmer.
> Lot's of questions:
> 1. What sort of expiry does it do, how does it handle changes, i.e. if I
> changed a users password in the SQL database table (not using imail) how
> long before that change would be picked up.
> I was working on the idea of expiring the data after around 10 mins.
Expiry time is configurable. I have our expiry time set at 1 day and for
any unused cached entries to get deleted after a week. Any failed
authentication by cache is sent to SQL (if up) as a second check. So
password updates aren't an issue.
> 2. Do you have to run it in single table mode, though single table is
nicer,
> I do not really want to migrate 1000's of domains.
We have one huge table, but I'm going to make this configurable.
> 3. How much extra memory does the caching take up? Is the level of caching
> controllable?
This basically depends on the maximum size specified and the expiry times
configured.
Each IMail service is independent and builds it's own cache in memory. But
I'm seeing about 5 megs needed for every 10,000 entries you want cached. So
with each service needing this (x4) would be about 20megs max (less
considering IMap isn't used as often).
In the future, this could be reduced by using shared memory and/or reducing
the entry size in memory.
> 4. Would the price include the source code?
Most likely not.
> 5. Does it still use cursors? I was looking at testing whether using a
> criticalsection during the database read would solve the multithreaded
> concurrency issue?
I haven't experimented with that. I'm not sure how much improvement in
speed it might provide since only one thread in the service would be able to
query sql at a time.
> 6. Does the Imail getfirstuserentry and getnextuserentry functions still
> lock up the database and stop authentication (I wasn't sure how to fix
that
> apart from caching the whole table)?
Each IMail service or application opens up its own ODBC session and seems to
operate independently. I'd have to look into it more though. Perhaps it's
just the loading placed on the SQL server by the IAdmin application during
the query. There's really no way I could slow this down. The process is
already slow enough in fetching all the users in IAdmin.
Steven Plautz
System Administrator of ISP Operations
Picus - Sybercom
[EMAIL PROTECTED]
Thanks
Steve
Steven Moore
Internet Development Engineer
Research Machines PLC
+44 1235 823522
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Steven Plautz
Sent: 17 October 2000 19:03
To: [EMAIL PROTECTED]
Subject: [IMail Forum] odbcuser.dll
I'm testing a new revision to IMail's odbcuser.dll (Mike Nice's version),
which incorporates a cache buffer and event logging. It can also merge all
mail domains into a single database table. I noticed that just signing on
IMail's web interface requires about 10 repetitive SQL queries. I couldn't
believe it. This appears to be a definite vast improvement not only in web
server response, but also in reducing the load on the database server.
Reports show over a 97% hit rate on IMail's webmsg & POP3 services. In
addition, it can keep the mail server up and running during SQL outages
since there's a cache to fall back to. Our IMail server started slowing
down at about 6000 database mailboxes on a dual 500mhz, compaq with 512megs
of ram due to ODBC issues. This appears to greatly increase that
limitation.
Anyone willing to spend $99 for such a dll for IMail? Of course, I'm
willing to sell it off to IPSwitch for IMail v7 too.
Steven Plautz
System Administrator of ISP Operations
Picus - Sybercom
[EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Eric A.
Shanbrom
Sent: Tuesday, October 17, 2000 1:39 PM
To: [EMAIL PROTECTED]
Subject: Re: [IMail Forum] changing the username
Actually the user@domain login is only for domains that are sans IP
addresses. If you can set up a virtual domain with an IP address your users
will connect to this particular IP and just log on as their userid.
Eric S
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 16, 2000 4:27 PM
Subject: RE: [IMail Forum] changing the username
> > I plan to run a SINGLE domain on my Imail box. The old usernames did not
> > include the domain name. I want to transfer all these users to
> > the new box.
> > How can I allow my users to continue to use their name only,without
> > specifying the domain. I want the move to be transparent to the users.
>
> Andrew,
>
> If you're only running a single domain, there should be no problem. With
> IMail, you only have to specify the "@domain.com" part for virtual
domains,
> not the primary one.
>
> Hope this helps,
> Ron
>
> ron allen hornbaker humankind systems, inc. mailto:[EMAIL PROTECTED]
> HKSI WebMail Templates for IMail v6x ~ Now 754 Installations Worldwide
> Classic... http://mail.hksi.net Killer... http://killerwebmail.com
>
>
>
>
>
>
> 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 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 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 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 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/
