Hello, This two requests are differents from both compute time and results! Why?
SELECT count(*) FROM events; -- very long for big DB SELECT max(rowid) FROM events; -- very quick Thanks in advance. ------------------------------ Ing. KINDT Raphaël Software R&D Manager Rue des Bleuets, 1b E-Mail : [EMAIL PROTECTED] B-7000 Mons (Belgium) Phone : +32 (0)65 352 252 Web site: www.seldes.com Fax : +32 (0)65 352 253 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
