Since you produce the statistics once per month on a schedule
it would be more efficient to not have an index. The index will slow down daily
operations each time a record is inserted. Copy the database file once per
month to a 'snapshot' file. Add the index to the snapshot database and
then produc
have you some feeling on my problem?
cut or not cut db files?
>-PÃvodnà sprÃva-
>Od: D. Richard Hipp [mailto:[EMAIL PROTECTED]
>OdoslanÃ: 15. aprÃla 2005 11:15
>Komu: sqlite-users@sqlite.org
>Predmet: Re: [sqlite] optimize table
>
>
>On Fri, 2005-04-15 at 06:15 -0400, Ken & Deb Allen wro
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]
>Odosl
3 matches
Mail list logo
