Questions tagged [provisioned-iops]
32 questions
-1
votes
1 answer
Read Write batch Size Impact on GCP IOPS
I have to backfill some column data in postgressql table .it contains huge amount of data (around 100 million).Now for this I am using pg-batch and reading certain batchsize and then writing it in database(in certain batch size) . In GCP there are…
Perf2017
- 29
- 5
-1
votes
1 answer
Performance issue of ON DUPLICATE KEY UPDATE in mysql bulk Update
As Mysql doesn't Provide any Bulk Update query but we use the feature of ON DUPLICATE KEY UPDATE. Is it good to use the below query when we are updating in bulk if not then what are the performance issues of using the below query? Is there is any…
Anand Tripathi
- 14,556
- 1
- 47
- 52