Are you doing a 'commit' every so many records?



gorepj wrote:

> I have an application that uses OLE/DB to pump data from an AS/400
> database to a Firebird 1.5 Database. Records are read and
> reformatted and posted to the Firbird database. It works reliably
> but too slow. It took 8 hours to post 2 Million records into a
> table. I need to cut this down to say 1 or two hours.
>
> The application reads each record from the AS/400 and constructs an
> SQL statement to insert the record into the Firebird database table
> i.e.
>
> INSERT INTO FBTable (MyField1, Myfield2 ...) VALUES (MyValue1,
> MyValue2...)
>
> Is there a faster way? Would parameter substitution help?
> Regards
> Peter Gore
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
> <http://rd.yahoo.com/M=245454.3115308.4434529.1728375/D=egroupweb/S=1705115386:HM/A=1457554/R=0/*http://ipunda.com/clk/beibunmaisuiyuiwabei>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.

--
Todd Brasseur, A.M.A.A.
COMPASS Municipal Services Inc.




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