Found the problem the reason
Mysql table LianZha, or nested tables in the query, is relatively slow

So when we develop, want to is, put a table id found out, all combined into 1, 2, 3, 4, 5 check when another table in (1, 2, 3, 4)
Speed can still,

But after into Oracle, found that just a list of the 280000 data, should return to the 1000-3000 id also to ten seconds

But in the big data search in the Oracle, and soon, as long as the returned result is not too big,
Don't know whether have what setting is wrong, also in Oracle group, and friends to discuss,
They are not sure why, but they are all professional server, tens of thousands of article, Plsql the whole show, is also a second level

CodePudding user response:

Problem didn't understand:

1, "is just a list of the 280000 data, should return to the 1000-3000 id also want ten seconds", this sentence means: 280000 record form table query returns the meaning of 1000 ~ 3000 records? Every time the query takes 10 seconds?

2, in addition, "but from big data search in the Oracle, and soon, as long as the returned result is not too big", what is the meaning of this sentence?

CodePudding user response:

I put the pictures are posted, you like to have a look.

CodePudding user response:

Still don't understand what do you want to express? Three corresponding graph and how to thread you problem?
I can only guess: finally a picture, you are more than 30000 records, it has taken more than 7 seconds, this belongs to the normal situation, the faster, because you did not return all the records, just return to a page, in this case, despite the obvious network overhead, a big drop in can occur within oracle different execution plan, lead to different performance,

CodePudding user response:

PL/SQL Developer this tool, shows a large amount of data, itself is slow, but this does not mean slow query speed,

Best to run the program, see the actual effect, if there are obvious differences, ask again,

CodePudding user response:

Look at your watch blocks, isn't it often delete, no defragmentation

CodePudding user response:

If table index is not problem, the likelihood is the ORACLE server is a problem with the network or disk, speaking, reading and writing,

CodePudding user response:

The

reference 4 floor selling fruit net reply:

PL/SQL Developer this tool, shows a large amount of data, is very slow, but this does not mean slow query speed,

Best to run the program, see the actual effect, if there are obvious differences, again ask,

+ 1, PL/SQL Developer displayed in the tool is not going well. Verify with code, after query, direct look at the count.

CodePudding user response:

As the database itself it doesn't matter, PLSQL show so much data is not so fast