Export time?

Jason Roberson

My users are complaining that exports are taking a very long time. It looks like they are exporting 138 item for around 175K records and its taking about 2 hours and 40 minutes. We are self-hosted with our SQL DB in a cluster. Does this sound normal?

 

Alicia Barevich

It depends what tables those 138 fields are pulling from, but that actually sounds like a fairly quick export time for that amount of data!

James Andrews

That sounds pretty reasonable for that much data, especially if any of the fields are calculated (gift/action summaries, first/latest/greatest, etc). Also anything involving events or memberships can slow things down.


But overall, that doesn't sound too bad! 

Jason Roberson

I found the cause of my issue some users were saving back to a share on their local PC instead of saving to the mapped drive on the server. Depending on their site location this was causing a large increase in export times. From Citrix policies I have blocked mapping of client drives.