Average Time to Export a Custom Report?

That sounds about right.  It depends on how many records and what type of fields you use. I have reports that take 2 hours or more, but those containover 20,000 records.  I also find that reports where I am exporting attributes take longer.

Josh Bekerman:

  If you are exporting summary fields try having the report do the work instead, if possible (instead of exporting total giving do the calculations in the report).  I've never actually tested if that helps but it sure does make me feel better. 

I'm wondering if this might also be due to all of the different SQL tables the export is pulling from.  (If you've never done it, take a look at the RE7 schema and, for example, figure out how many tables are involved just to pull phone numbers from preferred addresses.  It's a great way to spend a weekend afternoon. )  I'm not a SQL guru (and I don't play one on tv) so I have no idea if this has anything to do with it.  Even so, there's probably nothing you could do about it, but I'll mention it anyway.

For comparative purposes, I have an export that pulls:



Constituent info with primary business and education

Spouse info with primary business and education

Addressees

Constituent codes

Multiple addresses and phones

Several attributes

Prospect Ratings

Proposals and linked actions

Gifts to other orgs

Assigned solicitors

Organization relationships

Individual relationships

All gifts, with Campaign, Fund Appeal, Notes

Current membership

A bunch of actions

Notepads of certain types

Event participations with event info

First gift with Campaign Fund Appeal (I realize I could calculate this in the report; not sure why I didn't)

Volunteer type status and job assignments



EDIT: it's about 135 fields, except that it's exporting into access so it could actually be multiples of each field.



We use it to run a bio, generally for one person at a time.  I just ran it for a couple of our donors with the most information, and it took anywhere from 15 to 25 seconds for each export.





 

Thomas Luo:

James Andrews:



EDIT: it's about 135 fields, except that it's exporting into access so it could actually be multiples of each field.



We use it to run a bio, generally for one person at a time.  I just ran it for a couple of our donors with the most information, and it took anywhere from 15 to 25 seconds for each export.





 

Hi James, 135 fields seems like a lot! How long does it take if you do not do it one person at a time?



My organization's plan will be to see if we can clean up some static queries (we have over 2500 just in General) and see if that helps at all. Not quite sure if it will help. We do indeed pull all their media info, notes, etc, as the whole point of exporting that particular record is to gather basic constituent data on our donors (I had to verify this with our database administrator).

 

I'm keen to know this too, only we host RE ourselves.

Thanks Josh