Hi SingleStore support \ developers,
we have encountered a very strange problem regarding response time for a query, which we are not sure why it is happening:
we’ve created a small Python script which connects to Single store and executes a SELECT query.
we execute this query vs. several DBs in Singlestore, and adding a large random delay (sleep between 1 and 5 minutes) between each execution.
when running this script from PyCharm, even with short delay (every 10 seconds), it runs great with response time of around 1 second.
when running this script from Azure VM, also the results are great.
when running the same script from docker container on the same Azure VM, we see bad results (sometimes good), as if Single Store does not use cached plan to execute the query!
any idea how\why this could happen?!
any help would be appreciated here!
thanx in advance,
Pini.