Günter Greschenz wrote:
hi,
thanks for the quick answer :-)
i always thought there is always an index for "rowid" ? thats the
reason why i implemented it like this...
i need to store a maximum amount of data in the database (e.b. max
100000 entries or max 10 days)
any idea how i could implement it in another way ?
you're right, the pc has a lot of other tasks running !
e.g. there is a ms sql server installed and i dont know exactly how
much disk-io this server is doing !
thanks a lot !
Gunter,
The following posts to this list show how to create an efficient FIFO
table in sqlite
http://article.gmane.org/gmane.comp.db.sqlite.general/16230/match=fifo
and this one gives some more info on the fifo id reset problem
http://article.gmane.org/gmane.comp.db.sqlite.general/16248/match=fifo
This should help you build a table with a maximum number of entries.
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------