|Title:||'pragma mmap_size' doesn't return its new value after setting it|
|Last Modified:||2018-12-22 18:16:42|
|Version Found In:||1.0.109|
anonymous added on 2018-10-24 12:58:03:
Hi, After upgrading System.Data.SQLite.Core NuGet package from 1.0.108 to 18.104.22.168 or 22.214.171.124, and setting mmap_size to any value other than 0, querying its new value with 'pragma mmap_size' doesn't return the expected value but 0. As a side note, and because I don't see this behaviour documented, there's no result from 'pragma mmap_size' working with a :memory: database instead of 0. Thanks in advance.
anonymous added on 2018-10-24 14:25:57:
This new behaviour only occurs when mmap_size is set on a connection, which is then closed, and queried after on a different connection to the same database. If mmap_size is set and then queried on the same connection, it gets the expected result.
anonymous added on 2018-11-15 10:32:03:
Thanks for your response.
mistachkin added on 2018-12-22 18:16:42:
This appears to be working exactly as designed. The mmap_size value is not persistent. To be effective, it must be set on each newly opened connection.