Hello! sqlite> select max(rowid) from role; 10000000 CPU Time: user 0.000000 sys 0.000000
sqlite> select max(rowid)/1000000. from role; 10.0 CPU Time: user 1.512094 sys 3.732233 sqlite> explain query plan select max(rowid) from role; 0|0|TABLE role USING PRIMARY KEY ORDER BY CPU Time: user 0.000000 sys 0.000000 sqlite> explain query plan select max(rowid)/1000000. from role; 0|0|TABLE role CPU Time: user 0.000000 sys 0.000000 Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
