Patt Just one file that is currently 1,604,773 Kb It is the project_N.CDX file. My understanding is that Visual FoxPro has an absolute limit of 2Gb for any one file, and so if a file hits 2Gb the project database becomes unusable. Regards Darryl _______ Interested in the British peerage? See my website at www.thepeerage.com > On 21/11/2017, at 9:00 PM, [email protected] wrote: > > Send TMG mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists2.rootsweb.ancestry.com/mailman/listinfo/tmg > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of TMG digest..." > > > The TMG archive is at: http://archiver.rootsweb.ancestry.com/th/index/TMG/ > How to subscribe to TMG is at: http://lists.rootsweb.ancestry.com/index/other/Software/TMG.html > > Today's Topics: > > 1. Re: Fwd: TMG Digest, Vol 12, Issue 516 (Patt Ricketts) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Mon, 20 Nov 2017 11:03:26 -0800 > From: Patt Ricketts <[email protected]> > To: The Master Genealogist Rootsweb Email List <[email protected]> > Subject: Re: [TMG] Fwd: TMG Digest, Vol 12, Issue 516 > Message-ID: > <[email protected]om> > Content-Type: text/plain; charset="UTF-8" > > Darryl, > > When you talk about TMG's 2Gb limit. Is that the total for a project or do > you have 1 file in the project that is 1.6Gb? > > Patt Ricketts > > On Sat, Nov 18, 2017 at 7:51 PM, Darryl Lundy <[email protected]> wrote: > >> Just to throw in some trivia. >> My machine currently takes 61 minutes to create a web site using Second >> Site - 703,000 people with 14,000 exhibits. >> The same machine (Mac Pro with SSD drives and 64Gb of RAM) takes around 28 >> hours to export a Gedcom from TMG. >> The SS speed I can live with - an hour means I have to take a break from >> data entry. 28 hours I can?t live with so I politely decline requests for >> gedcoms of my data, >> >> As an aside, my largest TMG file is now 1.6Gb, which is getting scarily >> close to TMG?s absolute 2Gb limit. So hoping HRE is ready in time! >> >> Regards >> Darryl >> >> _______ >> Interested in the British peerage? See my website at www.thepeerage.com >> >> >> >>> Begin forwarded message: >>> >>> From: [email protected] >>> Subject: TMG Digest, Vol 12, Issue 516 >>> Date: 19 November 2017 at 4:25:10 PM NZDT >>> To: [email protected] >>> Reply-To: [email protected] >>> >>> [email protected] <mailto:[email protected]> >> The TMG archive is found here: http://archiver.rootsweb. >> ancestry.com/th/index/TMG/ >> Instructions on how to subscribe to TMG: http://lists.rootsweb. >> ancestry.com/index/other/Software/TMG.html >> ------------------------------- >> To unsubscribe from the list, please send an email to >> [email protected] with the word 'unsubscribe' without the quotes >> in the subject and the body of the message > > > > > -- > Patt Ricketts > www.jackandpatt.com > > > ------------------------------ > > Subject: Digest Footer > > To contact the TMG list administrator, send an email to > [email protected] > > To post a message to the TMG mailing list, send an email to [email protected] > > __________________________________________________________ > To unsubscribe from the list, please send an email to [email protected] > with the word "unsubscribe" without the quotes in the subject and the body of the > email with no additional text. > > > ------------------------------ > > End of TMG Digest, Vol 12, Issue 524 > ************************************

At 11/21/2017 03:36, Darryl Lundy wrote >Just one file that is currently 1,604,773 Kb >It is the project_N.CDX file. How many people do you have in that project!? My main project has about 61,000 people and its _N.CDX file is 202,840 KB. This is the index file to the Name database of the project . Because TMG has many ways in which we can search for people, the Name database has a number of different ways in which it can be indexed for quick searching. Therefore, the index file fo the Name database is the largest index file and likely the largest file in the project. Most, if not all, other files will be much smaller in comparison. Lee

Just wonder what do you mean when saying unusable? The project_n.cdx file I have at current is now 2.066.031 kb....what is unusable ,what can`t be done when it is over 2GB? (I haven`t optimized etc for some weeks) -----Opprinnelig melding----- Fra: TMG [mailto:[email protected]] På vegne av Darryl Lundy Sendt: 21. november 2017 09:37 Til: [email protected] Emne: [TMG] 2Gb file limit Patt Just one file that is currently 1,604,773 Kb It is the project_N.CDX file. My understanding is that Visual FoxPro has an absolute limit of 2Gb for any one file, and so if a file hits 2Gb the project database becomes unusable. Regards Darryl _______ Interested in the British peerage? See my website at www.thepeerage.com > On 21/11/2017, at 9:00 PM, [email protected] wrote: > > Send TMG mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists2.rootsweb.ancestry.com/mailman/listinfo/tmg > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of TMG digest..." > > > The TMG archive is at: > http://archiver.rootsweb.ancestry.com/th/index/TMG/ > How to subscribe to TMG is at: > http://lists.rootsweb.ancestry.com/index/other/Software/TMG.html > > Today's Topics: > > 1. Re: Fwd: TMG Digest, Vol 12, Issue 516 (Patt Ricketts) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Mon, 20 Nov 2017 11:03:26 -0800 > From: Patt Ricketts <[email protected]> > To: The Master Genealogist Rootsweb Email List <[email protected]> > Subject: Re: [TMG] Fwd: TMG Digest, Vol 12, Issue 516 > Message-ID: > <[email protected]om> > Content-Type: text/plain; charset="UTF-8" > > Darryl, > > When you talk about TMG's 2Gb limit. Is that the total for a project > or do you have 1 file in the project that is 1.6Gb? > > Patt Ricketts > > On Sat, Nov 18, 2017 at 7:51 PM, Darryl Lundy <[email protected]> wrote: > >> Just to throw in some trivia. >> My machine currently takes 61 minutes to create a web site using >> Second Site - 703,000 people with 14,000 exhibits. >> The same machine (Mac Pro with SSD drives and 64Gb of RAM) takes >> around 28 hours to export a Gedcom from TMG. >> The SS speed I can live with - an hour means I have to take a break >> from data entry. 28 hours I can?t live with so I politely decline >> requests for gedcoms of my data, >> >> As an aside, my largest TMG file is now 1.6Gb, which is getting >> scarily close to TMG?s absolute 2Gb limit. So hoping HRE is ready in time! >> >> Regards >> Darryl >> >> _______ >> Interested in the British peerage? See my website at >> www.thepeerage.com >> >> >> >>> Begin forwarded message: >>> >>> From: [email protected] >>> Subject: TMG Digest, Vol 12, Issue 516 >>> Date: 19 November 2017 at 4:25:10 PM NZDT >>> To: [email protected] >>> Reply-To: [email protected] >>> >>> [email protected] <mailto:[email protected]> >> The TMG archive is found here: http://archiver.rootsweb. >> ancestry.com/th/index/TMG/ >> Instructions on how to subscribe to TMG: http://lists.rootsweb. >> ancestry.com/index/other/Software/TMG.html >> ------------------------------- >> To unsubscribe from the list, please send an email to >> [email protected] with the word 'unsubscribe' without the >> quotes in the subject and the body of the message > > > > > -- > Patt Ricketts > www.jackandpatt.com > > > ------------------------------ > > Subject: Digest Footer > > To contact the TMG list administrator, send an email to > [email protected] > > To post a message to the TMG mailing list, send an email to [email protected] > > __________________________________________________________ > To unsubscribe from the list, please send an email to > [email protected] with the word "unsubscribe" without the > quotes in the subject and the body of the email with no additional text. > > > ------------------------------ > > End of TMG Digest, Vol 12, Issue 524 > ************************************ The TMG archive is found here: http://archiver.rootsweb.ancestry.com/th/index/TMG/ Instructions on how to subscribe to TMG: http://lists.rootsweb.ancestry.com/index/other/Software/TMG.html ------------------------------- To unsubscribe from the list, please send an email to [email protected] with the word 'unsubscribe' without the quotes in the subject and the body of the message