We have SSD. A high speed RAID is another story.
> Le 23 avr. 2018 à 10:59, Wayne Stewart via 4D_Tech <4d_tech@lists.4d.com> 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 <4d_tech@lists.4d.com> > 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 <4d_tech@lists.4d.com> >> 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 < >> 4d_tech@lists.4d.com> 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:4d_tech-unsubscr...@lists.4d.com >>> ********************************************************************** >> >> ********************************************************************** >> 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:4d_tech-unsubscr...@lists.4d.com >> ********************************************************************** >> > ********************************************************************** > 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:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 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:4d_tech-unsubscr...@lists.4d.com **********************************************************************