Help With Load

We are running a database that interfaces with a Web site. Our client occassionally will FTP us a new file which was created by their DOS or Windows database. We load their file into our Informix database. The problem is that they will be sending us the complete database everytime they make changes, even if it's only to one record. How should I approach this? 1) Delete all records from the database then load the entire database again. 2) Check the existing database for changes with the file that was FTPed to us. 3) ??? Something better? Is there a problem with deleting the old records all of the time? Do the deleted records still take up space? Thanks for helping a newbee. -- _-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_ | Harold Sasaki | hsasaki@harold.com | http://www.harold.com/ | Name Dat Toon: http://www.harold.com/namedattoon/ | Golden State Warriors: http://www.harold.com/warriors.shtml