Capacity planning trends

[WildCard]

Hi all.
New Sugar user here.

I'm thinking of selling the idea of implementing SugarCRM for as a non-sales CRM in the office.
Primary usage for users would be as an email archiving site, call activity logging and a small discussion board (forum).
From these points, would like to know whether would I be looking at space usage fast?
Also, I'm currently testing out the Installer Stack that comes with MS SQL.

Is that MS SQL Express that the stack installed? If so, that means I would have a 4 GB size limit right?

Appreciate in advance all your insights / inputs.

[andopes]

Hi all.
New Sugar user here.

I'm thinking of selling the idea of implementing SugarCRM for as a non-sales CRM in the office.
Primary usage for users would be as an email archiving site, call activity logging and a small discussion board (forum).
From these points, would like to know whether would I be looking at space usage fast?
Also, I'm currently testing out the Installer Stack that comes with MS SQL.

Is that MS SQL Express that the stack installed? If so, that means I would have a 4 GB size limit right?

Appreciate in advance all your insights / inputs.

Hi WildCard

If you are going to implement the SugarCRM for these purpose you really need a huge memory limit, 4GB or more once the emails tables will get pretty big.
I believe you already know the Forum module available for download.

Kind regards

[mcatling]

Hi WildCard,

I have a number of customers who use Sugar for non sales work.

They use it primarily for customer facing project management... for example

Risks
Issues
Querys
Change Requests
Contacts
High level programme management
Document management (integrated with knowledge tree or Alfresco)
Email logging

The email does take up lot of space especially if you archive any attachments so I would go for a Mysql based WAMP stack if you want to do it on Windows. I use" WAMPserver" and have found it to be a stable stack.

[WildCard]

Hi, everyone.
Thanks for reply. I've already checked out the Forums module and testing it.
Also, I've done the research for the database limitation and is now in progress of trying out the MySQL version.

I think mcatling is hitting my question spot on a bit.
I'm thinking, even with a theoretical 2TB limit with MySQL (when using Windows 2003 with NTFS), is that enough for archiving like 6 years worth of activities, call logs and emails (with attachments)?

I am not planning to deploy SugarCRM as the actual email client. Rather its going to be archiving selected emails (with attachments) that concerns agreements / transactions that my users may conduct over email and requires archiving for up to 6 years. I chose CRM becoz of ease of report generation and search for historical reference by both management and new staff.

With that, will 2TB be sufficient in terms of storage?
Also, any chances SugarCRM will suffer from performance issues with accessing huge DBs (4 GB or more)?
I'm seriously coaxing my management into looking at the actual Pro package for its support / bug-fix benefits but they still have this basic issue which they wish to nag at me with.