Android Question How To Bulk Insert Records In Server Quickly.

[Juzer Hussain]

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

 

[sorex]

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

it will be way faster then sending 53 small posts.

 

[lemonisdead]

Following Sorex, I would advice to use json

 

[Erel]

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.