我open了一個資料庫 attach了3個資料庫，prepare回傳ok step的時候卻回傳1 求大神看看
select face_pic_index,chnid,encid,time,type,age,sex,pic_h,pic_w,rectange_h,rectange_w,rectange_x,rectange_y,data_len,score,snap_type,yuv,algname,url_db_index,data_primarykey,data_db_index from face_pic where (chnid = 0 or chnid = 1 ) and time >= 1583292379000 and time <= 1583304920999 and score >= 0 and type = '2' union all select face_pic_index,chnid,encid,time,type,age,sex,pic_h,pic_w,rectange_h,rectange_w,rectange_x,rectange_y,data_len,score,snap_type,yuv,algname,url_db_index,data_primarykey,data_db_index from airpsrv_1.face_pic where (chnid = 0 or chnid = 1 ) and time >= 1583292379000 and time <= 1583304920999 and score >= 0 and type = '2' union all select face_pic_index,chnid,encid,time,type,age,sex,pic_h,pic_w,rectange_h,rectange_w,rectange_x,rectange_y,data_len,score,snap_type,yuv,algname,url_db_index,data_primarykey,data_db_index from airpsrv_2.face_pic where (chnid = 0 or chnid = 1 ) and time >= 1583292379000 and time <= 1583304920999 and score >= 0 and type = '2' union all select face_pic_index,chnid,encid,time,type,age,sex,pic_h,pic_w,rectange_h,rectange_w,rectange_x,rectange_y,data_len,score,snap_type,yuv,algname,url_db_index,data_primarykey,data_db_index from airpsrv_3.face_pic where (chnid = 0 or chnid = 1 ) and time >= 1583292379000 and time <= 1583304920999 and score >= 0 and type = '2' order by time desc limit 98080,40
資料比較多 4個資料庫加起來差不多1個G 我是在ubuntu64設備上運行的，單個資料庫搜索沒問題。4個資料加起來大概幾十萬條資料，個人懷疑是不是跟我的資料庫環境配置有關比如sqlite宏預編譯的時候
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/24910.html
標籤：其他數據庫
上一篇：亂數不變化的問題
下一篇：postgresql在配置里面可以直接加serverTimezone=UTC設定時區嗎？資料庫保存的時間比實際時間少8小時