Re: [sqlite] creating virtual tables

Kit, Do you have an example for that? On Tue, Mar 20, 2012 at 7:48 AM, Kit wrote: > Create next table with columns min, max, count and create triggers for > insert, delete and modification. > -- > Kit > > 2012/3/20, Rita : > > Hello, > > > > I have a single table which has close to 4 millions

Re: [sqlite] creating virtual tables

Create next table with columns min, max, count and create triggers for insert, delete and modification. -- Kit 2012/3/20, Rita : > 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, > an

Re: [sqlite] creating virtual tables

On 20 Mar 2012, at 10:45am, Rita wrote: > 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 ta

[sqlite] creating virtual tables

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