i dont need working with dates and times.. i only set 1 records on which was done..
which index is better to create for this problem? must i cut db files? or speed of statistic will be same now and after 1000 000 records? >-----Pôvodná správa----- >Od: Gert Rijs [mailto:[EMAIL PROTECTED] >Odoslané: 15. apríla 2005 7:13 >Komu: sqlite-users@sqlite.org >Predmet: Re: [sqlite] optimize table > > >msaka msaka wrote: >> >> CREATE TABLE sale( >> id INTEGER NOT NULL UNIQUE PRIMARY KEY, >> bill_no integer, >> bill_item_no integer, >> item_name varchar(20), >> qty integer, >> amount DOUBLE, >> statistic integer >> ) >> >> > >Why don't you replace "statistic" with a timestamp formatted like >yyyymmdd, perhaps add the time as well. If you add an index on it you >can efficiently retrieve the rows for certain date periods without >needing to update the table. > >Gert
