Can you post some examples of this.
This sounds fantastic.

Regards,

Robert.

--- In firebird-support@yahoogroups.com, Tim <tim@...> wrote:
>
> I have to import text files containing 50 000+ records into our DB
> every so often.
>
> So what I do is rewrite the input file in the format I require
(fixed
> length fields)
>
> I have declared this rewritten table as an external file in
Firebird.
>
> Then I run a SP to import the data in batches of 10 000 records a
> time into the table.
>
> It cut the import time from (worst case) 2.5 hours to about 3 or 4
seconds.
>
> HTH
>
> Tim
>
> At 07:54 24/02/2006, you wrote:
>
> >We currently use running SQL statements to inject
> >data into our Firebird database.
> >Is there any faster way?
> >
> >Like a rawdata pump or something?
> >
> >Regards,
> >
> >Robert.
> >
> >
> >
> >
> >
> >++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> >Visit
> ><http://firebird.sourceforge.net>http://firebird.sourceforge.net
and
> >click the Resources item
> >on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> >Also search the knowledgebases at
> ><http://www.ibphoenix.com>http://www.ibphoenix.com
> >
> >++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> >
> >
> >
> >SPONSORED LINKS
> ><http://groups.yahoo.com/gads?
t=ms&k=Technical+support&w1=Technical+support&w2=Computer+technical+su
pport&w3=Compaq+computer+technical+support&w4=Compaq+technical+support
&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c
=6&s=196&.sig=-XIO8GxY6hqd3NaD5WSEyw>Technical
> >support
> ><http://groups.yahoo.com/gads?
t=ms&k=Computer+technical+support&w1=Technical+support&w2=Computer+tec
hnical+support&w3=Compaq+computer+technical+support&w4=Compaq+technica
l+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+
support&c=6&s=196&.sig=B29J78SYXnNTjjMFBMznqA>Computer
> >technical support
> ><http://groups.yahoo.com/gads?
t=ms&k=Compaq+computer+technical+support&w1=Technical+support&w2=Compu
ter+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+t
echnical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+tec
hnical+support&c=6&s=196&.sig=7_je1A94xs82CFXUjEqA6g>Compaq
> >computer technical support
> ><http://groups.yahoo.com/gads?
t=ms&k=Compaq+technical+support&w1=Technical+support&w2=Computer+techn
ical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+
support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+su
pport&c=6&s=196&.sig=2zMAuRCo5cJrVBr1Bxa3_w>Compaq
> >technical support
> ><http://groups.yahoo.com/gads?
t=ms&k=Hewlett+packard+technical+support&w1=Technical+support&w2=Compu
ter+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+t
echnical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+tec
hnical+support&c=6&s=196&.sig=_ytYU7aXb57AVaeUfmvLcA>Hewlett
> >packard technical support
> ><http://groups.yahoo.com/gads?
t=ms&k=Microsoft+technical+support&w1=Technical+support&w2=Computer+te
chnical+support&w3=Compaq+computer+technical+support&w4=Compaq+technic
al+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical
+support&c=6&s=196&.sig=4hRo6NXYavRAbTkaYec5Lw>Microsoft
> >technical support
> >
> >
> >----------
> >YAHOO! GROUPS LINKS
> >
> > * Visit your group
> > "<http://groups.yahoo.com/group/firebird-support>firebird-
support" on the web.
> > *
> > * To unsubscribe from this group, send an email to:
> > *
> > <mailto:firebird-support-unsubscribe@yahoogroups.com?
subject=Unsubscribe>firebird-support-unsubscribe@yahoogroups.com
> >
> > *
> > * Your use of Yahoo! Groups is subject to the
> > <http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.
> >
> >
> >----------
>
>
> [Non-text portions of this message have been removed]
>