External, non-rack mount, RAID boxes: you can pick up a decent RAID box for about $300 (5 drives, hardware RAID 5) https://oyendigital.com/hard-drives/store/3R5-EB3-M.html
you can pick up a Very Nice raid box for about $1500 (8 bays, RAID 5 or RAID 6) http://www.highpoint-tech.com/USA_new/main.htm Filling them is bit pricier... using spinning rust you can fill with enterprise disks (5year warrantee) for between $180 - $425/disk depending on capacity (4TB - 12TB) filling with ssds well... 1TB start at $230 /drive- and 4TB are $1350/drive (all prices from www.Newegg.com) buy 2 and mirror them. On Mon, 23 Apr 2018 22:35:18 +0200, Paul Lovejoy via 4D_Tech wrote: > We have SSD. A high speed RAID is another story. > > >> Le 23 avr. 2018 à 10:59, Wayne Stewart via 4D_Tech >> <[email protected]> a écrit : >> >>> I don’t have the luxury of installing an SSD RAID. >> >> A 512GB SSD is less than $200 >> https://www.amazon.com/Samsung-500GB-Internal-MZ-76E500B-AM/dp/B0781Z7Y3S/ >> >> or just over if you go for the pro version with the 5 year warranty >> https://www.amazon.com/Samsung-512GB-Inch-Internal-MZ-76P512BW/dp/B07836C6YV/ >> >> >> >> >> >> <https://www.amazon.com/Samsung-2-5-Inch-Internal-MZ-75E500B-AM/dp/B00OBRE5UE/ref=sr_1_5?s=pc&ie=UTF8&qid=1524473660&sr=1-5&keywords=512gb+ssd> >> >> Regards, >> >> Wayne >> >> >> [image: --] >> Wayne Stewart >> [image: http://]about.me/waynestewart >> <http://about.me/waynestewart> >> >> >> On 23 April 2018 at 15:51, Paul Lovejoy via 4D_Tech <[email protected]> >> wrote: >> >>> Chuck, >>> >>> You know the old saying: “A watched pot never boils.” >>> Watching 4D reload the same table with 7 million records 8 times to >>> generate 8 indexes is kind of like that. >>> >>> I don’t have the luxury of installing an SSD RAID. I’m sure better >>> hardware would help. >>> >>> >>> >>> Paul >>> >>> >>>> Le 23 avr. 2018 à 04:20, Chuck Miller via 4D_Tech <[email protected]> >>> a écrit : >>>> >>>> OK I don;t get it. We have a data base of over 200 Gig with many >>> millions of records. We run using SSD,s in an Areca RAID. 1 Terabyte SSDs. >>> I can tell you that when we restored from a backup up and rebuilt indices >>> it took not more than 20 minutes to so. It does not matter if it is by >>> table or not. Yes I agree it would be faster by table but with a database >>> of this size, you really need to be running on an SSD RAID. >>>> >>>> Regards >>>> >>>> Chuck >>>> ------------------------------------------------------------ >>> ------------------------------------ >>>> Chuck Miller Voice: (617) 739-0306 >>>> Informed Solutions, Inc. Fax: (617) 232-1064 >>>> mailto:cjmiller<AT SIGN>informed-solutions.com >>>> Brookline, MA 02446 USA Registered 4D Developer >>>> Providers of 4D and Sybase connectivity >>>> http://www.informed-solutions.com >>>> ------------------------------------------------------------ >>> ------------------------------------ >>>> This message and any attached documents contain information which may be >>> confidential, subject to privilege or exempt from disclosure under >>> applicable law. These materials are intended only for the use of the >>> intended recipient. If you are not the intended recipient of this >>> transmission, you are hereby notified that any distribution, disclosure, >>> printing, copying, storage, modification or the taking of any action in >>> reliance upon this transmission is strictly prohibited. Delivery of this >>> message to any person other than the intended recipient shall not >>> compromise or waive such confidentiality, privilege or exemption from >>> disclosure as to this communication. >>>> >>>>> On Apr 22, 2018, at 6:40 AM, Arnaud de Montard via 4D_Tech < >>> [email protected]> wrote: >>>>> >>>>>> >>>>>> I guess our database of 120gb, running on a 32 bit machine doesn’t >>> benefit from this. We were working on the most recent R release and >>> yesterday we went to 15.5. >>>>>> When reindexing the entire database, 4D Server/4D are still going >>> index by index instead of table by table. >>>> >>>> ********************************************************************** >>>> 4D Internet Users Group (4D iNUG) >>>> FAQ: http://lists.4d.com/faqnug.html >>>> Archive: http://lists.4d.com/archives.html >>>> Options: https://lists.4d.com/mailman/options/4d_tech >>>> Unsub: mailto:[email protected] >>>> ********************************************************************** >>> >>> ********************************************************************** >>> 4D Internet Users Group (4D iNUG) >>> FAQ: http://lists.4d.com/faqnug.html >>> Archive: http://lists.4d.com/archives.html >>> Options: https://lists.4d.com/mailman/options/4d_tech >>> Unsub: mailto:[email protected] >>> ********************************************************************** >>> >> ********************************************************************** >> 4D Internet Users Group (4D iNUG) >> FAQ: http://lists.4d.com/faqnug.html >> Archive: http://lists.4d.com/archives.html >> Options: https://lists.4d.com/mailman/options/4d_tech >> Unsub: mailto:[email protected] >> ********************************************************************** > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** --------------- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
