J Juzer Hussain Active Member Licensed User Longtime User Jul 16, 2015 #1 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
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
S sorex Expert Licensed User Longtime User Jul 16, 2015 #2 just concatenate the data and post it as one big string of parameters. it will be way faster then sending 53 small posts. Upvote 0
just concatenate the data and post it as one big string of parameters. it will be way faster then sending 53 small posts.
lemonisdead Well-Known Member Licensed User Longtime User Jul 16, 2015 #3 Following Sorex, I would advice to use json Upvote 0
Erel B4X founder Staff member Licensed User Longtime User Jul 16, 2015 #4 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. Upvote 0
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.