dataframe icon indicating copy to clipboard operation
dataframe copied to clipboard

Improve performance for reading from database

Open zaleslaw opened this issue 2 years ago • 0 comments

There are a few ways to increase the speed of SQL queries and data retrieval

  • [ ] batches/fetching
  • [ ] manipulate by whole row instead of reading of each column
  • [ ] databases/connection settings
  • [ ] create JDBC connection pool with default as Hikapi for functions with connection under hood

zaleslaw avatar Sep 11 '23 12:09 zaleslaw