Yes, that would work if the source data were already in my database. The
source data is generated in another program, and I need a quick way to dump
it into FB.



LCK



-----Original Message-----
From: Alan McDonald [mailto:alan@...]
Sent: Saturday, March 29, 2003 1:06 AM
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] Writing to external files



not sure what you are getting at here..
if you create your external table ...
then do
insert into externaltable (field1, field2, etc) select (field1, field2 etc
from internaltable

wouldn't that do it for you?
Alan

-----Original Message-----
From: Louis Kleiman [mailto:lkleiman@...]
Sent: Saturday, 29 March 2003 3:22 PM
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] Writing to external files


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]



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



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/








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=720207989>


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]