Support forums

Please check @brandnewbox_uk for support status updates.

Search     Advanced Search
Importing CSV data with Relationships - slow  
Posted: 07 May 2019 03:27 PM —  
Newbie
Rank
Total Posts:  10
Joined  2013-05-21

Andrew,

Are imports involving Relationship fields known to be slow and/or taxing from a database perspective?

I have a data file with over 300 records. There are about 9 columns of data, one of which is a relationship.

It takes about 25 seconds to import 40 rows, which is what I have set for a batch. I don’t do all 300+ at a time because there are times the process reaches the server max timeout.

The import itself works, and I can probably deal with the slowness, but I’m planing for when there are 500+ rows and want to make sure I can address bottlenecks.

Here are a few sample rows:

https://www.dropbox.com/s/h62xr7py1084zzv/2019-05-07_10-25-17.png?dl=0

It’s a fairly basic tab separated file. The pink column represents the relationship field. 3 rows relate to one entry id, and the other 3 entries relate to another.

Is there a config setting (DataGrab, or in EE’s channel settings, etc) that might speed things up?

Thanks!

Profile
 

‹‹ "Page not found" when the import runs      Dealing with failed response from externalAPI ››

Select A Theme