Well, I answered my own question and reverse engineered it. Man does FB 1.5
load data fast. I loaded 1,000,000 records (8 integer fields and 1 double
precision) in 26 seconds. I can write that same file in about 19 seconds.
Yes, total data transfer of 1,000,000 records in 45 seconds.



I think I will work on a Delphi component that can natively write a dataset
to a native FB external file format. Anyone interested?



Louis Kleiman

SSTMS, Inc.





-----Original Message-----
From: Louis Kleiman [mailto:lkleiman@...]
Sent: Friday, March 28, 2003 4:30 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] Writing to external files



Hi All -



I have a challenge for you:



I want to write a file from a Delphi program that is compatible with a
Firebird external file. "Easy", you say, "just make it ASCII and convert
from ASCII to your numeric types with a CAST() when you load from the
external file to your real table." Well, that would work, but I am really
trying to save every possible millisecond here because I have some
10,000,000 line files to load. Can anyone tell me how to write files that
are binary compatible with Firebird? I'll even restrict the data types:
all I really need are INTEGER and DOUBLE PRECISION.



I might be able to reverse engineer this, but I thought I would put it to
the group to see if someone already knows.



Thanks.



Louis Kleiman

SSTMS, Inc.



[Non-text portions of this message have been removed]






Yahoo! Groups Sponsor



ADVERTISEMENT

<http://rd.yahoo.com/M=245454.2994396.4323964.2848452/D=egroupweb/S=17051153
86:HM/A=1457554/R=0/*http:/ipunda.com/clk/beibunmaisuiyuiwabei>



<http://us.adserver.yahoo.com/l?M=245454.2994396.4323964.2848452/D=egroupmai
l/S=:HM/A=1457554/rand=999838311>


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.



[Non-text portions of this message have been removed]