Max contact in CRM?

**tien2104** · 2009-02-27, 03:28 AM

Hi all!

I imported 1,5 millions contact,

and now my sugarcrm can not view list contact,
anyone tell me how many contacts is sugarcrm can stored???

Thanks

**genius786** · 2009-02-27, 03:32 AM

Hi,

Is your database is MYSQL, MSSQL and ORACLES which database do you used ?

Best regards,

**andopes** · 2009-02-27, 09:48 AM

Originally Posted by tien2104

Hi all!

I imported 1,5 millions contact,

and now my sugarcrm can not view list contact,
anyone tell me how many contacts is sugarcrm can stored???

Thanks

Hi Tien

Actually what is going on?
Are all ListView loading except the Contacts one?

Cheers

**sugarcane** · 2009-02-27, 02:12 PM

Hello,

you probably need to set disable_count_query to false. When the system is trying to open the contact list view, it is trying to count all the records in the module (EX: 1-20 of 1000000). This is taking a while to process, or is timing out. If you disable to above, it should work