Re: [sqlite] 2 more questions

2013-11-20 Thread Clemens Ladisch
Igor Korot wrote: > 1. I am working with C++ using C API to access the DB. > What I did was: > > upon startup - read the data in the std::vector<>, then use > std::sort() to sort this vector appropriately. > > Now, today it hit me that I can use "ORDER BY" SELECT clause to > retrieve data as

[sqlite] 2 more questions

2013-11-19 Thread Igor Korot
Hi, ALL, 1. I am working with C++ using C API to access the DB. What I did was: upon startup - read the data in the std::vector<>, then use std::sort() to sort this vector appropriately. Now, today it hit me that I can use "ORDER BY" SELECT clause to retrieve data as pre-sorted. What is best