我寫了一點測試查詢代碼,居然發現linux下秒查,windows下要十幾秒:
求告知我是那裡沒有弄對嗎?
實在抱歉實在沒分
sqlStr = """
select *
from course
left outer join courseItem on course.id==courseItem.courseId
left outer join courseChoose on courseItem.id== courseChoose.courseItemId
left outer join student on courseChoose.studentId==student.id
left outer join courseYear on course.courseYear==courseYear.id
where student.id==1936
order by courseItem.startTime asc
"""
import sqlite3
cx = sqlite3.connect("db.s3db")
cu = cx.cursor()
print("start>>>")
cu.execute(sqlStr)
print("end<<<<<<<<<")
如果是這樣應該不就出這樣的問題,想說的也可能是系統的問題吧