Stack Overflow
Stack Overflow

Questions tagged [bulkupdate]

Bulk update a database

Methods to bulk update a database with single or multiple columns of data. This could be either unique data for each row or same data for a column.

299 questions
0
votes
1 answer

Bulk insertOrUpdate in laravel

How can we insertOrUpadate() bulk data? I have around 60,000 data in bulk so doing a loop insert is very slow and also the bulk data is ever increasing.
Rabinson
  • 91
  • 1
  • 7
0
votes
2 answers

How to transform part of each document into an array in each document using bulk read/write?

I have documents that look like this { "field1" : "value", "field3" : "value", "attributes" : { "key1" : { "category" : "4", "value" : "value" }, "key2" : { "category" : "5", …
Kit
  • 20,354
  • 4
  • 60
  • 103
0
votes
1 answer

Update thousands of rows in mysql database with php

Im trying to update 50000 rows in my database, the following code should do that but I always get an error : Error: connection time out I've an UPDATE statement which can update more than 50k records. I want to update them in batches of 1000 or…
alan54
  • 23
  • 4
0
votes
1 answer

The impact of Availability of data to users while doing large updates on table

I am trying to understand how the huge volume of updates in tables affects Data availability for users. I have been going through various posts(fastest-way-to-update-120-million-records, Avoid locking while updating)which walks through the different…
Explorer
  • 1,491
  • 4
  • 26
  • 67
0
votes
2 answers

Strapi. Bulk update on Mysql

How to do bulk update by Id, in Strapi using mysql database? I'm trying this await strapi.query('logs').update({id_in : [12,13]}, {is_transfered : 1}); But getting this error Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the…
Aidyn
  • 5
  • 1
  • 3
0
votes
1 answer

Should I clear collections every fetch loop to be used in forall? PLSQL Oracle

Lets say I have a huge data(100k-1m rows) in table1 that I need to do some checking then update their status on table2 based on the filtered results. As you can see with my simplified code. I bulk collect 1000 rows per batch and filter them into 3…
LucidScript
  • 3
  • 3
0
votes
1 answer

Django Postgres migration: Fastest way to backfill a column in a table with 100 Million rows

I have a table in Postgres Thing that has 100 Million rows. I have a column that was populated over time that stores some keys. The keys were prefixed before storing. Let's call it prefixed_keys. My task is to use the values of this column to…
Mohammad Sadeq Badakhshanfard
  • 15
  • 5
0
votes
1 answer

MongoDB: Update a subset of an array based on position range

I need to update values in an array in many MongoDB documents using a bulk write operation (the new array differs for each document). My question is: is there a way to update a subset of array values based on the element position range, passing an…
bguillod
  • 3
  • 1
0
votes
2 answers

Bulk Operations in D365FO

I have 500 records which I need to update in D365FO via API. Microsoft suggested that bulk operations are not applicable via ODATA in D365FO currently. Can I get some help here How can I update all the records via API at one go. Currently, I am…
Mani
  • 19
  • 1
  • 5
0
votes
1 answer

Need Bulk Status Change function with a Custom Woocommerce Order Status

I've used the below php to add an 'imported' custom order status in woocommerce and it works fine > **/ function register_imported_order_status() { > register_post_status( 'wc-imported', array( > 'label' =>…
lambot
  • 31
  • 5
0
votes
0 answers

MongoDB Bulkwrite query freezes the Node.js Response

I was testing the bulk update on MongoDB through node.js API. For updating 50000 entries, it takes around 8 minutes 30 seconds and then MongoDB finishes its job but not getting the API response from Node.js API. In this process CPU usage is 32% &…
Aks
  • 1,092
  • 3
  • 12
  • 29
0
votes
2 answers

Not able to delete solr documents (using a query) either using post tool or URL

I am not able to delete solr documents (using a query) either using post tool or URL. Please note, my solr is configured with basic authentication. Solr Version : 6.6 I tried two ways, Using post tool ./post -u username:pass -c core_name…
Vishal Zanzrukia
  • 4,902
  • 4
  • 38
  • 82
0
votes
1 answer

Update a table with dynamic query using bulk collect

I want update a table using a dynamic query, cursor and bulk collect. But I don't know the syntax: declare my_cursor ?; -- other objects; begin execute immediate "select s.col1, s.col2, rowid, d.rowid from source_table…
Ronny V
  • 13
  • 4
0
votes
2 answers

update multiple Records at a time using checkbox laravel

I want to update multiple records statuses or delete. Status is: accept, reject, pending. so want to give checkbox to the user for select multiple records and dropdown for choose status want to update records at a time, and also want to give the…
itxrahulsingh
  • 53
  • 1
  • 11
0
votes
1 answer

Bulk insert, update values mongodb

I run a bulk insert cron job everyday. But some values get missed and when I rerun the data, the values are added to the existing data rather than updating. Is there a way to do an insert only documents that have not yet been inserted. My code: …
nb_nb_nb
  • 1,243
  • 11
  • 36
1 2 3
…
19 20