Jim,
By "chunk out", you mean export large tables in separate "batches" -
xx records at a time, then import each .ARX individually, right?
Mike White
Office: 813-978-2192
E-mail: [EMAIL PROTECTED]
"McKenzie, James J
C-E LCMC To: [email protected]
HQISEC/L3" cc:
<[EMAIL PROTECTED] Subject: Re: Upgrading Remedy
- 4.5 to 6
S.ARMY.MIL>
Sent by: "Action
Request System
discussion
list(ARSList)"
<[EMAIL PROTECTED]
RG>
07/20/2006 12:32
Please respond to
arslist
**
Shawn:
Chunk out the data for the large forms. This should eliminate the timeout
error.
James McKenzie
-----Original Message-----
From: Action Request System discussion list(ARSList) [
mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist
Sent: Thursday, July 20, 2006 9:29 AM
To: [email protected]
Subject: Upgrading Remedy - 4.5 to 6
Greetings List!
We are currently working on upgrading our Remedy from 4.5 to 6 (woo hoo!)
and have new servers, databases, etc. that we will be using.
In the past when we've migrated/moved our Remedy, we have moved the data by
exporting it through the User Client (our largest form was only 45k
entries, followed by a 25k entry form). Today however, we have at least a
dozen forms with 60k+ (several with 200k+) and are encountering timeouts
and other performance issues when trying to export the data to be moved.
The last time we tried moving the data from one DB to the new DB, it all
but blew up.
We are wondering if anyone else has had to move (what we consider) large
amounts of data and knows of a more efficient way to do this.
Thank you VERY much in advance for your assistance!
Shawn Stonequist
EMNS, Inc.
Remedy 4.5
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
__20060125_______________________This posting was submitted with HTML in
it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
