Ask a question, I have here some oracle data, these data need to some of the data association of mysql data association, and judgment, in this case, is to conduct additional SQL query is faster, or build a transit form joint query is faster,
Under the said conditions about
Article 1. The amount of data about 1000 on down,
2. The two fields that need additional associated mysql
(1) the first is simpler, according to a value for another and the total number of not too much, but need to query and only oracle mysql query a
(2) the second more troublesome the need according to the result of the first query out and several other conditions for the query,

Using PHP

CodePudding user response:

Since thinking had, can respectively under test efficiency, multiple data sources, suggested that provide data in the form of interface, data association, and judgment can be in the business logic processing is faster,
Recommended data download: a deep understanding of MySQL