What's the consensus on using sqlite with flash based storage such as sd
cards on embedded devices?
Has anyone done this successfully yet with a real product (that needs to
last a few years in the field)?
How does one solve the problem of minimizing writes to flash? I've done
a search through
Hi all,
i am an absolute newbi on sqlite. My problem, is that i have an db with 2
tables
in one table i habe 300 records. in the other 100 records.
when i did an select on the 300 records the table is quite fast, no problem.
when i did an select on the big tabel a always get an failure from
1) what is the timeout for php? The default timeouts are generally
pretty low, often 5 seconds or less.
2) What type of indexes do you have on these tables? Indexes speed up
query performance vastly.
3) Query performance is generally _much_ more sensitive to how many
rows a table has rather than
While I was reading http://sqlite.org/lang_corefunc.html, I noticed what
appears to be a typo:
'Return a copy of string /X/ will all ASCII characters converted to
lower case.'
I believe this is supposed to read:
'Return a copy of string /X/ with all ASCII characters converted to
lower case.'
Paul,
here are a few odd thoughts on this:
--Flash memory devices in general are subject to 'finite' numbers of I/O
events, mostly affecting writes; more recent flash memory devices ease this
constraint a bit, if only by supporting more I/O events before they hit
their useful life-limit. I think
Hello!
I'm using SQLIte on a few dozens winmobile devices a few years. It's work fine
with standart FS. If you want to try raw access to flash you can find
expiremental VFS code for flash and adopt this code for you. I don't remember
where I did see this code.
Best regards, Alexey.
Hello!
В сообщении от Thursday 02 October 2008 18:15:01 John Elrick написал(а):
> While I was reading http://sqlite.org/lang_corefunc.html, I noticed what
> appears to be a typo:
>
> 'Return a copy of string /X/ will all ASCII characters converted to
> lower case.'
>
> I believe this is supposed
On Oct 2, 2008, at 5:05 PM, Alexey Pechnikov wrote:
> Hello!
>
> В сообщении от Thursday 02 October 2008 18:15:01 John
> Elrick написал(а):
>> While I was reading http://sqlite.org/lang_corefunc.html, I noticed
>> what
>> appears to be a typo:
>>
>> 'Return a copy of string /X/ will all
On Thu, Oct 2, 2008 at 4:20 AM, Paul McMahon <[EMAIL PROTECTED]> wrote:
> What's the consensus on using sqlite with flash based storage such as sd
> cards on embedded devices?
>
> Has anyone done this successfully yet with a real product (that needs to
> last a few years in the field)?
>
We've
9 matches
Mail list logo
