Home > database >  Sqlite prepare step success of great god have a look at the trouble!!!!!!!!!!!!!!!!!!!
Sqlite prepare step success of great god have a look at the trouble!!!!!!!!!!!!!!!!!!!

Time:10-17

I open a database attach 3 database, prepare to return to the "ok" to step when it returns 1 for great god see

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 the time & gt;=1583292379000 and time & lt;=1583304920999 and score & gt;=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 the time & gt;=1583292379000 and time & lt;=1583304920999 and score & gt;=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 the time & gt;=1583292379000 and time & lt;=1583304920999 and score & gt;=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 the time & gt;=1583292379000 and time & lt;=1583304920999 and score & gt;=0 and type='2' order by time desc limit 40 98080

Four database data more added up to about 1 G I'm running on ubuntu64 equipment, no problem, a single database search article 4 data together about hundreds of thousands of data, people wonder if has to do with my database environment configuration such as sqlite macro precompiled
  • Related