Create next table with columns min, max, count and create triggers for insert, delete and modification. -- Kit
2012/3/20, Rita <rmorgan...@gmail.com>: > 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 > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users