All geek questions in one place

Oracle Quick Picks [Huge Data]

I have a project in which I read huge volumes of data from an Oracle database from Java.

I have the feeling that the application we are writing will process the data much faster than it will be given to us using a single-threaded SELECT query, and therefore I am trying to explore faster ways to get the data.

Does anyone have anything I could read that would help me with my distress?

+3
source share
4 answers

Oracle supports concurrent DML . In particular, this applies to SELECT queries. Ultimately, the bottleneck is likely to be IO read speed. Either use faster disks or a data strip across many disks.

Update

Like APC in the comments, Parallel Queries / DML is an Entreprise Edition Feature and is not available in the standard version.

, Parallel DML/Query . , , concurrency. parallelism - . IO , , parallelism .

:

:

  • , CPU, - . ; , .
+3

, " " Java . , . , Oracle ​​, , (SQL), rdbms (PL/SQL), .

+3

setFetchSize (int) Statement PreparedStatement , . . 75 .

, PL/SQL " " 2000 3000, , , 75 .

. , , .

+3

-, " " - [ ] , , . , ?

, , , . , . , SSD, , , .

, . , .

-, . .

, . , java, (, A-K L-Z), SELECT.

dpbradley, . , , , ( , ), , , .

+2

Source: https://habr.com/ru/post/1734414/

More articles:


All Articles