Mysql Operations Takes too much time

[unkempt kayak]

What does dbSavePosition do? Do you need to send 750 requests? Why can't you just send 1 request?

Batching things into larger requests can alleviate some of the pressure on your db

[vestal moat]

i get 750 data from 750 different request

[unkempt kayak]

Is it an INSERT query?

Sending 750 concurrent requests to your db is a bad idea

If you absolutely need to make 750 requests, you should use a worker pool to limit the number of parallel connections. You're probably starving your db of resources

But, I get the feeling you could collapse this into 1 request that inserts/updates all of the rows

[vestal moat]

my construction like this

i sent request

and then i sent select request to db

if it exists i update it else update it

I cant use insert on duplicate

[unkempt kayak]

why not?