Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Import of massive amount of members; help with speeding up import

October 28, 2007 8:33pm

Subscribe [1]

#1 / Oct 28, 2007 8:33pm

Ryan M.
1511 posts

The site I’m working on uses email addresses as usernames. I need to import 450,000 people. No custom fields. What can I do to speed up import? I’m down to doing batches of 500 members - which can take anywhere from 70-200+ seconds, depending (on what, I’m not sure).

Can I modify cp.member_import.php to disable a uniqueness check on usernames? Can I modify it to optimize it in any other way? Can I revert to some custom SQL? Any other suggestions?

[mod: moved to how to forum]
#2 / Oct 29, 2007 8:15am

Derek Allard
3168 posts

[edit: this isn’t a double post, but I’m going to close it anyway to keep the talk in one thread]

This discussion is very similar to this thread. I’m closing this thread to keep all discussion in 1 place.