Add to debug logging in the jdbc integration module the information about the data loading process
Open
@zaleslaw is already working on this.
Since Sep 11, 2023.
databases
enhancement
- Dominant language
- Kotlin
- Stars
- 1.1k
- Forks
- 83
- Avg merge
- 4d 12h
- Merged PRs (30d)
- 30
Description
- number of loaded rows
- total number of rows in the table/query
- number of data/size of data calculated by footprint in memory, number of columns and its types
This functionality could be auto-enabled for all tables or only for huge tables with many rows, also will be great to ask about the stat in alternative ways rather than proposed below:
// Your original query
val originalQuery = "SELECT * FROM your_table_name WHERE column_name = 'some_value'"
// Query to count the number of rows
val countQuery = "SELECT COUNT(*) as count FROM (" + originalQuery + ") AS count_query"
// Create a statement and execute the count query
val countStatement = connection.createStatement()
val countResultSet = countStatement.executeQuery(countQuery)
// Get the row count
val rowCount = 0
if (countResultSet.next()) {
rowCount = countResultSet.getInt("count")
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.