🚀 go-pugleaf

Hello Dietrich,

What about solution #4 -  use TIBSQL and BatchInput, BatchOutput,
InputRawFile,OutputRawFile features?

The fastest and the easyest way so far.

Steps:
1) Create OutputRawFile with TIBSQL.BatchOutput
2) zip it and send (you can use ZLib)
3) unzip it on a client a client side into InputRawFile
4) Start transaction, empty your table, load data from InputRawFile using
TIBSQL.BatchInput and Commit

Whole code size will be about 100 lines max.

Best regards,

CleverComponents Team
www.CleverComponents.com
info@CleverComponents.com

"D.v.Witzleben" <info@witzleben-edv.de> wrote in message
news:3df0d44d@newsgroups.borland.com...
> 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
>
>