Performance Question

Hello,

I have a mail management system designed to be used with 100 users. Heavy activity goes on with this and it grows to a size of approx 3 GB every month.

Now there is talk of increasing the number of users & expanding to 250+ more users( maybe with modified and a bit of added functionality for these users alone).

This is going to increase the activities a lot and I am worried about performance issues.

I want ur suggestions whether I should add whatever new functionality is there & include the 250+ users in this application or make another application catering exclusively to those 250+ users.

The present functionality includes:

-Complex workflow to get approval of mails b4 being sent to customers.

-All possible mail features that any mail system can have.

we do have an archival policy that archives and retains only 1 month old data.

pls suggest.

many thanks

Farooq

Subject: Performance Question…

If you can modify the workflow app, you can try removing unused views since their indexes can cause performance issues.

Also you should try compressing attachments, there are tools at www.mk-net-work.com that could be useful for this.

Hope it helps.

Subject: Performance Question…

What exactly is in the mail management sytem that makes it so big?

If I recall correctly, the size of the database (byte size on disk) does not impact performance much, but the number of documents does.

If this is a database with a ‘limited’ amount of documents containing e.g. big attachments I don’t think there will be performance issues. If there heaps of documents per user, it may have an impact.

cheers,

Bram