Maximum number of contacts in Sugar / Ways to expand?

[nils23]

Hello there!

I've got a general question that I can't find the answer to anywhere: is there any limit to the number of contacts stored in SugarCRM? - And if so: are their hacks to add even more contacts?

I plan to host a huge number of contacts (>500K) and I'm not sure wether Sugar can cope..

(System will be LAMP5)

thanks!

nils

[wagnerbl]

Hello there!

I've got a general question that I can't find the answer to anywhere: is there any limit to the number of contacts stored in SugarCRM? - And if so: are their hacks to add even more contacts?

I plan to host a huge number of contacts (>500K) and I'm not sure wether Sugar can cope..

(System will be LAMP5)

thanks!

nils

On the Sugar Suite no.
But on the MySQL side, things will be awful, try to use the windows+sql server version for better performance (mysql does no handle big tables very well).

[nils23]

Thanx for replying!

Can anybody tell about their experiences relating to huge number of contacts under both, MySQL / M$-SQL?

To shed some light on "not handle very well" re MySQL and sorts..?

[MilSp3c]

Thanx for replying!

Can anybody tell about their experiences relating to huge number of contacts under both, MySQL / M$-SQL?

To shed some light on "not handle very well" re MySQL and sorts..?

Please disregard the not handing well comment. That isn't correct.

More than half of the webservers run mysql and apache in a lamp stack.

As far as a limit being placed. The only limit restriction that you currently have is that of your filesystem and quota limits.

Hope this helps.

[andopes]

Hi all.

I had already worked with mysql tables containing more then 6 millions records

Regards

André Lopes
Lâmpada Global Services
Av. Angelica, 1814 cj. 1502
São Paulo, SP 01228-200
tel1. 55 11 3668-6776
tel2. 55 11 3822-2581
cel. 55 11 7636-5859
messenger: andopes@yahoo.com.br
skype: andopes
e-mail: andre@lampadacrm.com.br

[wagnerbl]

Thanx for replying!

Can anybody tell about their experiences relating to huge number of contacts under both, MySQL / M$-SQL?

To shed some light on "not handle very well" re MySQL and sorts..?

SQL server have better performance with big tables (FACT).
But depends on the server, will it be only for the LAMP + sugar or it will have more webapps?

[Markku]

wagnerbl, do you happen to have any pointers? I'd like to read more about MySQL's performance with large tables.

I found this article interesting:
http://www.mysqlperformanceblog.com/...-large-tables/

Quoting

...you probably heard complains about MySQL being unable to handle more than 1.000.000 (or select any other number) rows by some of the users. On other hand it is well known with customers like Google, Yahoo, LiveJournal,Technocarati MySQL has installations with many billions of rows and delivers great performance.

[wagnerbl]

wagnerbl, do you happen to have any pointers? I'd like to read more about MySQL's performance with large tables.

I found this article interesting:
http://www.mysqlperformanceblog.com/...-large-tables/

Quoting

Remember that they use a lot of servers, and they have the enterprise edition so is not a fair "competition".
You can "try at home", make a big table on mysql (300mb) and make select * from table, then make an exact copy on sqlserver, on my case sqlserver was almost 5x faster on cold start.