Community
Showing results for 
Search instead for 
Do you mean 
Reply

contact imports slllooooooowwwww

Copper Contributor
Posts: 13
Country: USA

contact imports slllooooooowwwww

Hi, y'all.

 

It's taking 15 minutes to import 30 new contacts, either saved in tab delimated or CSV.

 

Is this a little slow?  Any advice?

 

thank you!

Falala

Copper Super Contributor
Posts: 72
Country: USA

Re: contact imports slllooooooowwwww


DebSpecs wrote:

Hi, y'all.

 

It's taking 15 minutes to import 30 new contacts, either saved in tab delimated or CSV.

 

Is this a little slow?  Any advice?

 

thank you!

Falala


are you enabling duplicate checking on import and how many contacts do you have in your database?  If you are, then it checks every contact in your database against what you're importing.  For example, if you have 50,000 names in your database and your dupe check is on last name, first name, then it checks your imported contacts against each contact name.  So 30 contacts * 50,000 = 1,500,000 scans.

Platinum Elite Contributor
Posts: 14,387
Country: Australia

Re: contact imports slllooooooowwwww

Dave, I would think that using the SQL index, it's not actually "scanning" the entire database
Platinum Elite Contributor
Posts: 14,387
Country: Australia

Re: contact imports slllooooooowwwww

Falala,

 

Is it slow if you try to import into the demo database?

Are you doing the import on the machine the database is on or across a LAN?

How big is your database?

What machine specs?

What version of ACT! (the full build from Help | About)?