I program embedded systems using microcontrollers on occasions. The
method there is to store programs and tables in flash and dynamic data
in RAM. Perhaps you can partition your application that way. With
Sqlite you could have two databases, one with static tables in flash and
the other in RAM and use ATTACH to create your working database.
You would want your journal files to be in RAM.
Joel Cochran wrote:
Well then I am certainly using it for general processing. Perhaps I should
explore the possibility of using the machine memory, although especially
once we get in to image processing I'm not sure that will be sufficient.
Thanks,
Joel
On 4/13/07, John Stanton <[EMAIL PROTECTED]> wrote:
Flash memory is for read only access on a continuing basis but has a
certain number of write cycles to use for load it with data. For
example you might use it for backups or for loading and distributing
software or playing music but if you use it like a disk drive it will
hit its write limit after a certain number of writes and updates and
fail.
Look to the detailed specs of the card you are using to get exact
details.
By "general processing" I meant the way you use a disk drive and subject
it to repeated writes and updates, not just reads.
Joel Cochran wrote:
> John,
>
> What do you mean by "general processing"? The database is on the CF
card,
> the application accesses the database. Other than what application
> normally
> do (select, update, insert, etc.), I'm not sure what else to tell you.
>
> Or do you mean over the course of the lifetime of a CF card it can only
be
> used so much? That might apply to this scenario, these cards have been
> written over continuously for the last 6 months.
>
> Joel
>
> On 4/13/07, John Stanton <[EMAIL PROTECTED]> wrote:
>
>>
>> Regular flash memory has a limited number of write cycles before it
>> fails. Are you hitting this problem by using it for general
processing?
>>
>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
