On 19 Mar 2016, at 8:54pm, Domingo Alvarez Duarte <sqlite-mail at dev.dadbiz.es> wrote:
> When you say [The majority of the time in 'CREATE INDEX' is spent writing the > index, not reading the table.] where the data to spend time creating the > index come from ? Use the SQLite shell tool. Use the '.timer ON' command. Write a command to read every row of the table. Time the command. Write a command to create a new index. Time the command. Subtract one from the other. Simon.
