08-29-2011 06:22 PM
Sorry, I must not be making myself clear Mike. I'll try with this....
"If I want to reply/forward, I do that in Outlook "
That only works if th email is stored in YOUR Outlook PST file.
How can I reply/forward or view the attachment(s) if the original email is in your Outlook mailbox - not mine?
08-29-2011 06:25 PM
08-29-2011 06:43 PM
Your point is well taken.
For those who do not use a corporate mail server - for whatever reason - saving the entire email in ACT makes a lot of sense, in terms of sharing and having a single point of staorage.
That brings us back to the problem of folder size and SQL. Without a way to archive older attachments in a way that they can be cataloged and retreived at a later date, the only other option may be what your friend is working on - find a way to trick SQL into seeing multiple attachment folders as one.
08-29-2011 06:48 PM
09-01-2011 07:06 PM
Mike while I agree an addon to move these to a proper structure would be great given we have had 6 years of the current ACT this should have been addressed internally as many people are not hitting some real roadblocks given ACT makes no mention of limits for stored files.
Rather than adding glitzy features this is a major problem which should have been addressed by Sage and not keeping their head in a bucket about the problems it causes in the real world.
09-02-2011 11:31 AM
09-06-2011 02:19 AM
We're also concerned about the amount of files in the attachments folder.
We have about 435000 files (44.6Gb in size) No problems with our backup system, but very slow performance.
09-06-2011 02:40 PM
09-21-2011 02:36 PM
We are in the same situation. Our database has over 105,000 attachments (35GB) and performance can be painfully slow. I recently upgraded to 2012 hoping it would improve, but it actually got worse because the new Universal Serach feature started trying to index all the attachment and brought the system to a halt and ran the server out of hard disk space.
I talked to an Act Tech and he said attachments should be less than 10GB and suggested I get rid of some older stuff. That seems like a good idea to speed things up, but what's the best way to do this? I would like to keep the last 3 years of data in the current database and then export everything to an 'archive database' from the remaining years, but there's no suggested way from Act to do this. I don't want to lose anything in the process either that's why I don't want to delete anything.
09-21-2011 02:47 PM
This is certainly an issue for all of us.
I have more questions than answers at this point...rd