Kotlin / Kotlin/dataframe

Add to debug logging in the jdbc integration module the information about the data loading process

Open
#455 3 comments 0 reactions 1 assignee View on GitHub

@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

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.