Queries that are slow in my code appears to run quickly on my SQL Client

[Mathieu Pichon]

Hello,

We are running a PERL script that performs many synchronous SQL queries.

We found that some of them (always the same) were reported in the slow queries log (<3s):
- big insert
- big replace using "prime_key IN (key1,key2.....)"

When we cut and past the queries in our SQL client they are performing very well ( few ms )

I can't figure what is happening nor how to trouble shout.

please help