importing files

[skynight]

I have imported a few files (data bases) into my layout using FILE/IMPORT RECORDS, and I notice that the size of the original might be 1.5 Mb, while the new file is only 300 Kb. Does this mean that if I delete the original I will lose the data? Is there a way to move the entire record (data base) into the new layout so it is independent of the original?

[Lee Smith]

Hi skynight,

I would expected that to happen.

The bloat in your original file is probably caused by things like indexing, deleted records (unused file blocks), etc.

I wouldn't be a bit surprised that if you were to do a saved "compressed" copy of your original, that the size fo the copy would drop down to that of your new file. However, once yo do a Find, the size will start to increase.

HTH

Lee

[skynight]

So I can delete the original and move the new one to another computer and it will have all the records intact? That is a serious saving in bits and bytes, it would be a good idea to always import a file and delete the original?

[transpower]

Yes. With Developer, you could even compact the file.

[Lee Smith]

Hold It!

Do "NOT" just delete the original file. A file size of 1.6 megs is not a huge file. I would Save a Copy, as is or "Compressed", and then put that on an archive disk. If you need it even more smaller, compact it using a .zip or .sit format and keep it instead.

You would not be the first that found out they need a copy of the DB in it's older format.

When dealing with data, always be prepare for "Murphy's Law". I like to keep a few compressed backups as a "Security Blanket" for the inevitable in life.

HTH

Lee