Welcome to Forums Sign in | Join | Help | Forums
in Search





Make the world a better place.
Home Blogs Forums Photos Downloads
Forums » Product Forums » The Raiser's Edge » Administration and Configuration » Queue; multiple queries to be refreshed

Queue; multiple queries to be refreshed

Last post 08-05-2008 5:20 PM by Tracie Cassidy. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 07-29-2008 3:12 PM

    • Faith Danforth
    • Top 75 Contributor
    • User Since: 2000
    • Posts 81
    • Organization: Mercy Corps
    • Products:  The Raiser's Edge

    Queue; multiple queries to be refreshed

    Reply Contact

    Hello,

     I'd love your thoughts on how to approach the following issue:

    I have a monthly process that entails refreshing 15-20 queries with a specific date range (i.e. June 20-July 21) and then doing 5-6 exports based off of various of the queries.

     Currently, the process takes 4-6 hours due to the size and complexity of the queries and exports. 

     We have RE:QUEUE.  However, it cannot auto-advance the dates to the next month.  Thus I must either be there to refresh the dates using an ask operator, or I must manually perform the process. 

     Any thoughts at all would be appreciated, including customization suggestions using VBA or API or another appropriate methodology.

     Many thanks!

    Faith

    Faith Danforth
    Database Manager
    Mercy Corps
    Portland, OR
    Filed under: , , ,

  • 08-05-2008 5:20 PM In reply to

    • Tracie Cassidy
    • Top 10 Contributor
    • User Since: 2002
    • Posts 467
    • Organization: Children's Hospital Foundation
    • Products:  The Raiser's Edge

    Re: Queue; multiple queries to be refreshed

    Reply Contact

    Faith - Our DBA (in the IS dept) runs them using SQL for us. Saves me a bunch of time! Once he refreshes everything, I just export the data.

    Tracie J. Cassidy
    Database Coordinator
    Seattle Children's Hospital Foundation
    Seattle, WA
Page 1 of 1 (2 items)