Hi, I did tried something crazy like this (it worked, for read only DB only). I changed pread to preadCustom api.Then in preadCustom maintained a static fdArray. if fd is not listed then i mmap the whole file and the use the memcpy to return the data. There was significant performance again as there was no context switch. U can overload all the os wrappers to your custom impl and then share it with multiple threads.
I had to do this as even mounting the file on /dev/shm there was no significant performance gain. Just a possible direction, regards ragha ****************************************************************************************** This email and its attachments contain confidential information from HUAWEI, which is intended only for the person or entity whose address is listed above. Any use of the information contained herein in any way (including, but not limited to, total or partial disclosure, reproduction, or dissemination) by persons other than the intended recipient(s) is prohibited. If you receive this e-mail in error, please notify the sender by phone or email immediately and delete it! ***************************************************************************************** ----- Original Message ----- From: Virgilio Alexandre Fornazin <[EMAIL PROTECTED]> Date: Tuesday, August 28, 2007 8:42 pm Subject: [sqlite] In memory database question > Hi > > > > There´s possible to share a sqlite3 handle to a memory database in all > threads of application? > > Or there´s a way to ?duplicate? the handle (sqlite_open() or > something like > that)? > > > > > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------