Re: [sqlite] About "select * from table ....." with Sqlite

yoky wrote: > Hi all, > I create a table with 200 columns, then use sqlite3_prepare() and > sqlite3_step()to get a record by this: "select * from tbl where ID =.. ". > Test in my > embedded system,The total time is about 65ms,it is too long for the > performance > requirement, I found

[sqlite] About "select * from table ....." with Sqlite

Hi all, I create a table with 200 columns, then use sqlite3_prepare() and sqlite3_step()to get a record by this: "select * from tbl where ID =.. ". Test in my embedded system,The total time is about 65ms,it is too long for the performance requirement, I found sqlite3_prepare() time is about

[sqlite] About "select * from table....." by Sqlite

Hi all, I create a table with 200 columns, then use sqlite3_prepare() and sqlite3_step() to get a record by this: "select * from tbl where ID =.. ". Test in my embedded system The total time is about 65ms,it is too long for the performance requirement, I found