LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Shalaka

Hello,

I am using DB execute and DB store nodes in the graph. DB execute node, selects data from multiple tables. DB store node is used to populate the data to DB. This operations takes long time to extract and populate into DB using lavastorm. It almost took 3 hrs to do the operation.

I tried the same DB execute query to extract data and insert into table through oracle. This executed very fast.... in 10 mins time.

Please let me know if there is any mechanism to improve node performance.


Thanks in advance.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: gmullin

Are you using a JDBC driver? It will tend to be slower than if you can use OCI or ODBC.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

To select some records and insert them into a table on the same database, all operations can be done inside the database server itself.
When you extract the records to your LAE server, you must take into account the volume of the data and any network latency between the LAE server and the DB server.