Hello, I have a single table which has close to 4 millions rows. I write once and read many times with SELECT. I mainly work with operations like max, min, and count so I was wondering instead of creating views is there a way I can get the count() of a table and place it in a SQL variable or table? While the table is getting populated I would like to build this counter. Or have a SQL variable (if possible) like, count=select count(id) from table;
-- --- Get your facts first, then you can distort them as you please.-- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
