100k is kind of where you can start to notice the difference, and then it depends on the size of each record and the number of Indexes as to how much of a difference. 100K of a small form, probably no difference. 100k of a large form with 8+ indexes, probably so.
Rick -----Original Message----- From: Misi Mladoniczky <[email protected]> Date: Tue, 4 May 2010 18:37:04 To: <[email protected]> Subject: Re: UNIX to Windows Remedy Migration Hi, RRR|Chive can drop indexes and recreated after the migration. Have you really seen a big speed difference by doing this? I measured the time for a 100k form with a lot of indexes, and could not see any difference in the speed. I do not remenber which database it was though... Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > If you are going to use an AR method or tool to do data imports, be sure > to drop the indexes on forms that have more than about 100k records. That > will speed the import process significantly. Once the data is imported, > add the indexes back in. > > Rick > > -----Original Message----- > From: Tim Palmer <[email protected]> > Date: Tue, 4 May 2010 10:03:59 > To: <[email protected]> > Subject: Re: UNIX to Windows Remedy Migration > > I've done this migration about 5 or 6 years ago. In my opinion that was > the best decision my company made at that time. And yes I'm bias to SQL > server database. The easiest option is to use AR Import to migrate your > data to the new platform. Hopefully you have a programmer who can write > you some windows scripts to run these imports for you. The smaller forms > you can do a full copy and the larger forms it will run based on a date > range. These windows scripts can be set to run at night so you don't have > to watch it and it will not impact your current production during peak > hours. Make sure to have some sort of data integrity check to validate > all > data was migrated over. > > Thanks, > > Timothy Palmer > > > > > Ex Soundgarden > <thewallstre...@y > AHOO.COM> To > Sent by: "Action [email protected] > Request System cc > discussion > list(ARSList)" Subject > <arsl...@arslist. UNIX to Windows Remedy Migration > ORG> > > > 05/04/2010 02:36 > AM > > > Please respond to > [email protected] > RG > > > > > > ** > > Hi ARSListers! > We're currently planning to migrate existing Remedy environment in Sun > Solaris to Windows Server. Below is the current system information: > > ARS 7.0.1 p10 running on Sun Solaris 10 > Oracle 10g running on the same server > Mid-tier 7.0.1 patch 6 running on MS Windows Server 2003 > Memory size 8GB > 4 UltraSPARC-IIIi virtual processors each running on 1.6GHz > No ITSM applications installed. AR System is used for in-house developed > applications (consisting of 1052 forms). > average of 60-70 concurrent users. 600 registered users > > > Initial possible scenario I’m currently looking at 2 options below: > > 1.Upgrade Remedy Server to latest version, purchase new hardware, and use > the same platform (Solaris 10) . > > OR > > 2. Full migration to Windows Server 2008, including the database > migration > to SQL Server 2008. This is to reduce the cost of our support and > maintenance for the servers > > Please give me any advice if what option is the best to implement. I’m > really keen on just using the same platform (Solaris) but we currently > don’t have any Solaris/Oracle support which pretty much led us to > looking > at the Windows migration. If you can list all the pros and cons on doing > any of the options, that will surely help me. > > In addition to that, may I know if anyone here has any experiences > migrating from Unix to Windows environment recently or in the past? If > you > can let me know your success stories (and migration strategy), it would > be > greatly appreciated. > > Any good inputs will be appreciated. > Regards... > Gabud > > >_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > This email message and any attachments are for the sole use of the > intended recipient(s) and may contain information that is > proprietary to Ahold and/or its subsidiaries (Ahold) or otherwise > confidential or legally privileged. If you have received this > message in error, please notify the sender by reply, and delete all > copies of this message and any attachments. If you are the intended > recipient you may use the information contained in this message and > any files attached to this message only as authorized by Ahold. > Files attached to this message may only be transmitted using secure > systems and appropriate means of encryption, and must be secured > using the same level of password and security protection with which > the file was provided to you. Any unauthorized use, dissemination > or disclosure of this message or its attachments is strictly > prohibited. > > -- > This message was scanned by ESVA and is believed to be clean. > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
