Android Question How To Bulk Insert Records In Server Quickly.

Discussion in 'Android Questions' started by Juzer Hussain, Jul 16, 2015.

  1. Juzer Hussain

    Juzer Hussain Active Member Licensed User

    Hi ,
    Is there any way of bulk inserting records in server table. Or do we have to call Jobs(PostString) in Loop.Will it be a good idea?
    I want to insert 53 records in a table in MS SQL.
    Juzer
     
  2. sorex

    sorex Expert Licensed User

    just concatenate the data and post it as one big string of parameters.

    it will be way faster then sending 53 small posts.
     
  3. lemonisdead

    lemonisdead Well-Known Member Licensed User

    Following Sorex, I would advice to use json
     
  4. Erel

    Erel Administrator Staff Member Licensed User

    If you are using the ASP.Net script that I posted then it only supports a single query per request.

    I recommend you to switch to RDC which does support bulk inserts.
     
Loading...