Jim Lawrence
accessd at shaw.ca
Sun Mar 9 19:18:22 CDT 2014
Hi John: "I was able to get (7) 200gb SSDs and form the raid array..." OMG...every home should have one. ;-) I know we have gone through this discussion before but given the amount of data you are working with and the complexity of the searches required, I would be so bold as to suggest that you at least look at the following technology from ElastciStretch: http://www.elasticsearch.org ...and... http://www.elasticsearch.org/resources < check out the webinar... The system in a nutshell is text based. The number of rows (document) is dependant on the hardware and can handle thirty-thousand plus columns. It indexes everything and it is quick; according to the webinar, one TB can be indexed in about 90 seconds. The application can group millions of rows of data in milliseconds. The data can be limited to a single directory, a HD, a computer or a whole cluster. Jim ----- Original Message ----- From: "John W Colby" <jwcolby at gmail.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Sunday, March 9, 2014 3:39:30 PM Subject: Re: [AccessD] apocalypse someday... >>An aside but a worthy note: Was at a friends place the yesterday and his recommendation is to never use a SSD in a RAID...all SSD or none...there is nothing like learning the hard way. LOL, I have a 1 terabyte raid 5 array with hot backup. It is not for speed but for redundancy. That said, striping the data across 5 drives ups the transfer speed immensely. Of course the array is hosted on a dedicated raid card, NOT on the built-in SATA ports. I was able to get (7) 200gb SSDs and form the raid array for under $2000 including the cost of the card. It is for my large databases on my SQL Server and it absolutely smokes loading stuff into RAM. Since I have 90GB of RAM dedicated to the SQL Server, being able to load RAM quickly becomes an issue. With a RAID array and a dedicated controller I get over 1 gb / sec load speeds off of two year old technology drives (SATA3). I will be replacing those in the next few months with new Samsung EVO drives and probably doubling that speed. Loading large database containers into SSDs is one area where the benefit pays for itself quickly. John W. Colby Reality is what refuses to go away when you do not believe in it On 3/9/2014 4:42 PM, Jim Lawrence wrote: > Hi Bill: > > An aside but a worthy note: Was at a friends place the yesterday and his recommendation is to never use a SSD in a RAID...all SSD or none...there is nothing like learning the hard way. > > Jim > > ----- Original Message ----- > From: "Bill Benson" <vbacreations at gmail.com> > To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> > Sent: Sunday, March 9, 2014 11:08:25 AM > Subject: Re: [AccessD] apocalypse someday... > > Along the lines of SSD upgrade...I am considering upgrading my DELL E6530 > HDD to a SSD. > > I think with DELLs I can rely on the CD ROM Bay accepting a 2nd hard drive > caddy - for between $30-$50. I don't know the speed it is capable of, but it > would give me a place have the two drives in the laptop at the same time, > and I rarely use the CD/DVD. > > If I were to migrate my current drive which is 750GB but using < 300GB to a > 500GB Crucial SSD, would I have problems? > > Does anyone know whether using the installed Acronis software's Clone > function (while Win 7 is running) will be a safe way to get the new drive > operational? > > Will the result be optimized for that new drive, or will I have wished I had > done a clear install and put all my programs on again (sigh...) > > Another alternative is to "Recover" a TIB stored either on the older HDD, or > on Buffalo Linkstation, to the new drive. This could be done (1) using > bootable Acronis media, if the new drive is put into the HDD bay, or (2) > using Acronis software with the old drive still in the HDD bay and the new > drive in the CD ROM bay, or vice versa... OR SO I THINK. > > Last, if any of those approaches work, I should be able to then put the old > HDD in modular bay, in a caddy, and put the new SSD in the DELL HDD port, at > which point I probably need to buy an adaptor so it fits in there with the > right form factor. > > I am assuming that DELL treats whatever is in the HDD bay as primary, and > anything in the modular bay as secondary, but I hardly know. > > So to rack 'em up, need to purchase: > 2.5" SSD > 2.5" internal caddy for DELL HDD > 9" modular bay HDD caddy for 2.5" drives > > --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com