Lee Hoffman wrote: > Of course, this makes it harder to automate plugging the > ID# into the Reference Field. John Cardinal may be able > to suggest something that would mitigate this problem > using his TMG Utility. As Joyce mentioned, TMG Utility can be used to create a reference field value. The basic steps are to (1) create a data file with two columns: - ID of person - Value for reference field) ... and then (2) ask TMG Utility to use the data file to update your project via the "Set Person Field" feature. One way to make the data file is to use a List of People (LoP) report. You create a two-column list where both columns have the same value, the ID number. Configure the LoP to create a tab-delimited output file. On the Report Definition Screen, set "File type" to "Text (ASCII) Delimited with Tab". To make the second column values start with leading zeroes, you must edit the data file prior to using it with TMG Utility. One relatively easy way to do it is to open the data file in Excel or another spreadsheet program. Change the format of the second column to a number with a fixed-width. In Excel, you'd use a custom cell format of "000000000". Nine zeroes will handle IDs up to single-digit millions. To change the format of a column in Excel, right-click the column header and choose Format Cells. In the Format Cells window, change the Category to "Custom" and then key "000000000" in the "Type:" textbox. After you make that format change, save the file. Use "Save As" in Excel to make sure you save it as a tab-delimited file, which I think Excel calls "Text (Tab-delimited)". John

Truncating and overwriting aren`t good. But what to do now? and after that, how splitting the project I have? What to do now?..... Before I think I can split anything I have another problem (which may be no problem??)....I am doing some maintenance on the people in my large project. (And to this job it is very convenient to have the IDs I have done various reports to find ,and use them in my large project where all the people are....): It is editing on the people such as deleting some name-var tags ,editing some divorces (which came double up after a gedcom import) ,changing some special letters in occupations etc ,confirmation without a year ,editing unknown sex, putting dates to burial info ,looking into people listed with no children ,go through notes on people (taken from an old genealogyprogram), editing marriages for people without marriagedates..... also have some records to go through from TMG 4 and get them into TMG 9 which includes......editing certain special letters after gedcom import ,children out of wedlock ,adopted ,stillbirths ,twins/triplets etc ,editing addresses ,burials. If I split my large project ,many of these people probably will not show up ,at least not with the same ID number ,and I will have to go through a dozen of projects to find where they are located for getting the chance to edit them. With that said ,I also realize it may not be advisable/safe to edit them in my large project either ,but it had been the easiest......so what should I do? Edit them in my large project and risk getting my project totally corrupted ,or split it and have a difficult time refinding all the people because of new IDs and not knowing for sure where to refind them??? When it comes to splitting ,I think maybe I should make a "close ancestor" main project that goes fom me and back to my greatgreatgrandparents ,and then a project for each of these` families. My father`s father and mother is not closely related. My mother`s parents are not related very closely either so should be no problem splitting in 2 x greatgrandparents there. My mother`s father`s parents were related from 200 years back. My mother`s father`s grandparents were 2nd cousins ,and so were two of their grandparents again ,so it would be some "double cousins" there....hopefully it would not be any problem?. Guess finding double people in 17 projects wouldn`t be too hard though....(lot of cross checking....) I know my ancestors very far back in history ,and have for curiosity taken it very far back ,that would say way before Charlemagne (only for fun and not for use..). My parents were 16th cousins I believe ,but will not be able to find their relationship with splitting the project because they will be in probably several different projects. Anyway ,I agree that it is much better to split the project I have in 16+1 different projects than having all in one with over a million people. But first ,I have to know what to do with that "editing problem"....!!. Should I keep on with editing in the large project which is the easiest or split up and letting it be harder to edit the ones I want to edit? Thanks Erik -----Opprinnelig melding----- Fra: TMG [mailto:[email protected]] På vegne av Michael J Hannah Sendt: 22. november 2017 01:48 Til: TMG-L submission address <[email protected]> Emne: Re: [TMG] 2Gb file limit Dennis Lee Bieber replied: > VFP can only address bytes 0 to 2147483647. > At best, it will refuse to save any record that would require > exceeding the 2GB boundary. > At worst, it wraps around and corrupts data ... a negative offset Actually, as a retired computer geek who was involved in the Y2K issues, wrap around can be even worse. Rather than a negative offset it is more likely to truncate, overwriting your oldest data. 2147483647+1 => 0 2147483647+2 => 1 ... Yes, Erik, you really, Really, REALLY!! need to split your project into multiple projects. You worried that: > I can`t split the project since all of the people are connected to me > somehow. > The focus with that project has been starting with me and then > entering as many ancestors I knew ,and then also go on to all I could > find of descendants of all the siblings and halfsiblings of my > ancestors etc. Well, you are now "cursed" by your success at finding so many relations. I would suggest splitting based on some level of direct ancestor. I would first split off a "close ancestor" main project trimmed to a project that only goes back on the direct line from you to some set of selected direct ancestors. The level back does not have to be consistent, it could depend upon keeping the number of people which would be included in each of the split projects roughly the same. This main project would include all these direct-line ancestors descendants, and those descendants ancestors, but not the selected ancestor's own ancestors nor their siblings. I would then split off separate non-main projects based on these selected ancestors. For example selecting all 3*great grandparents could result in 16 projects, or 6*great could be 128+1 projects, whatever level you think you might need. Each X*grandparent project would include only that person, their direct ancestors and siblings, plus all these people's siblings, descendants and ancestors. But it would not include this X*grandparent's descendants and relations since they are in the main project. Yes, you may wind up with duplicates in multiple projects if there are cross marriages among descendants or ancestors. You will have to examine the projects to find these. Then I would probably create some custom tags which would tell me something like: "All the descendants (or ancestors) of this individual may be found in project XYZ." That could let you limit that duplicate descendant or ancestor line to a single project as well as help you locate them. Hope this gives you ideas, Michael 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

Erik has a very unique problem with his million-plus people project. I am offering to personally help him accomplish his splitting, but suggest it may be time to continue this discussion and provide suggestions off-list directly with Erik. By the way, you need a current version of Excel to handle the list of ID numbers of his quantity of people, and even Excel can barely handle his list as its max is only 1,048,576 rows. Michael

At 10:13 AM 11/22/2017, Erik Hov wrote: >I am not too technical into all this ,but if 4 GB is the limit ,then I >should have no problem..... No -- most 32-bit Windows applications are limited to 2GB. The file-system can theoretically go to 4GB but applications using signed integers get confused (I think the only 4GB files I ever saw on 32-bit Windows were video files -- DV-AVI runs 13GB per hour of Video; video capture software would split the files; same for ZIP utilities). Visual FoxPro probably only used signed integers (typically the only languages that supported unsigned integers were those meant for writing to actual hardware or low-level processing). And if the program used memory-mapped files it would be limited to the user-space of Windows -- which was 2GB; the second 2GB memory space was allocated to the OS. -- [email protected] Dennis Lee Bieber HTTP://home.earthlink.net/~bieber.genealogy/

At 11/22/2017 09:42, Joyce wrote >You might consider using the Reference field to store each person's ID >numbers. The Reference field is searchable using TMG's Search function (from >the menu: Edit / Find a Person / Search by Reference Number). Then once you >split the database you can still find someone with that search. It's also >possible to include the reference number in the picklist (pull up the >picklist and select the Options button)... the only issue there is that the >reference number is an alpha-numeric field and sorts as text rather than as >a number, so you would get an order like 1, 11, 111, 2, 21, 211, 3, etc... >no good for sorting but might be handy for your purposes. Joyce has a good idea here and also a good warning about how numbers are treated in the Reference field as opposed to how numbers are normally treated. You can get textual numbers sorted in the proper sequence IF all numbers have the same number of characters. You would do this by adding zeros prefixing the numbers -- like 001, 011, 012, 002, 021, 023, 003, etc. This would allow sorting to be normal. Of course, this makes it harder to automate plugging the ID# into the Reference Field. John Cardinal may be able to suggest something that would mitigate this problem using his TMG Utility. Lee

At 11/22/2017 05:34, Erik Hov wrote >What to do now?..... Before I think I can split anything I have another >problem (which may be no problem??)....I am doing some maintenance on the >people in my large project. (And to this job it is very convenient to have >the IDs I have done various reports to find ,and use them in my large >project where all the people are....): Yes, it would be much easier to do editing of the current project knowing who needs maintenance than trying to "re-find" those persons in split-out projects. From what you say, much of this will likely give you some added wiggle room IF the maintenance doesn't add any more than you take away. I usually find that in this kind of maintenance that for each person deleted (usually through merging of duplicates) I wind up adding one or to persons. If that holds for you, the prognosis is not that good as it would soon get you closer to disaster. Still, I think I would try it. But, I would create Backups often so that I could get back to a "safe" place if corruption begins. >also have some records to go through from TMG 4 and get them into TMG 9 >which includes......editing certain special letters after gedcom import >,children out of wedlock ,adopted ,stillbirths ,twins/triplets etc ,editing >addresses ,burials. If this involves adding new persons -- particularly new name records then I'd wait until I had split the project. This might well make it harder to process in that you'd have to bring them into v9 and then split them out to the new split projects. But that would be better than losing it all. >Anyway ,I agree that it is much better to split the project I have in 16+1 >different projects than having all in one with over a million people. >But first ,I have to know what to do with that "editing problem"....!!. >Should I keep on with editing in the large project which is the easiest or >split up and letting it be harder to edit the ones I want to edit? Of course, you know your data much better than I, but I think I would try splitting into fewer projects. I usually advocate a single project rather than multiple projects as it _is_ much easier to maintain and there are no duplicates to maintain. But, when faced with a limit as in your case, it really is not a choice except where the split occurs. Splitting into fewer subsets _usually_ requires fewer duplicates. It also makes working on the new projects to be much closer in feel to that of the current single project. On the other hand, if there are fewer inter-marriages/interactions between families in more project, then the 16+1 may be the way to go. I like the idea of the one umbrella project leading to the other 16 (or however many subset) projects. At this point, I think all we can do is make suggestions as we don't really know your data. But, as I noted above, the one thing that is paramount is to make backup often. And good luck! Lee

At 07:48 PM 11/21/2017, Michael J Hannah wrote: >Dennis Lee Bieber replied: >>VFP can only address bytes 0 to 2147483647. >>At best, it will refuse to save any record that would require >>exceeding the 2GB boundary. >>At worst, it wraps around and corrupts data ... a negative offset > >Actually, as a retired computer geek who was involved in the Y2K >issues, wrap around can be even worse. Rather than a negative >offset it is more likely to truncate, overwriting your oldest data. >2147483647+1 => 0 2147483647+2 => 1 ... Y2K wrap around was due to the use of an implied century with a 2-digit /decimal/ year. The 2GB limit is due to use of a /signed/ binary 32-bit integer rather than an /unsigned/ binary 32-bit integer (which would give a 4GB limit). The positive range of the integer uses 31-bits, it becomes negative when it overflows into the 32nd bit. {It's also a problem with anything written in Java -- which does not have an unsigned data type; and I don't know if it supports 64-bit integers either.} -- [email protected] Dennis Lee Bieber HTTP://home.earthlink.net/~bieber.genealogy/

Erik, You might consider using the Reference field to store each person's ID numbers. The Reference field is searchable using TMG's Search function (from the menu: Edit / Find a Person / Search by Reference Number). Then once you split the database you can still find someone with that search. It's also possible to include the reference number in the picklist (pull up the picklist and select the Options button)... the only issue there is that the reference number is an alpha-numeric field and sorts as text rather than as a number, so you would get an order like 1, 11, 111, 2, 21, 211, 3, etc... no good for sorting but might be handy for your purposes. I'm pretty sure there's a way to use John Cardinal's TMG Utility to get the ID numbers loaded into the Reference number field. I think it involves outputting your ID numbers using a TMG List of People report, then importing using a TMG Utility function. I don't know if doing that will expand the size of the large table and corrupt your database or not. It might be safer to do the import after splitting the database, just to keep from corrupting the database, but it would take a better expert than me to guide you through that process if you need help with it. Good luck with your database! Joyce Rivette -----Original Message----- From: TMG [mailto:[email protected]] On Behalf Of Erik Hov Sent: Wednesday, November 22, 2017 4:34 AM To: 'The Master Genealogist Rootsweb Email List' Subject: Re: [TMG] 2Gb file limit Truncating and overwriting aren`t good. But what to do now? and after that, how splitting the project I have? What to do now?..... Before I think I can split anything I have another problem (which may be no problem??)....I am doing some maintenance on the people in my large project. (And to this job it is very convenient to have the IDs I have done various reports to find ,and use them in my large project where all the people are....): It is editing on the people such as deleting some name-var tags ,editing some divorces (which came double up after a gedcom import) ,changing some special letters in occupations etc ,confirmation without a year ,editing unknown sex, putting dates to burial info ,looking into people listed with no children ,go through notes on people (taken from an old genealogyprogram), editing marriages for people without marriagedates..... also have some records to go through from TMG 4 and get them into TMG 9 which includes......editing certain special letters after gedcom import ,children out of wedlock ,adopted ,stillbirths ,twins/triplets etc ,editing addresses ,burials. If I split my large project ,many of these people probably will not show up ,at least not with the same ID number ,and I will have to go through a dozen of projects to find where they are located for getting the chance to edit them. With that said ,I also realize it may not be advisable/safe to edit them in my large project either ,but it had been the easiest......so what should I do? Edit them in my large project and risk getting my project totally corrupted ,or split it and have a difficult time refinding all the people because of new IDs and not knowing for sure where to refind them??? When it comes to splitting ,I think maybe I should make a "close ancestor" main project that goes fom me and back to my greatgreatgrandparents ,and then a project for each of these` families. My father`s father and mother is not closely related. My mother`s parents are not related very closely either so should be no problem splitting in 2 x greatgrandparents there. My mother`s father`s parents were related from 200 years back. My mother`s father`s grandparents were 2nd cousins ,and so were two of their grandparents again ,so it would be some "double cousins" there....hopefully it would not be any problem?. Guess finding double people in 17 projects wouldn`t be too hard though....(lot of cross checking....) I know my ancestors very far back in history ,and have for curiosity taken it very far back ,that would say way before Charlemagne (only for fun and not for use..). My parents were 16th cousins I believe ,but will not be able to find their relationship with splitting the project because they will be in probably several different projects. Anyway ,I agree that it is much better to split the project I have in 16+1 different projects than having all in one with over a million people. But first ,I have to know what to do with that "editing problem"....!!. Should I keep on with editing in the large project which is the easiest or split up and letting it be harder to edit the ones I want to edit? Thanks Erik -----Opprinnelig melding----- Fra: TMG [mailto:[email protected]] På vegne av Michael J Hannah Sendt: 22. november 2017 01:48 Til: TMG-L submission address <[email protected]> Emne: Re: [TMG] 2Gb file limit Dennis Lee Bieber replied: > VFP can only address bytes 0 to 2147483647. > At best, it will refuse to save any record that would require > exceeding the 2GB boundary. > At worst, it wraps around and corrupts data ... a negative offset Actually, as a retired computer geek who was involved in the Y2K issues, wrap around can be even worse. Rather than a negative offset it is more likely to truncate, overwriting your oldest data. 2147483647+1 => 0 2147483647+2 => 1 ... Yes, Erik, you really, Really, REALLY!! need to split your project into multiple projects. You worried that: > I can`t split the project since all of the people are connected to me > somehow. > The focus with that project has been starting with me and then > entering as many ancestors I knew ,and then also go on to all I could > find of descendants of all the siblings and halfsiblings of my > ancestors etc. Well, you are now "cursed" by your success at finding so many relations. I would suggest splitting based on some level of direct ancestor. I would first split off a "close ancestor" main project trimmed to a project that only goes back on the direct line from you to some set of selected direct ancestors. The level back does not have to be consistent, it could depend upon keeping the number of people which would be included in each of the split projects roughly the same. This main project would include all these direct-line ancestors descendants, and those descendants ancestors, but not the selected ancestor's own ancestors nor their siblings. I would then split off separate non-main projects based on these selected ancestors. For example selecting all 3*great grandparents could result in 16 projects, or 6*great could be 128+1 projects, whatever level you think you might need. Each X*grandparent project would include only that person, their direct ancestors and siblings, plus all these people's siblings, descendants and ancestors. But it would not include this X*grandparent's descendants and relations since they are in the main project. Yes, you may wind up with duplicates in multiple projects if there are cross marriages among descendants or ancestors. You will have to examine the projects to find these. Then I would probably create some custom tags which would tell me something like: "All the descendants (or ancestors) of this individual may be found in project XYZ." That could let you limit that duplicate descendant or ancestor line to a single project as well as help you locate them. Hope this gives you ideas, Michael 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 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 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 > ************************************

Sounds nearly dangerous..... -----Opprinnelig melding----- Fra: TMG [mailto:[email protected]] På vegne av Dennis Lee Bieber Sendt: 21. november 2017 18:30 Til: The Master Genealogist Rootsweb Email List <[email protected]> Kopi: 'The Master Genealogist Rootsweb Email List' <[email protected]> Emne: Re: [TMG] 2Gb file limit At 05:49 AM 11/21/2017, Erik Hov wrote: >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) Getting close -- 2GB is 2147483648 bytes and you are at 2115615744. VFP can only address bytes 0 to 2147483647. At best, it will refuse to save any record that would require exceeding the 2GB boundary. At worst, it wraps around and corrupts data (2147483647+1 => -2147483648 /a negative offset/) -- [email protected] Dennis Lee Bieber HTTP://home.earthlink.net/~bieber.genealogy/ 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

Dennis Lee Bieber replied: > VFP can only address bytes 0 to 2147483647. > At best, it will refuse to save any record that would require > exceeding the 2GB boundary. > At worst, it wraps around and corrupts data ... a negative offset Actually, as a retired computer geek who was involved in the Y2K issues, wrap around can be even worse. Rather than a negative offset it is more likely to truncate, overwriting your oldest data. 2147483647+1 => 0 2147483647+2 => 1 ... Yes, Erik, you really, Really, REALLY!! need to split your project into multiple projects. You worried that: > I can`t split the project since all of the people > are connected to me somehow. > The focus with that project has been starting with me and then > entering as many ancestors I knew ,and then also go on to all > I could find of descendants of all the siblings and halfsiblings > of my ancestors etc. Well, you are now "cursed" by your success at finding so many relations. I would suggest splitting based on some level of direct ancestor. I would first split off a "close ancestor" main project trimmed to a project that only goes back on the direct line from you to some set of selected direct ancestors. The level back does not have to be consistent, it could depend upon keeping the number of people which would be included in each of the split projects roughly the same. This main project would include all these direct-line ancestors descendants, and those descendants ancestors, but not the selected ancestor's own ancestors nor their siblings. I would then split off separate non-main projects based on these selected ancestors. For example selecting all 3*great grandparents could result in 16 projects, or 6*great could be 128+1 projects, whatever level you think you might need. Each X*grandparent project would include only that person, their direct ancestors and siblings, plus all these people's siblings, descendants and ancestors. But it would not include this X*grandparent's descendants and relations since they are in the main project. Yes, you may wind up with duplicates in multiple projects if there are cross marriages among descendants or ancestors. You will have to examine the projects to find these. Then I would probably create some custom tags which would tell me something like: "All the descendants (or ancestors) of this individual may be found in project XYZ." That could let you limit that duplicate descendant or ancestor line to a single project as well as help you locate them. Hope this gives you ideas, Michael

I haven`t tested any DNA from my family....but we may be relatives far out ,who knows? -----Opprinnelig melding----- Fra: TMG [mailto:[email protected]] På vegne av Karla Huebner Sendt: 21. november 2017 17:44 Til: The Master Genealogist Rootsweb Email List <[email protected]> Emne: Re: [TMG] 2Gb file limit Dear Erik, Yes, it sounds possible that we have relatives in common, although probably not close ones. My family has done some DNA testing, so perhaps I should check my match lists for your email address, if you have tested any family. Karla <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free. www.avg.com <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> Karla Huebner calypsospots AT gmail.com On Tue, Nov 21, 2017 at 11:31 AM, Erik Hov <[email protected]> wrote: > Could be?..... > It`s different parts really....My mother`s father`s family comes from > Snertingdal , Nordre and Søndre Land in Oppland County. On that side > my 3 x greatgrandparents lived in Skien ,Telemark in 1900 ,but they > were from Snertingdal in Oppland Count and Nes in Hedmark County ,and > only lived in Skien for about 3 years. I also think that one of those > ancestors > (Hichmann) lived in Gjerpen ,Telemark. > My mother`s mother`s family comes from Møre and Romsdal and Rogaland > Counties. > My father`s family comes from Østfold County ,Sweden and his mother > was from Is in Østerdalen ,and she has ancestors in Os ,Kvikne and > Tolga in Østerdalen ,Hedmark. Also some relatives in Røros area ,Sør Trøndelag. > Also some more distant relatives in Norderhov area ,mostly who moved > there. It is said that one of my (8 x greatgrandfather or > something...) was born in Tinn ,Telemark ,but no one knows anything about that branch. > > -----Opprinnelig melding----- > Fra: TMG [mailto:[email protected]] På vegne > av Karla Huebner > Sendt: 21. november 2017 17:20 > Til: The Master Genealogist Rootsweb Email List <[email protected]> > Emne: Re: [TMG] 2Gb file limit > > Hi Erik, that's an amazing number of people. Which parts of Norway? > With that many people, it wouldn't be surprising if you have some of > my relatives in that database. My maternal great-grandparents were > from Fyresdal in Telemark and my paternal great-grandparents were from > Norderhov > (Buskerud) and Vinger (Hedmark). I've traced many Telemark and Hedmark > ancestors but have not gone very far back in Buskerud yet. > > Best wishes, > > Karla > > <http://www.avg.com/email-signature?utm_medium=email& > utm_source=link&utm_campaign=sig-email&utm_content=webmail> > Virus-free. > www.avg.com > <http://www.avg.com/email-signature?utm_medium=email& > utm_source=link&utm_campaign=sig-email&utm_content=webmail> > <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> > > Karla Huebner > calypsospots AT gmail.com > > On Tue, Nov 21, 2017 at 11:06 AM, Erik Hov <[email protected]> wrote: > > > Yes ,it is the largest file in the project ,and I have 1.011.960 > > people in the project. Since it takes time to search the name > > searchlist every time ,I have TMG in two windows ,one with only the > > namelist ,and one with the other info ,so I can easily go to the > > particular ID number. It saves much time since I don`t have to wait > > for the namelist first. > > > > -----Opprinnelig melding----- > > Fra: TMG [mailto:[email protected]] På > > vegne av Lee Hoffman/KY > > Sendt: 21. november 2017 16:50 > > Til: The Master Genealogist Rootsweb Email List <[email protected]> > > Emne: Re: [TMG] 2Gb file limit > > > > 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 > > > > 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 > > > > > > 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 > > > 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 > > > 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 > 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

Yes ,I am planning doing that very soon now because of the size.... -----Opprinnelig melding----- Fra: TMG [mailto:[email protected]] På vegne av [email protected] Sendt: 21. november 2017 17:37 Til: 'The Master Genealogist Rootsweb Email List' <[email protected]> Emne: Re: [TMG] 2Gb file limit Hi - I guess you will have already recently done a tidy-up - but you may find that the "full works" of VFI, organize and re-index (repeated a few times) gives you a little more head-room. Chris -----Original Message----- From: TMG [mailto:[email protected]] On Behalf Of Erik Hov Sent: 21 November 2017 16:07 To: 'The Master Genealogist Rootsweb Email List' Subject: Re: [TMG] 2Gb file limit Yes ,it is the largest file in the project ,and I have 1.011.960 people in the project. Since it takes time to search the name searchlist every time ,I have TMG in two windows ,one with only the namelist ,and one with the other info ,so I can easily go to the particular ID number. It saves much time since I don`t have to wait for the namelist first. -----Opprinnelig melding----- Fra: TMG [mailto:[email protected]] På vegne av Lee Hoffman/KY Sendt: 21. november 2017 16:50 Til: The Master Genealogist Rootsweb Email List <[email protected]> Emne: Re: [TMG] 2Gb file limit 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 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 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 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

Well ,I can`t split the prject since it all of the people are connected to me somehow. The focus with that project has been starting with me and then entering as many ancestors I knew ,and then also go onto all I could find of descendants of all the siblings and halfsiblings of my ancestors etc. I am sure I have lots of duplicates ,that I will have to do a report on and then go through them. Erik -----Opprinnelig melding----- Fra: TMG [mailto:[email protected]] På vegne av Lee Hoffman/KY Sendt: 21. november 2017 17:30 Til: The Master Genealogist Rootsweb Email List <[email protected]> Emne: Re: [TMG] 2Gb file limit At 11/21/2017 11:06, Erik Hov wrote >Yes ,it is the largest file in the project ,and I have 1.011.960 people >in the project. Since it takes time to search the name searchlist every >time ,I have TMG in two windows ,one with only the namelist ,and one >with the other info ,so I can easily go to the particular ID number. It >saves much time since I don`t have to wait for the namelist first. With that many people, I would definitely agree with John that you split that project into at least two projects. What is the main focus of your project? In my case, it is about a dozen families of mine and my wife's. Some of these are tending to one-name studies while most others tend to be fairly small groups. The majority of the small groups include a number of side tracings trying to get around brick walls in my major focus. If I ever need to split my project, I plane to drop the side groups as they are included just for convenience of the time and are rarely used. Of course, that won;t save that much (probably not more than a few thousand people. For serious splitting, I would have sepaprate out my families and my wife's families. That would require the least amount of duplication between projects. Lee 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

Could be?..... It`s different parts really....My mother`s father`s family comes from Snertingdal , Nordre and Søndre Land in Oppland County. On that side my 3 x greatgrandparents lived in Skien ,Telemark in 1900 ,but they were from Snertingdal in Oppland Count and Nes in Hedmark County ,and only lived in Skien for about 3 years. I also think that one of those ancestors (Hichmann) lived in Gjerpen ,Telemark. My mother`s mother`s family comes from Møre and Romsdal and Rogaland Counties. My father`s family comes from Østfold County ,Sweden and his mother was from Is in Østerdalen ,and she has ancestors in Os ,Kvikne and Tolga in Østerdalen ,Hedmark. Also some relatives in Røros area ,Sør Trøndelag. Also some more distant relatives in Norderhov area ,mostly who moved there. It is said that one of my (8 x greatgrandfather or something...) was born in Tinn ,Telemark ,but no one knows anything about that branch. -----Opprinnelig melding----- Fra: TMG [mailto:[email protected]] På vegne av Karla Huebner Sendt: 21. november 2017 17:20 Til: The Master Genealogist Rootsweb Email List <[email protected]> Emne: Re: [TMG] 2Gb file limit Hi Erik, that's an amazing number of people. Which parts of Norway? With that many people, it wouldn't be surprising if you have some of my relatives in that database. My maternal great-grandparents were from Fyresdal in Telemark and my paternal great-grandparents were from Norderhov (Buskerud) and Vinger (Hedmark). I've traced many Telemark and Hedmark ancestors but have not gone very far back in Buskerud yet. Best wishes, Karla <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free. www.avg.com <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> Karla Huebner calypsospots AT gmail.com On Tue, Nov 21, 2017 at 11:06 AM, Erik Hov <[email protected]> wrote: > Yes ,it is the largest file in the project ,and I have 1.011.960 > people in the project. Since it takes time to search the name > searchlist every time ,I have TMG in two windows ,one with only the > namelist ,and one with the other info ,so I can easily go to the > particular ID number. It saves much time since I don`t have to wait > for the namelist first. > > -----Opprinnelig melding----- > Fra: TMG [mailto:[email protected]] På vegne > av Lee Hoffman/KY > Sendt: 21. november 2017 16:50 > Til: The Master Genealogist Rootsweb Email List <[email protected]> > Emne: Re: [TMG] 2Gb file limit > > 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 > > 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 > > > 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 > 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

Yes ,it is the largest file in the project ,and I have 1.011.960 people in the project. Since it takes time to search the name searchlist every time ,I have TMG in two windows ,one with only the namelist ,and one with the other info ,so I can easily go to the particular ID number. It saves much time since I don`t have to wait for the namelist first. -----Opprinnelig melding----- Fra: TMG [mailto:[email protected]] På vegne av Lee Hoffman/KY Sendt: 21. november 2017 16:50 Til: The Master Genealogist Rootsweb Email List <[email protected]> Emne: Re: [TMG] 2Gb file limit 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 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

Hi - I guess you will have already recently done a tidy-up - but you may find that the "full works" of VFI, organize and re-index (repeated a few times) gives you a little more head-room. Chris -----Original Message----- From: TMG [mailto:[email protected]] On Behalf Of Erik Hov Sent: 21 November 2017 16:07 To: 'The Master Genealogist Rootsweb Email List' Subject: Re: [TMG] 2Gb file limit Yes ,it is the largest file in the project ,and I have 1.011.960 people in the project. Since it takes time to search the name searchlist every time ,I have TMG in two windows ,one with only the namelist ,and one with the other info ,so I can easily go to the particular ID number. It saves much time since I don`t have to wait for the namelist first. -----Opprinnelig melding----- Fra: TMG [mailto:[email protected]] På vegne av Lee Hoffman/KY Sendt: 21. november 2017 16:50 Til: The Master Genealogist Rootsweb Email List <[email protected]> Emne: Re: [TMG] 2Gb file limit 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 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 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

This is interesting reading ,and very good to know of. I haven`t tried to optimize/reindex or check the fileintegrity for about two or three weeks ,but it might help a little maybe...but yes ,I am near the limit. Last odd thing I noticed wa yesterday when a person that had 9 children was listed with 10. When I went to the person view on the 10th person it showed that he had other parents than the ones showing 9 children. Then I had to delete both parents on that person ,but still the person was listed with the couple having 9 children. Therefore I also had to delete the 10th child from each of those parents ,and at last again enter the 10th child as a child of his original parents. I am taking daily backups of the project ,and now I am editing one some names and other things. Thought of going through the master place list too. The name search list works OK. I have had trouble with that project before too ,and now realize it must be because of the size. The problem is that I can`t split the project because all people in it are connected to me in some way. I am not going to add more people to the project ,just edit on those already there....so far the program is still working.... Erik -----Opprinnelig melding----- Fra: TMG [mailto:[email protected]] På vegne av John Cardinal Sendt: 21. november 2017 16:13 Til: TMG-L <[email protected]> Emne: Re: [TMG] 2Gb file limit Erik, I do not know what will happen when TMG attempts to exceed the 2GB file size limit. I suspect the database file will become corrupted, and TMG will not be able to process that table. The _n.cdx file is the name index. TMG probably won't operate on any project that has a corrupted index file, but having a corrupted name index file seems particularly bad. If you are getting anywhere close to the limit, you should be very, very careful. I do not know if the limit is at exactly 2GB (2,147,483,648 bytes), but if it is, you have about 30MB left and then you will exceed the limit. You should probably consider splitting your project into a separate project. Note that you cannot avoid the problem by using _multiple datasets in the same project_. In a TMG project with multiple datasets, all the datasets share the same set of database files. You need to use completely separate projects. Each TMG project has its own set of database files. John 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

At 05:49 AM 11/21/2017, Erik Hov wrote: >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) Getting close -- 2GB is 2147483648 bytes and you are at 2115615744. VFP can only address bytes 0 to 2147483647. At best, it will refuse to save any record that would require exceeding the 2GB boundary. At worst, it wraps around and corrupts data (2147483647+1 => -2147483648 /a negative offset/) -- [email protected] Dennis Lee Bieber HTTP://home.earthlink.net/~bieber.genealogy/

My family and I match a lot of Norwegian DNA testers since our connection to Norway is so recent. I'll stop being off-topic now! <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free. www.avg.com <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> Karla Huebner calypsospots AT gmail.com On Tue, Nov 21, 2017 at 11:47 AM, Erik Hov <[email protected]> wrote: > I haven`t tested any DNA from my family....but we may be relatives far out > ,who knows? > > -----Opprinnelig melding----- > Fra: TMG [mailto:[email protected]] På vegne av > Karla Huebner > Sendt: 21. november 2017 17:44 > Til: The Master Genealogist Rootsweb Email List <[email protected]> > Emne: Re: [TMG] 2Gb file limit > > Dear Erik, > > Yes, it sounds possible that we have relatives in common, although > probably not close ones. My family has done some DNA testing, so perhaps I > should check my match lists for your email address, if you have tested any > family. > > Karla > > <http://www.avg.com/email-signature?utm_medium=email& > utm_source=link&utm_campaign=sig-email&utm_content=webmail> > Virus-free. > www.avg.com > <http://www.avg.com/email-signature?utm_medium=email& > utm_source=link&utm_campaign=sig-email&utm_content=webmail> > <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> > > Karla Huebner > calypsospots AT gmail.com > > On Tue, Nov 21, 2017 at 11:31 AM, Erik Hov <[email protected]> wrote: > > > Could be?..... > > It`s different parts really....My mother`s father`s family comes from > > Snertingdal , Nordre and Søndre Land in Oppland County. On that side > > my 3 x greatgrandparents lived in Skien ,Telemark in 1900 ,but they > > were from Snertingdal in Oppland Count and Nes in Hedmark County ,and > > only lived in Skien for about 3 years. I also think that one of those > > ancestors > > (Hichmann) lived in Gjerpen ,Telemark. > > My mother`s mother`s family comes from Møre and Romsdal and Rogaland > > Counties. > > My father`s family comes from Østfold County ,Sweden and his mother > > was from Is in Østerdalen ,and she has ancestors in Os ,Kvikne and > > Tolga in Østerdalen ,Hedmark. Also some relatives in Røros area ,Sør > Trøndelag. > > Also some more distant relatives in Norderhov area ,mostly who moved > > there. It is said that one of my (8 x greatgrandfather or > > something...) was born in Tinn ,Telemark ,but no one knows anything > about that branch. > > > > -----Opprinnelig melding----- > > Fra: TMG [mailto:[email protected]] På vegne > > av Karla Huebner > > Sendt: 21. november 2017 17:20 > > Til: The Master Genealogist Rootsweb Email List <[email protected]> > > Emne: Re: [TMG] 2Gb file limit > > > > Hi Erik, that's an amazing number of people. Which parts of Norway? > > With that many people, it wouldn't be surprising if you have some of > > my relatives in that database. My maternal great-grandparents were > > from Fyresdal in Telemark and my paternal great-grandparents were from > > Norderhov > > (Buskerud) and Vinger (Hedmark). I've traced many Telemark and Hedmark > > ancestors but have not gone very far back in Buskerud yet. > > > > Best wishes, > > > > Karla > > > > <http://www.avg.com/email-signature?utm_medium=email& > > utm_source=link&utm_campaign=sig-email&utm_content=webmail> > > Virus-free. > > www.avg.com > > <http://www.avg.com/email-signature?utm_medium=email& > > utm_source=link&utm_campaign=sig-email&utm_content=webmail> > > <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> > > > > Karla Huebner > > calypsospots AT gmail.com > > > > On Tue, Nov 21, 2017 at 11:06 AM, Erik Hov <[email protected]> wrote: > > > > > Yes ,it is the largest file in the project ,and I have 1.011.960 > > > people in the project. Since it takes time to search the name > > > searchlist every time ,I have TMG in two windows ,one with only the > > > namelist ,and one with the other info ,so I can easily go to the > > > particular ID number. It saves much time since I don`t have to wait > > > for the namelist first. > > > > > > -----Opprinnelig melding----- > > > Fra: TMG [mailto:[email protected]] På > > > vegne av Lee Hoffman/KY > > > Sendt: 21. november 2017 16:50 > > > Til: The Master Genealogist Rootsweb Email List <[email protected]> > > > Emne: Re: [TMG] 2Gb file limit > > > > > > 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 > > > > > > 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 > > > > > > > > > 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 > > > > > 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 > > > > > > 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 > > > 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 > > > 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 >