CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Pre-installation Questions (Moderator: Dave Greenberg) »
  • Evaluating CiviCRM
Pages: [1]

Author Topic: Evaluating CiviCRM  (Read 1508 times)

halberjo

  • Guest
Evaluating CiviCRM
July 22, 2008, 03:56:32 pm
Hi,

We are evaluating CiviCRM and have a couple of questions. Hopefully this is the right forum, if not apologies. Apologies too if these questions do not appear that CiviCRM specific.

Firstly, we are looking to support a database of approximately 250k records (mix of individuals & organisations), with up to 50 concurrent users . Will CiviCRM/Drupal scale to support that sort of load on a small amount of commodity hardware, say balanced over 2 servers (each 1.5Ghz, 512M, running Linux & mysql), if not what sort of infrastructure would typically be used for such a deployment? Also if anyone has details of of a reference deployment (size of user-base. number of records & extent of hardware used) that they are happy to provide that would be helpful.

Secondly, using the role based security features, is it possible to restrict access  to individual records?

Thanks in advance for your help!

Regards,

Joel

geilhufe

  • I post frequently
  • ***
  • Posts: 293
  • Karma: 33
    • Social Source Software
Re: Evaluating CiviCRM
July 22, 2008, 06:12:27 pm
Load will probably not be an issue for you. Depending on what those 50 concurrent users are doing  (i.e. if you experience any slowness) you may need to tune the underlying webserver (apache) or, more likely, the database (mysql) server. Other Civi installs exceed your numbers, but you would be among the larger installs.

You might try the case studies, for a reference (http://wiki.civicrm.org/confluence/display/CRMDOC/Case+Studies), but one is not jumping out at me off the top of my head. CivicActions and Trellon and others (http://civicrm.org/professional) have been consultants on this scale of project.

Within the ACL system, you could create a group of a single record and restrict access that way, but there is no direct per contact structure. You'll need to think a lot about how ACLs will impact your load.
Drupal and CiviCRM consulting, strategy and configuration
http://www.social-source.com/

halberjo

  • Guest
Re: Evaluating CiviCRM
July 23, 2008, 04:36:23 am
Thanks!

Additionally, do you know if it is possible to create access control rules that operate on the financial records (details of financial transactions) ?

Thanks,
Joel

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Evaluating CiviCRM
July 23, 2008, 05:03:40 am
Hi,

The ACL system is already quite detailled and allows to grant/deny access to individual features. They are financial informations linked in several places (eg. registration fees, donation, memberships...). Based on what you need, it might already be there, or shouldn't be too complicated to create and add rules.

I'd suggest not to focus on these details too early on your evaluation, and rather get a sense if you think your users will like the interface and if the way it's organised will fit your needs. More importantly, if the way the system has evolved over the past versions make you comfortable in its future  as something that will grow with you.

As for the fine tuning and tiny details, plan a budget for that, you will find providers, either Civi directly or one of the IT companies using it. This is an open source product, it is in general easier and cheaper to customize if it needs change at the code level (most is likely only to be templates and configurations).

Please share with us the result of your analysis, especially if you decide to go for another solution, I'd love to know what you consider missing for a big install.

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

halberjo

  • Guest
Re: Evaluating CiviCRM
July 23, 2008, 07:25:45 am
Thanks for all the suggestions. We'll report back on how it goes.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Pre-installation Questions (Moderator: Dave Greenberg) »
  • Evaluating CiviCRM

This forum was archived on 2017-11-26.