Oracle spool advantages and disadvantages, and performance, to solve! With the spool after written to the file and detected by the program, in written to the file through the program, the difference between two kinds of distribution, hope god can give answer, thank you

CodePudding user response:

Spool is a function of up sqlplus, obviously this is a relatively common technology, use very convenient also, performance and the degree of the server is busy, network bandwidth and storage performance of these factors can have relationship, if more than 1 g data, do not recommend using sqool to deal with,

If you develop a program to realize the function of the spool, also is no problem, if the time on the rich, can write a more convenient tools, but this need time,

Performance, depends on the developers split language proficiency, a high level, can write a client to performance than up sqlplus,