# 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:** 12\ **Page:** 1
**Author:** ![cppong](https://forum-cdn.knime.com/user_avatar/forum.knime.com/cppong/32/10981_2.png) [@cppong](https://forum.knime.com/u/cppong)\ **Post date:** [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/1 "2022-04-07T07:10:09Z")
Hi everyone, I got some issues with the speed to query data from Oracle DB. I use Database Reader (Legacy) to query data from a database. It is very very slow…you can see the pics I attached (or it was about Caching row setting?) …So, can we have the way to speed it up or any way to do? Please help. 🥲 ![2022-04-07 14_02_58-KNIME TAT Mon v3.xlsx - Excel](https://forum-cdn.knime.com/uploads/default/original/3X/a/0/a04287f283737e1f6cc9f236214e6222f15ed1bb.jpeg) ---
**Author:** ![ipazin](https://forum-cdn.knime.com/user_avatar/forum.knime.com/ipazin/32/806_2.png) [@ipazin](https://forum.knime.com/u/ipazin)\ **Post date:** [April 7, 2022, 2:44pm UTC](https://forum.knime.com/t/how-we-can-speed-up-data-query-from-db-oracle-node-database-reader-legacy/41429/2 "2022-04-07T14:44:49Z")
Hello @cppong, have you tried the new DB Framework? It even has dedicated [Oracle Connector](https://kni.me/n/_fvEBQvrof1kSz-X) node. Br, Ivan ---
**Author:** ![victor\_palacios](https://forum-cdn.knime.com/user_avatar/forum.knime.com/victor_palacios/32/37922_2.png) [@victor\_palacios](https://forum.knime.com/u/victor_palacios)\ **Post date:** [April 7, 2022, 2:45pm UTC](https://forum.knime.com/t/how-we-can-speed-up-data-query-from-db-oracle-node-database-reader-legacy/41429/3 "2022-04-07T14:45:17Z")
Could you use the non-legacy versions? Deprecated or Legacy nodes tend to be slower, but it’s a case-by-case basis. ---
**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… ---
**Author:** ![cppong](https://forum-cdn.knime.com/user_avatar/forum.knime.com/cppong/32/10981_2.png) [@cppong](https://forum.knime.com/u/cppong)\ **Post date:** [April 8, 2022, 3:14am UTC](https://forum.knime.com/t/how-we-can-speed-up-data-query-from-db-oracle-node-database-reader-legacy/41429/5 "2022-04-08T03:14:49Z")
Hi Victor @victor_palacios Thanks for the advice. As I checked, I didn’t see the non-legacy for the Database Connector node. 😶 So, how I can get that node? See my captured pics. ![2022-04-08 10_10_44-KNIME Analytics Platform](https://forum-cdn.knime.com/uploads/default/original/3X/c/3/c327fb3ab1a6e2d24ac421c013d886a327d9c400.jpeg) I use KNIME version 4.2.0 Thanks again. ---
**Author:** ![cppong](https://forum-cdn.knime.com/user_avatar/forum.knime.com/cppong/32/10981_2.png) [@cppong](https://forum.knime.com/u/cppong)\ **Post date:** [April 8, 2022, 3:15am UTC](https://forum.knime.com/t/how-we-can-speed-up-data-query-from-db-oracle-node-database-reader-legacy/41429/6 "2022-04-08T03:15:29Z")
Never try this before. Thanks a lot @ipazin ---
**Author:** ![cppong](https://forum-cdn.knime.com/user_avatar/forum.knime.com/cppong/32/10981_2.png) [@cppong](https://forum.knime.com/u/cppong)\ **Post date:** [April 8, 2022, 3:16am UTC](https://forum.knime.com/t/how-we-can-speed-up-data-query-from-db-oracle-node-database-reader-legacy/41429/7 "2022-04-08T03:16:17Z")
Thanks a lot @mlauber71 for an example of the script. ---
**Author:** ![Thyme](https://forum-cdn.knime.com/user_avatar/forum.knime.com/thyme/32/34550_2.png) [@Thyme](https://forum.knime.com/u/Thyme)\ **Post date:** [April 8, 2022, 8:37am UTC](https://forum.knime.com/t/how-we-can-speed-up-data-query-from-db-oracle-node-database-reader-legacy/41429/8 "2022-04-08T08:37:21Z")
KNIME has gotten an overhaul of the DB framework with version 4.1. The nodes also got new names, they’re now called “DB something”: ![Unbenannt](https://forum-cdn.knime.com/uploads/default/original/3X/0/8/08c46a5ddcc37af40bc81de5dca416666043583f.png) You should update to the newest version your company allows you to. There’re new features, more speed and, most importantly: easier support on the forum 😉 Also, as a general rule, versions x.y.0 should not be used for production purposes. Those version focus on new features and thus have the highest risk of introducing undetected bugs. source: > [@Problem when upgrading to 4.14.0](https://forum.knime.com/t/problem-when-upgrading-to-4-14-0/38067/3): > > Hi Sébastien, please note that we generally discourage the use of .0 releases in production environments. Likely the issue is that a small error during the update process is preventing the server from properly starting. For example not deleting the old /webapps/knime folder, or not renaming the new .war file to knime.war. If you’d like, you can share the most recent catalina and localhost log files with [support@knime.com](mailto:support@knime.com). Maybe that already enables us to find the cause. Otherwise, we can als… ---
**Author:** ![cppong](https://forum-cdn.knime.com/user_avatar/forum.knime.com/cppong/32/10981_2.png) [@cppong](https://forum.knime.com/u/cppong)\ **Post date:** [April 11, 2022, 7:51am UTC](https://forum.knime.com/t/how-we-can-speed-up-data-query-from-db-oracle-node-database-reader-legacy/41429/9 "2022-04-11T07:51:42Z")
Thanks so much @Thyme I had checked it and found the database name will be DB… as you shown in the pics. ---
**Author:** ![cppong](https://forum-cdn.knime.com/user_avatar/forum.knime.com/cppong/32/10981_2.png) [@cppong](https://forum.knime.com/u/cppong)\ **Post date:** [April 11, 2022, 7:54am UTC](https://forum.knime.com/t/how-we-can-speed-up-data-query-from-db-oracle-node-database-reader-legacy/41429/10 "2022-04-11T07:54:21Z")
@ipazin Bingo !! I found the new DB version (instead use Legacy) & implemented all the DB connectors & SQL reader. It’s very fast to query. My problem was solved now. Thanks again and thanks to others for the great help! 😃 😁 😄 ---
**Author:** ![cppong](https://forum-cdn.knime.com/user_avatar/forum.knime.com/cppong/32/10981_2.png) [@cppong](https://forum.knime.com/u/cppong)\ **Post date:** [April 11, 2022, 7:56am UTC](https://forum.knime.com/t/how-we-can-speed-up-data-query-from-db-oracle-node-database-reader-legacy/41429/11 "2022-04-11T07:56:17Z")
Thanks for all of your help. It solved now ^^ ---
**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\ **Post date:** [April 18, 2022, 7:56am UTC](https://forum.knime.com/t/how-we-can-speed-up-data-query-from-db-oracle-node-database-reader-legacy/41429/12 "2022-04-18T07:56:36Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.