Hello, i are having an issue with spring - kotlin - documentdb, this is our config:
val kotlinVersion = "1.2.71"
val springBootVersion = "2.1.8.RELEASE"
plugins {
jacoco
id("org.springframework.boot") version "2.1.8.RELEASE"
id("io.spring.dependency-management") version "1.0.8.RELEASE"
id("org.jlleitschuh.gradle.ktlint") version "7.1.0"
kotlin("jvm") version "1.2.71"
kotlin("plugin.spring") version "1.2.71"
}
we have a query to documentdb which search by "_id" an array of numbers, the size could be between 100 to 7000. i've noticed that queries up to 1200 may last 400ms, over that number start the problem, we found an example of 6500 documents which lasted 5sec.
We are not sure where the problem is, but DBA team shows their lacency metrics by query and we do not find a query that lasted that long. We think the problem is how we parse the query result.