???????????????
???????????? ???????[ 2016/10/13 10:05:00 ] ?????????????
??????????????????????????????????????????????:
????1.???????????????????????? ???????????????????????????????????????? ???????????????????fd?????????????Σ? ?????? ??sqlite???????????????????????????fd ??????????????fd??д??? sqlite??????? ????????й????У??????????????? ???????????????У????????????????????????????μ????????????????????????????????????? ?????????????sqlite??api?? ????????? ???????а???rollback????????????????????????????п???????????????
????2. ????????
????sqlite??????????????????????????????????????????????????д??????????????????????????????????????????????? ????????????У??????? ????????close()???? ??Unix?У?close()??????????????????????? ????A??B???????????????????sqlite??api??????????C???ε?????open()??read()???close()???????????????????????????????A??B?п??????д?????????С? ??????????ò??????Э??(locking protocols) ??????POSIX advisory locking????????sqlite3_open_v2()???????????????£????????????д??????????? ??????????????rename??unlink ????????A??B???????????????????????????????A????????unlink???????????????????????μ????????????????????????????A??B????????????ò?????????????????????? ?????????????????????????????????????????????????????????????????????????????????????????? ???????ж?????? ????????????????ж???????????A??B??ò??????????????????????????????????????? ??????A crash???B??????????rollback???????????????????????
????3. sync???
?????????????????????????consistent?????????fsync()?????????????е?????????????С???????sync??????????????????????
????sync?????ú????????????? USB???澭?????????????д????????????????????д???????USB?????????????? ???PRAGMAs????sync synchronous=OFF?????????????????????????
????4.??????????
????5. ?????
????????????????????????????????е???????????????п?????????????????? ??????memory-mapped I/O?????????????????????????????????????????е?????????????????????
????6. ?????????????? ?????????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11