From owner-freebsd-questions@FreeBSD.ORG  Mon Nov  7 16:40:50 2005
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 038F216A41F
	for <freebsd-questions@freebsd.org>;
	Mon,  7 Nov 2005 16:40:50 +0000 (GMT)
	(envelope-from francisco@natserv.net)
Received: from zoraida.natserv.net (p65-147.acedsl.com [66.114.65.147])
	by mx1.FreeBSD.org (Postfix) with ESMTP id A0E9343D46
	for <freebsd-questions@freebsd.org>;
	Mon,  7 Nov 2005 16:40:49 +0000 (GMT)
	(envelope-from francisco@natserv.net)
Received: by zoraida.natserv.net (Postfix, from userid 1000)
	id 907E97E32; Mon,  7 Nov 2005 11:40:46 -0500 (EST)
Received: from zoraida.natserv.net (localhost [127.0.0.1])
	by zoraida.natserv.net (Postfix) with ESMTP id 82D267E12;
	Mon,  7 Nov 2005 11:40:46 -0500 (EST)
References: <200511040956.19087.kirk@strauser.com> <436B8ADF.4000703@mac.com>
	<200511041129.17912.kirk@strauser.com>
Message-ID: <cone.1131381646.500858.17113.1000@zoraida.natserv.net>
X-Mailer: http://www.courier-mta.org/cone/
From: "francisco@natserv.net" <francisco@natserv.net>
To: Kirk Strauser <kirk@strauser.com>
Date: Mon, 07 Nov 2005 11:40:46 -0500
Mime-Version: 1.0
Content-Type: text/plain; format=flowed; charset="US-ASCII"
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
Cc: freebsd-questions@freebsd.org
Subject: Re: Fast diff command for large files?
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 07 Nov 2005 16:40:50 -0000

Kirk Strauser writes:

> Our legacy application runs on FoxPro.  Our web application runs on a 
> PostgreSQL database that's a mirror of the FoxPro tables.

I had the same setup a while back.
A few suggestions.
* Add a date/changed field in Foxpro and update.
* If only recent records are updated, only copy those over
* Add a "changed" flag in Foxpro tables
* Load entire foxpro tables every time and do a delete/reload withing a 
single transaction.

The idea situation is if you can somehow segreate your older, non changeable 
data, and copy every day only records that are recent.. even if they have 
not changed.

What type of system is this? In particular do any record can be modified or 
are only recent records changed?