[Vtigercrm-developers] Maximum vtiger contacts?

[socialboostdk]

Excellent - thank you!

Is the DB-structure of Vtiger efficient enough to support millions of
module-entries? And what would happen if we also added ie.
1.000-10.000-100.000 users?

(not that i actually expect 100k users ;-) just trying to understand the
boundaries.

Dedicated high-end SQL-server on SSD, possible load-balancing, etc. would
be an obvious must.

Thanks!

Cheers,
Chris


On 6 April 2016 at 09:14, Alan Lord <alanslists at gmail.com> wrote:

> 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/
>>
>>
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20160406/a5be51c8/attachment.html>