R/W life time restrictions on internal phone memory

[mading1309]

Hi

following situation
An application samples data and write them frequently to a SQLlite database. The database is local to the phone. Assume the sample frequence is 1 per 10s. 6 samples are summerized to one meanvalue. The meanvalue is stored in the database as one record. The application shall run constant 24h/7d a week. By request, records are uploaded to a MYSQL database hosted by a website.

This example, assume 1 year running, produce at least 60*24*360 = 518400 write cycles (each new record). In case a memory block has to be deleted before then save a record results in two write cycles (clear and write). So lets calculate with at least 600000 write cycles per year.

My questions now:
1) does anyone have experience with this large number of write cycles?
2) I have already tried the internet to get general information about the NAND memory (internal memory) and maximum write cycles of a mobile. Does anyone have reliable information about the used flash memories?
3) If the number of write cycles is a problem, does someone has an idea to get around the problem except use of a replaceable external SD card.

Looking forward to more hints and information

Mading

 

[Erel]

I don't see any problem with these numbers. You can easily make a small test that writes million records to a database (for the test to be relevant you should start a new transaction for each INSERT call).