Recently for a period of time, the problem of using otlv4 or pyodbc query used to slow, 4 article 2 w two coding of data is a table using the select can wait for more than ten minutes, the friend encountered similar problems, share the solution?

CodePudding user response:

No, direct use of SQL Server Management Studio tools and see how long time, if this soon, means you take the program

CodePudding user response:

Select the operation efficiency of python can also, but join what is slower,
If you have multiple in python will join operation difficult? Have you said this kind of question,

You can try with python directly connect to the database, then run the database scripts, and such as can define fetchsize variables