--- RaghavendraK 70574 <[EMAIL PROTECTED]> wrote:
> Your input is valuable. I will increase the pg size to 4KB and check.
:memory: databases only use 1024 byte pages if I remember correctly,
so it would have to be file based.
> We just have a set of tables which is to be read on startup.No complex Query
> is involved.
> I find Sqlite to be most powerful given the size and complexity it handles.
>
> I use the following apis to create the
>
> int ret = sqlite3_open(":memory:",&m_sqliteDb1);
> also use for all temp tables,
> pragma PRAGMA temp_store = MEMORY
That looks fine. It ought to be fast. Although "fast" is a
relative term.
Is this an embedded platform or a PC that you're using?
____________________________________________________________________________________
Sick sense of humor? Visit Yahoo! TV's
Comedy with an Edge to see what's on, when.
http://tv.yahoo.com/collections/222
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
