[sqlite] How can I test test_onefile.c?
How can I test test_one_file.c or test_demovfs? I want to use Some VFS shims in website like test_demovfs.c or test_onefile.c . But I don't know how can I use them. Is there some documentation about using them? or Is there any tips for me? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Questions regarding using test_onefile as VFS
The documentation seems to state that in order to use test_onefile, instead of providing an option when compiling sqlite3, test_onefile must be set as vfs with the -vfs command option in the shell. Is my understanding correct? The documentation does not provide examples using vfs demo files such as test_onefile or test_demovfs. In order to use those vfs demo files, do I need to edit the shell source code myself? Are there any existing documentations on the usage of files such as test_demovfs or test_onefile? Or are there any tips or books on this matter that you can recommend me? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Is there any reason which use OS file system on default mode?
If sqlite3 access storage device directly, I think, it must be faster than using os file system. Because using os file system mean there must be some overhead. So, I'm curious about the reason why use os file system default. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Is there any document, when I wanna implement own VFS?
I spend much time to find for reference of implementing VFS. But I can’t find any reference of that. I wanna know some requirement and manual for implementing my own VFS. Is there anything that help me? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Can sqlite access storage system directly?
After spend quite long time search for regarding to use file I/O in SQLite, I've found that through the VFS layer is the only way go into the kernel. However I am wandering about if there is other method to detour filesystem, so that SQLite is directly interface with device driver layer. I think there might be number of disadvantage if SQLite run without filesystem help, but there will be performance gain. ( e.g. From not using Journaling and eliminate block I/O overhead.) Is there anyone have tried it or know about method? it would very helpful at least tell me whether it is possible or not. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users