🚀 go-pugleaf

Hi

I build the following application:

CENTRAL-APP: They are able to Insert/Modify (not delete) Item-Data (table
ITEM). Then this data has to be send to the shops via 64K Modem.

SHOPS-APP: They receive ITEM-Table with new items, sell products into the
SOLD-Table, and are only able to read the ITEM-table.

I figured following solutions:

1: Replication on record-basis for table ITEM through delphi / IBX, works
fine.
   PROBLEM: It takes 3-5 hours a day. Also the destination DB grows
extremely in size.

2: Export table ITEM with Delphi/BDE/Batchmove into ITEM.DBF, import into
SHOP-APP the same way.
  PROBLEM: The destination DB grows extremely in size, when you close it, it
seems to hang, after a while it does close.

3: "Create table itemexternal external file ITEMEXTERNAL.TXT" in Interbase,
insert data with insert into itemexternal select * from item. In the
SHOPS-APP there is no internal ITEM-table, I use the external
ITEMEXTERNAL-table directly for read-purposes. Works very fine.
  PROBLEM: No BLOB-DATA! Also I can't copy the file while someone is working
on the DB, since it's locked.

Question: Any idea on problem 1-3?

Thanks,

Dietrich