Importing HH's from multiple files ??

[Carl LaFong]

As part of the installation of PT3, I understand I must import hh's from beta version. I also understand I have to create a new file, copy beta hh's into it and then import the new file into PT3.

My hh's are currently spread across three files. One is the "processed" file in PT3 beta with hh's from May 7 to current date and the other two are copies I made of hh's prior to May 6 when I encountered a problem and had to reinstall the beta version.

As someone who is not familiar with db's, my questions are:

Is it better to combine all three sources into a fourth and import that one or copy and import each of the current three ?

Does it make any difference where I locate the one I create as my import source ?

Thanks

[kraada]

If you combine things so that you only have one file (or folder of files) you will likely cut down on the number of duplicates. The only useful thing about cutting down on the number of duplicates is that the import will take less time.

You can put the files wherever you like. If they are on an entirely separate hard drive from the hard drive your PostgreSQL data is on, you will notice some speed increase, but it isn't that big a deal. (postgres defaults to being on the C: drive.)