Home Forums Article Discussions Article Discussions by Author Discuss content posted by Mohd Nizamuddin Sending multiple rows to the Database from an Application: Part I RE: Sending multiple rows to the Database from an Application: Part I

  • October 15, 2010 at 4:23 am

    #1237400

    Alexey Voronin (10/15/2010)

    I was making my own experiments with this on a very busy server in fact. Neither XML nor delimited string of data produce optimal results. The best was the long list of INSERT statements limited only by the query text length limit. The better than that is only a bulk insert from a text file.

    Yes, you are correct.

    But in my scenario, where we are updating data offline using an application developed in JAVA. When user gets connected to the database. The application will update those data to the database using either delimited string or XML.

    Thanks,

    Nizam