sqlite prepare成功 step失败 麻烦大神看一下!!!!!!!
雨中古铜 2020-03-25 05:39:55 我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宏预编译的时候