https://kotlinlang.org logo
#exposed
Title
# exposed
r

ron

04/07/2022, 11:15 AM
Not really sure where to ask this question, as it is Database related I will ask it here. We have a database with a table containing around 8Billion records. When we query this database using intellij and the sql-server driver. the response is usually within 10-20 seconds. If we run exactly the same query, with exactly the same sql-driver on the same development machine the query will take around 14 minutes. Is there any way to "capture" what intellij sends / does with this query.
h

hfhbd

04/07/2022, 11:55 AM
How do you query it inside IntelliJ? By default, IntelliJ only fetches the top 500 results
r

ron

04/07/2022, 1:17 PM
open console, copy paste the query, run the query. We use the same limit
h

hfhbd

04/07/2022, 1:23 PM
If you are using the built in preview, it uses a pagination too
2 Views