[Vtigercrm-developers] Maximum vtiger contacts?

[Alan Lord]

We have a few systems with several million entity records (might be 
Contacts or Leads, or a vtlib designed custom entity module) and with 
many more than 100 users.

There is one performance tweak I am aware of which I think will be going 
into 6.5 which adds a static cache to the to_html() function.

http://code.vtiger.com/vtiger/vtigercrm/commit/ca51b56d04c0c335e7a7f8a7d25c2da7560e2a2c

We use the slow query log in MySQL (or MariaDB) to identify and then 
make judicious use of indexes to improve search performance.

Install something like apc and/or memcached.

If it's still slow, run it on the fastest h/w you can afford and use 
SSDs for storage.

But on the whole it seems to work pretty well even with a considerable 
number of records. (Although I think 100,000,000 might be a struggle for 
this architecture!).

HTH

Al

On 05/04/16 22:46, socialboostdk wrote:
> Hi everyone.
>
> I have a questions towards vtigers scalability.
>
> How many contacts would be realistic for me to have in a vtiger
> installation (latest stable version)?
>
> If we assume I will use some cloud hosting and scale that WAY up, and I
> will use the standard contact setup? I can probably deactivate most
> other modules
>
> I will actually access the data via the API, so the overhead of any
> browser-loading etc. can be ignored.
>
> What would be your (educated) guess? 100.000? 1.000.000? 10.000.000?
>
> And what would be the bottleneck / how can I improve on the performance?
> Basically I need 10-100.000.000 contacts possible :-D
>
> THANKS!!
>
> best,
> Chris.
>
>
> _______________________________________________
> http://www.vtiger.com/
>