[Vtigercrm-developers] Maximum vtiger contacts?

[Sutharsan Jeganathan]

Hi

If you are going with H/w solution best way is to separate  MySQL server
from Webserver and use SSD or ideally RAM Drive
<http://www.makeuseof.com/tag/ram-drives-faster-ssds-5-things-must-know/>
for MySQL server.


thanks
Sutharsan Jeganathan

<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link>
<#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Wed, Apr 6, 2016 at 12:44 PM, 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/4ab0c745/attachment.html>