Table: va_edges_detail_temp
Source_label: varchar2
Target_label: varchar2
Edge_weight: number

The select v. *, level from va_edges_detail_temp v
Start with v. ource_label='limbang'
Connect by nocycle the prior v.t arget_label=v. ource_label
The order by level;


When only 552 rows in the table, carried out smoothly, in 0.005 seconds,
When there are more than 5000 data in the table, implementation has been performed, the results and you won't come, what is this,

CodePudding user response:

Convenient take these data posted?

CodePudding user response:

Recursion and sorting, will slowly
How long did not come out? How long, or perform out results

CodePudding user response:

I waited for five hours, still no results,

CodePudding user response:

reference 1st floor wmxcn2000 response:

convenient stick these data come out?

Data is a bit sensitive, is not convenient to post, is between transfer record,

CodePudding user response:

refer to the second floor sych888 response:

recursive and sorting, will slowly
How long did not come out? How long or perform out results

I've run into a similar problem, is to perform a 20000 rows of data, the algorithm of a memory consuming, is also the result a few hours out,
Don't know if the common fault of the oracle large memory algorithm,

CodePudding user response:

reference 4 floor xxchill response:

a little sensitive data, is not convenient to post, is between transfer record,

I tested a 5 w here row data, have not found this situation, you which version of the library? Said the specific small version;

CodePudding user response:

More than 5000 lines is not dead,
See what's waiting for v $session_wait
Handle sensitive data, then give some sample data

CodePudding user response:

refer to 6th floor wmxcn2000 response:

Quote: refer to 4th floor xxchill response:

Data is a bit sensitive, is not convenient to post, is between transfer record,

I tested a 5 w here row data, have not found this situation, you which version of the library? Said the specific small version;

Oracle 11 g

CodePudding user response:

refer to the eighth floor xxchill response:

Quote: refer to the sixth floor wmxcn2000 response:

Quote: refer to 4th floor xxchill response:

Data is a bit sensitive, is not convenient to post, is between transfer record,

I tested a 5 w here row data, have not found this situation, you which version of the library? Said the specific small version;

Oracle 11 g

Small version?

CodePudding user response:

refer to 7th floor jdsnhan response:

5000 line is not dead,
See what's waiting for v $session_wait
Handle sensitive data, then give some sample data

The purpose of this program is to find the person is in a tree in the hierarchy, I try to use a c + + program to deal with the same data set, the c + + program is a classic tree times calendar calculation method, the results in less than 3 minutes to get the results,
Depressed,,,,,,,, if oracle is not suitable for large quantity, the consumption of large memory algorithm,

CodePudding user response:

references 9 f wmxcn2000 response:

Quote: refer to the eighth floor xxchill response:

Quote: refer to the sixth floor wmxcn2000 response:

Quote: refer to 4th floor xxchill response:

Data is a bit sensitive, is not convenient to post, is between transfer record,

I tested a 5 w here row data, have not found this situation, you which version of the library? Said the specific small version;

Oracle 11 g

Small version?

Sorry, wrong and version is 10.2.0.4.0