300,000+ leads HUGE performance drop.

[dblake]

I have uploaded 300,000+ leads into sugar and the performance dropped considerably. I still need to upload about 1,000,000 more and you guys said that sugar can handle millions and millions of row data. I click on the lead tab and it takes anywhere from 10sec to 30sec for response times. This is version 3.5. Can sugar not handle lots of rows?

[dblake]

[50] => SELECT count(*) FROM leads LEFT JOIN users
ON leads.assigned_user_id=users.id where leads.deleted=0
[51] => SELECT leads.*, users.user_name assigned_user_name FROM leads LEFT JOIN users
ON leads.assigned_user_id=users.id where leads.deleted=0 ORDER BY type asc LIMIT 0,20

[50] => 5.178434
[51] => 6.283077

Query times. Thats insane!

[ruchida]

Isn't it a MySQL or PHP issue? What about indexing the assigned_user_id column or others?
This thread may help. http://www.sugarcrm.com/forums/showt...ht=performance

[kbrill]

I have uploaded 300,000+ leads into sugar and the performance dropped considerably. I still need to upload about 1,000,000 more and you guys said that sugar can handle millions and millions of row data. I click on the lead tab and it takes anywhere from 10sec to 30sec for response times. This is version 3.5. Can sugar not handle lots of rows?

perhaps the PRO version could handle 1.3M items in miliseconds with Oracle, but MySQL? I have never seen MySQL handle that kind of volume well.

It also begs the question, how many salespeople do you have that 1.3M leads makes any sense? Thats like calling 20 leads a second for two years, 24 hours a day, 365 days a year. I have fewer than 1300 leads in my system and my sales staff can't find the time to contact them all.

Perhaps changing to a innodb schema may help a little, the leads table already has several indexes.

[sankar]

I converted the table creations to TYpe=InnoDB. Changed the mysql configurations. I am using WAMP on XP. 2G processor, 512MB RAM. Accessing a contact is taking around 2sec and nothing changed in the time.

anything else I should change?

[longreach]

WAMP and 512 MB do not sound good to me - I would change both of those if you can. Linux and 2 GB might help a lot.