Re: [sqlite] opcode count for sqlite3_progress_handler

2006-05-18 Thread drh
"Brannon King" <[EMAIL PROTECTED]> wrote: > Suppose I have a table with 6 INTEGER columns, and 600k entries. I need = > to > create a unique index on three of those columns, ie., CREATE UNIQUE = > INDEX > loc ON data (x,y,z). That takes a while so I thought I'd show some = > progress. > >From that

[sqlite] opcode count for sqlite3_progress_handler

2006-05-18 Thread Brannon King
Suppose I have a table with 6 INTEGER columns, and 600k entries. I need to create a unique index on three of those columns, ie., CREATE UNIQUE INDEX loc ON data (x,y,z). That takes a while so I thought I'd show some progress. >From that information, is it possible to calculate the number of opcodes