Talking databases

Nancy Palmquist nlp at vss3.com
Tue Jan 10 09:53:13 PST 2006


Nathan,

The solution to this is much easier than I see postings from others.

FilePro will allow data to be stored on more than one drive.

For example:

F:\filepro\taxtable\key		My novell live system
G:\filepro\taxtable\key		My test system.

Now you use these based on the PFDATA variable set PFDATA=F: for live 
and set PFDATA=G: for test.  You also set PFDSK=F for live and PFDSK=G 
for test to keep each only looking at the correct drive.

If you add a drive S: so you have:

S:\filepro\taxtable\key

Add S to the PFDSK for both sides.

Remove the key from f: and G: for the files in question. (RENAME THEM 
Until you are sure it works.)

You can also put the indexes on the S: and remove them from the F and G 
drives.  All programming stays on the F and G drives as well as the map.

It will share the data completely between the two systems with no problem.

GOTCHA 1 - Be real careful about restructures - changing the file 
definition for any reason.  You might want to make the map read-only as 
a reminder.  Allow restructure from only one place then copy the changed 
map to the other side from windows.

GOTCHA 2- I haven't tried this lately, but in tests in the past, the 
indexes rebuilt on the first drive, instead of where they have been 
moved.  I think that is fixed, but have not tried it lately.

GOTCHA 3- Lockfile is always placed on the first drive, so even moving 
it to the second drive does no good about file locking.  RECORD locking 
works just fine on a network computer.

Best success with code files that are not updated often, it is a great 
trick and can be used on many system types.

I even use it to share data between Linux and Windows systems.  It works 
great for that also.

If filePro would allow the lockfile to be moved to any one of the 
mounted folders and the indexes stayed where you put them, it would be 
perfect.  (Without checking, I can't remember about the indexes they may 
stick fine these days.)

This all works on a Linux/Unix system also, by using PFDSK=/var1:/var2 
to set the locations and under those folders the same folders must exist 
(filepro/filename) or (appl/filepro/filename)

Just a suggestion.

Nancy




-- 
Nancy Palmquist 		MOS & filePro Training Available
Virtual Software Systems	Web Based Training and Consulting	
PHONE: (412) 835-9417		   Web site:  http://www.vss3.com



More information about the Filepro-list mailing list