[sqlite] batch or one by one?

[王庆刚]

hi,all

     There is an interesting phenomenon.As you know, SQLite can retrieve 
records by batch or one by one.
     1.Retrieve by batch such as sqlite3_get_table.
     2.Retrieve one by one such as sqlite3_prepare_v2 and sqlite3_step together.
     Using the above two methods to retrieve hundreds of records by random, 
which method is fast?

     best regard!
     WQG