亚洲免费在线-亚洲免费在线播放-亚洲免费在线观看-亚洲免费在线观看视频-亚洲免费在线看-亚洲免费在线视频

In-Memory Databases

系統(tǒng) 1788 0

In-Memory Databases

In-Memory Databases

An SQLite database is normally stored in a single ordinary disk file. However, in certain circumstances, the database might be stored in memory.

The most common way to force an SQLite database to exist purely in memory is to open the database using the special filename " :memory: ". In other words, instead of passing the name of a real disk file into one of the sqlite3_open() , sqlite3_open16() , or sqlite3_open_v2() functions, pass in the string ":memory:". For example:

        rc = sqlite3_open(":memory:", &db);

      

When this is done, no disk file is opened. Instead, a new database is created purely in memory. The database ceases to exist as soon as the database connection is closed. Every :memory: database is distinct from every other. So, opening two database connections each with the filename ":memory:" will create two independent in-memory databases.

The special filename ":memory:" can be used anywhere that a database filename is permitted. For example, it can be used as the filename in an ATTACH command:

        ATTACH DATABASE ':memory:' AS aux1;

      

Note that in order for the special ":memory:" name to apply and to create a pure in-memory database, there must be no additional text in the filename. Thus, a disk-based database can be created in a file by prepending a pathname, like this: "./:memory:".

The special ":memory:" filename also works when using URI filenames . For example:

        rc = sqlite3_open("file::memory:", &db);

      
Or,
        ATTACH DATABASE 'file::memory:' AS aux1;

      

In-memory Databases And Shared Cache

In-memory databases are allowed to use shared cache if they are opened using a URI filename . If the unadorned ":memory:" name is used to specify the in-memory database, then that database always has a private cache and is this only visible to the database connection that originally opened it. However, the same in-memory database can be opened by two or more database connections as follows:

        rc = sqlite3_open("file::memory:?cache=shared", &db);

      
Or,
        ATTACH DATABASE 'file::memory:?cache=shared' AS aux1;

      

This allows separate database connections to share the same in-memory database. Of course, all database connections sharing the in-memory database need to be in the same process. The database is automatically deleted and memory is reclaimed when the last connection to the database closes.

If two or more distinct but shareable in-memory databases are needed in a single process, then the mode=memory query parameter can be used with a URI filename to create a named in-memory database:

        rc = sqlite3_open("file:memdb1?mode=memory&cache=shared", &db);

      
Or,
        ATTACH DATABASE 'file:memdb1?mode=memory&cache=shared' AS aux1;

      

When an in-memory database is named in this way, it will only share its cache with another connection that uses exactly the same name.

Temporary Databases

When the name of the database file handed to sqlite3_open() or to ATTACH is an empty string, then a new temporary file is created to hold the database.

        rc = sqlite3_open("", &db);

      
        ATTACH DATABASE '' AS aux2;

      

A different temporary file is created each time, so that just like as with the special ":memory:" string, two database connections to temporary databases each have their own private database. Temporary databases are automatically deleted when the connection that created them closes.

Even though a disk file is allocated for each temporary database, in practice the temporary database usually resides in the in-memory pager cache and hence is very little difference between a pure in-memory database created by ":memory:" and a temporary database created by an empty filename. The sole difference is that a ":memory:" database must remain in memory at all times whereas parts of a temporary database might be flushed to disk if database becomes large or if SQLite comes under memory pressure.

The previous paragraphs describe the behavior of temporary databases under the default SQLite configuration. An application can use the temp_store pragma and the SQLITE_TEMP_STORE compile-time parameter to force temporary databases to behave as pure in-memory databases, if desired.

In-Memory Databases


更多文章、技術交流、商務合作、聯(lián)系博主

微信掃碼或搜索:z360901061

微信掃一掃加我為好友

QQ號聯(lián)系: 360901061

您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點擊下面給點支持吧,站長非常感激您!手機微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點擊微信右上角掃一掃功能,選擇支付二維碼完成支付。

【本文對您有幫助就好】

您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描上面二維碼支持博主2元、5元、10元、自定義金額等您想捐的金額吧,站長會非常 感謝您的哦!!!

發(fā)表我的評論
最新評論 總共0條評論
主站蜘蛛池模板: 色酷综合 | 激情婷婷综合 | 91精品免费国产高清在线 | 亚洲精品一区二区伦理 | 在线免费精品视频 | 日韩精品一区二区三区四区 | 五月婷婷激情四射 | 精品无人乱码区1区2区3区 | 国产啪视频1000部免费视频 | 国产亚洲精品一区二区久久 | 激情在线视频 | 免费爱爱视频网站 | 欧美午夜性春猛交 | 91高清免费国产自产拍2021 | 私人影院免费观看 | 四虎国产精品免费五月天 | 99免费在线观看 | 天天综合天天综合 | 激情影院免费看 | 在线看v| 狠狠色成人综合首页 | 小明看看成人免费 | 国产精品久久久久久麻豆一区 | 欧美午夜精品久久久久免费视 | 久久sese | 国产精品亚洲片在线牛牛影视 | 99re热这里只有精品视频 | 情趣视频网站在线观看 | 亚洲精品福利在线观看 | 国产69精品久久久久99不卡 | 久久亚洲一区二区 | 91久久亚洲精品一区二区 | 久久er热这里只有精品23 | 国产成人精品视频播放 | 91妖精视频| 久爱午夜精品免费视频 | 一级毛片网 | 亚洲欧美一区二区三区在线 | www.国产在线观看 | 可以免费观看欧美一级毛片 | 狠狠操天天操视频 |