sqlite - Does an in-memory database also have a filesystem component? -

-

I am working with the DataMaper which allows you to specify a path for the database file on your system or Just string "memory" and then an "in-memory" database is used, however, I do not know what it means.

Is an "in-memory" database completely memory-based or is it sorted on the file system at any time?

What is the benefit of the in-memory database?

For the efficiency of removing the cost of the filesystem access?

Due to the fact that the memory database in SQLite is not actually for display. In practice, leaving the file is not really any slow motion, except that if you get out of memory, it is actually mostly for temporary caching or testing, for example you can use in-memory for your unit test. You can use DB so that you can not go to the production data. Or if you want SQL functionality, you can use it as a substitute for a memcache. Actually, it's there so that you do not to continue the data, if you do not need it.


Comments

Post a Comment