On second glance it also appears that there is no indexing on the tmp tables created during the import process which slows things considerably as well.
-Austin
Search found 2 matches
- Wed Nov 28, 2007 2:23 am
- Forum: Using OpenEMM
- Topic: Very slow Recipient Import
- Replies: 12
- Views: 17889
- Wed Nov 28, 2007 2:06 am
- Forum: Using OpenEMM
- Topic: Very slow Recipient Import
- Replies: 12
- Views: 17889
I have seen this problem and the single issue is that none of the tables have more than one index on them (primary key) which causes everything to be very slow. Rule of thumb: If you are looking up a field (column) in WHERE or ORDER BY that field needs to have an index. Yes you can end up with a lot...