> We do the mirroring by running a program that dumps the FoxPro > tables out as tab-delimited files. Thus far, we'd been using > PostgreSQL's "copy from" command to read those files into the > database. In reality, though, a very, very small percentage of > rows in those tables actually change. So, I wrote a program > that takes the output of diff and converts it into a series of
I think the problem could be considered another way. if you have access to the "legacy/FoxPro" application, it should be modifed to add a timestamp to each reccord modification. Then you could only dump those reccords that were modified since the last change. That seems to me the only long term viable solution that could sizeup nicely with your set of data. Not to mention that once implemented it would be much much faster. Olivier _______________________________________________ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
