# How we can speed up data query from DB(Oracle) node Database Reader(Legacy) **URL:** \ **Category:** KNIME Analytics Platform\ **Tags:** database\ **Created:** [April 7, 2022, 7:10am UTC](https://forum.knime.com/t/how-we-can-speed-up-data-query-from-db-oracle-node-database-reader-legacy/41429 "2022-04-07T07:10:09Z")\ **Posts on this page:** 1\ **Showing post:** 4
**Author:** ![mlauber71](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mlauber71/32/73590_2.png) [@mlauber71](https://forum.knime.com/u/mlauber71)\ **Post date:** [April 7, 2022, 8:38pm UTC](https://forum.knime.com/t/how-we-can-speed-up-data-query-from-db-oracle-node-database-reader-legacy/41429/4 "2022-04-07T20:38:40Z")
@cppong you could try and read the data in chunks like in this example: > **[Download data from a database in chunks and append them to an CSV file –...](https://hub.knime.com/mlauber71/spaces/Public/kn_example_write_csv_loop_chunks/m_001_write_csv_loop_chunks~-njjNfdjCt05FaKE/current-state)** > > Download data from a database in chunks and append them to an CSV file The example uses ROWIDs from SQLite. You could see if you either have a ROWIDs present o… > [@Export huge MS sql table to csv without fetching all records together](https://forum.knime.com/t/export-huge-ms-sql-table-to-csv-without-fetching-all-records-together/15105/2): > > have you thought about doing it in chunks? And then appending the result to a CSV file. The example attached uses ROWIDs from SQLite. You could see if you either have a ROWIDs present or you could create one yourself. You can choose the size of the chunk/batch yourself (I use integers you might have to see if with very large numbers you might need big integers or something. Even a workaround with using strings might be possible). Only other idea would be to write a CSV file directly on a Big Da… --- _[View the full topic](https://forum.knime.com/t/how-we-can-speed-up-data-query-from-db-oracle-node-database-reader-legacy/41429)._