> 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 **********************************************************************