On Wed, Nov 4, 2009 at 12:51 AM, Serdar Genc <serdar.g...@gmail.com> wrote: > The OS that I am implementing this is SunOS and I have already tried doing > it by creating the file in /tmp but > but because of file I/O operations to reach /tmp. The speed of sqlite is > significantly slow (memory is 5 times faster than file system). Speed of > Sqlite is important for me. That's why I still working on the memory issue. >
Hi there, /tmp is not the same as tmpfs -- tmpfs is a file system that stores files in RAM, but looks otherwise like any other file system. On SunOS it should be straightforward; that wiki page says "SunOS, and later Solaris, include probably the earliest implementations of tmpfs". Stephan > Thanks for the answer, > Serdar Genc > > On Wed, Nov 4, 2009 at 10:45 AM, Stephan Wehner > <stephanweh...@gmail.com>wrote: > >> On Wed, Nov 4, 2009 at 12:27 AM, Serdar Genc <serdar.g...@gmail.com> >> wrote: >> > Hello everyone, >> > >> > I have a little bit problem about in-memory database feature of SQLite. I >> > would like to use two programming languages in my application . >> > These languages will be Java and C++. I would like to reach the same >> > database in memory by using both. I used Xerial for JDBC for Java. >> > Everything seems fine if I am using a regular file on harddrive. I can >> write >> > data from C++ process and read these data from Java. >> > But when I try to do this for in-memory, everything is getting chunky. A >> new >> > database is being created in memory for every attempt to open >> > database in memory. Now I am trying to switch the database handler >> between >> > C++ and Java. It requires some efforts. >> > >> > What I want to try to reach the same database in memory from two threads >> or >> > processes and these would be in different programming languages. >> > Any different idea how to implement this is appreciated.. >> >> Can you use a RAM based file system? >> >> http://en.wikipedia.org/wiki/Tmpfs >> >> Stephan >> >> > Thanks in advance, >> > Serdar Genc >> > _______________________________________________ >> > sqlite-users mailing list >> > sqlite-users@sqlite.org >> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > >> >> >> >> -- >> Stephan Wehner >> >> -> http://stephan.sugarmotor.org (blog and homepage) >> -> http://loggingit.com >> -> http://www.thrackle.org >> -> http://www.buckmaster.ca >> -> http://www.trafficlife.com >> -> http://stephansmap.org -- http://blog.stephansmap.org >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Stephan Wehner -> http://stephan.sugarmotor.org (blog and homepage) -> http://loggingit.com -> http://www.thrackle.org -> http://www.buckmaster.ca -> http://www.trafficlife.com -> http://stephansmap.org -- http://blog.stephansmap.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users