08-03-2011 11:31 PM
I was just wondering if anyone techy out there could give me some insight as to how much data we can put into an Sage ACT! Pro 2011 database before it would start to really struggle. We have just gone over 10,000 contact records, 5500 Company records and ADF file is 168,000kb. Also, how does storing email attachments effect performance, if at all?
08-04-2011 07:15 AM - edited 08-04-2011 07:16 AM
There really is no limit to the number of records you can potentially have in your database, the only limiting factors are those imposed by SQL (the express version only allows 4 gb of data, the standard version has no limitations) and your hardware. A single record only consumes a small amount of data (~1kb if i remember correctly), however the amount of activites, notes and histories associated with that record can change that.
Attachments in general shouldn't have any affect on the performance of your database.
08-04-2011 05:27 PM
If you're using Sage ACT! 2011, that should be using MS SQL 2008 R2 Express by default.
If you're using a previous version and the SQL ACT7 Instance is in MS SQL Server 2005 Express the limit is 4GB.
The limit for MSDE2000 was 2GB.
08-05-2011 11:07 AM
08-05-2011 11:20 AM
I think you may be looking at something wrong, an empty database from that version was around 20mb. It's possible your .afl may be around that size but I'd expect it to be a bit larger.
08-05-2011 11:21 AM
Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.
08-05-2011 11:37 AM
08-05-2011 12:20 PM
From your workstation if your able, you can browse to the location where the file resides and view the file info in windows explorer. Alternatively from the server via the diagnostic utility (Start -> Run 'actdiag').