Insert Bulk record in Powerbuilder

[former_member1086145]

My flat file contain 75000 records. I need to insert all file records into database through Powerbuilder.

Using importfile function imported records into datawindow. once I used dw.update() its take 3-4 Hrs.

Please let me how to insert to record in minimum time ?

[jerryjanda]

Thank you for visiting SAP Community to get answers to your questions. I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. For example, you can outline what steps you took to find answers (and why they weren't helpful), share screenshots of what you've seen and done, and so on. The more details you provide, the more likely it is that members will be able to assist you.

Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question).

--Jerry

[chris_keating]

The DataWindow performs operations row by row so it is not an efficient way to bulk load data. You really want to try to push that work to the database which will likely have bulk loading capabilities. For example, the SQL Anywhere LOAD TABLE is designed for bulk loading of data. There will be similar capabilities in most databases.