欢迎使用免登录文字留言板
留言列表(共33条)

[50] 还 [IP:223.104.96.177发表于2022-12-03 12:53:46]

[49] 美美宝宝们奖励https://cowtransfer.com/s/10337d3f3cae4c [IP:223.74.207.156发表于2022-12-03 00:34:12]

[48] [33][美美宝宝福利]https://cowtransfer.com/s/d490d48f27124f [IP:223.74.207.156发表于2022-12-03 00:22:58]

[47] 美美宝宝们: https://cowtransfer.com/s/19bd6fa56d6949  [IP:113.85.107.187发表于2022-12-02 23:35:34]

[46] https://m.zcool.com.cn/work/ZNjI2Nzg5NDg=.html?share_id=685635267 [IP:112.97.162.246发表于2022-11-22 15:01:31]

[45] 【喜迎党的二十大】 https://www.bilibili.com/video/BV1jg411r7v6/?share_source=copy_web&vd_source=d07094e167ec84e9d1bc1f4c23d54a40 [IP:112.97.162.246发表于2022-11-22 14:47:59]

[44] http://jwn.ccdgut.edu.cn/jsxsd/ [IP:112.97.162.246发表于2022-11-22 14:46:20]

[43] https://www.12371.cn/special/xxzd/hxnr/ [IP:59.39.229.43发表于2022-11-22 12:05:52]

[42] #### sqlite3编译过程 下载源码:wget https://www.sqlite.org/2022/sqlite-autoconf-3390200.tar.gz 解压:tar -xzvf sqlite-autoconf-3390200.tar.gz 配置:./configure --prefix=/home/chenjvnsheng/sqlite3 编译:sudo make && make install 在.bashrc文件中添加环境变量: export PATH=$PATH:/home/chenjvnsheng/sqlite3/bin export LIBRARY_PATH=$LIBRARY_PATH:/home/chenjvnsheng/sqlite3/lib export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/home/chenjvnsheng/sqlite3/lib export LD_RUN_PATH=$LD_RUN_PATH:/home/chenjvnsheng/sqlite3/lib export C_INCLUDE_PATH=$C_INCLUDE_PATH:/home/chenjvnsheng/sqlite3/include export CPLUS_INCLUDE_PATH=$CPLUS_INCLUDE_PATH:/home/chenjvnsheng/sqlite3/include sqlcipher编译过程: 下载源码:git clone --branch v4.5.2 https://github.com/sqlcipher/sqlcipher.git 安装openssl: sudo apt-get install openssl sudo apt-get install libssl-dev 配置: ./configure --prefix=/home/chenjvnsheng/sqlcipher --enable-tempstore=yes CFLAGS="-DSQLITE_HAS_CODEC" LDFLAGS="-lcrypto" 编译:sudo make && make install 在.bashrc文件中添加环境变量: export PATH=$PATH:/home/chenjvnsheng/sqlcipher/bin export LIBRARY_PATH=$LIBRARY_PATH:/home/chenjvnsheng/sqlcipher/lib export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/home/chenjvnsheng/sqlcipher/lib export LD_RUN_PATH=$LD_RUN_PATH:/home/chenjvnsheng/sqlcipher/lib export C_INCLUDE_PATH=$C_INCLUDE_PATH:/home/chenjvnsheng/sqlcipher/include export CPLUS_INCLUDE_PATH=$CPLUS_INCLUDE_PATH:/home/chenjvnsheng/sqlcipher/include 版本: Linux Lenovo-Legion-Y7000 5.15.0-52-generic #58~20.04.1-Ubuntu SMP x86_64 GNU/Linux CPU: 8 * Intel(R) Core(TM) i5-8300H CPU @ 2.30GHz CPUCache: 8192 KB Keys: 16 bytes each Values: 100 bytes each 实验一:无事务顺序插入50000条记录 sqlite3: ./sqlite-bench --benchmarks=fillseqsync --num=50000 --no_transaction sqlcipher: ./sqlite-bench --benchmarks=fillseqsync --num=50000 --no_transaction --use_sqlcipher=1 --key=key sqlite3sync: 32.088066 32.131236 31.769386 32.111609 31.995825 sqlite3: 0.744379 0.740678 0.726379 0.747808 0.759734 sqlciphersync: 39223391 40192044 40502450 40.833162 40389892 sqlcipher: 2.162537 2.167733 2.173818 2.225614 2.265493 实验二:事务顺序插入500000条记录 sqlite3: ./sqlite-bench --benchmarks=fillseqsync --num=500000 sqlcipher: ./sqlite-bench --benchmarks=fillseqsync --num=500000 --use_sqlcipher=1 --key=key sqlite3sync: 1.242353 1.210747 1.249257 1.217291 1.271773 sqlite3:1.148765 1.154070 1.164552 1.169516 1.149874 sqlciphersync:1.464213 1.505896 1.531456 1.518346 1.530449 sqlcipher:1.386329 1.384164 1.471683 1.459850 1.472759 实验二:事务随机插入500000条记录 sqlite3: ./sqlite-bench --benchmarks=fillrandom --num=500000 sqlcipher: ./sqlite-bench --benchmarks=fillrandom --num=500000 --use_sqlcipher=1 --key=key sqlite3sync: 2.545127 2.564376 2.656943 2.600534 2.562192 sqlite3: 2.432052 2.512052 2.433637 2.369582 2.475579 sqlciphersync:5.000888 5.090449 5.087058 5.099958 4.991529 sqlcipher:4.988653 5.064643 4.848780 4.904637 4.996144 实验三:事务随机更新500000条数据 sqlite3: 5.565237 5.256655 5.440492 5.710775 5.714821 sqlcipher: 18.123316 18.342618 18.253450 18.257571 实验四:顺序读500000条数据 sqlite3: 0.991589 0.996528 0.983791 0.992208 1.014561 sqlcipher:5.488418 5.595425 5.445282 5.455776 5.472276 实验五:随机读500000条数据 sqlite3: 2.135662 2.117624 2.240684 2.269555 2.248783 sqlcipher: 6.213830 6.327371 6.381041 6.347419 6.371563 [IP:175.190.122.16发表于2022-11-09 20:09:21]

[41] 顶顶顶 [IP:175.190.122.16发表于2022-11-09 20:06:53]

[40] 15967800100渣男 [IP:125.111.12.65发表于2022-11-09 14:33:54]

[39] 17PLN ⇥loEsmLlTZscwh⇤ [IP:111.16.36.42发表于2022-10-29 13:14:04]

[38] 哈哈 [IP:113.201.132.246发表于2022-10-28 18:43:51]

[37] 哈哈 [IP:58.144.155.202发表于2022-10-28 00:21:57]

[36] 你好 [IP:58.144.156.43发表于2022-10-28 00:18:54]

[35] 232323 [IP:113.247.72.241发表于2022-10-26 15:30:36]

[34] https://airportal.cn/ [IP:223.74.207.175发表于2022-10-20 11:31:17]

[33] https://airportal.cn/ [IP:223.74.207.175发表于2022-10-20 11:31:04]

[32] 386321 [IP:223.74.207.175发表于2022-10-20 11:16:00]

[31] 到https://airportal.cn/,输入获得的6位数字取件码 [IP:223.74.207.175发表于2022-10-20 10:54:16]

[30] 我想死。没有人爱我。也没有人在乎我, [IP:117.173.24.134发表于2022-10-04 12:28:25]

[29] fsdfsdf [IP:61.185.187.59发表于2022-09-13 00:24:27]

[28] sdfdssssssssssssssfsdf [IP:61.185.187.59发表于2022-09-13 00:23:43]

[27] 撒旦发顺丰到付 [IP:61.185.187.59发表于2022-09-13 00:23:02]

[26] 1233-6 [IP:182.139.221.181发表于2022-08-22 05:56:40]

[25] 15967800100 [IP:39.185.202.230发表于2022-08-20 12:18:25]

[24] 123465789 [IP:114.219.105.30发表于2022-08-18 23:21:19]

[23] iOS二orz [IP:114.219.105.30发表于2022-08-18 23:12:23]

[22] dlkfjllkjlk [IP:223.74.116.158发表于2022-08-15 20:55:41]

[21] 给他哥哥 [IP:183.29.141.50发表于2022-08-04 12:54:50]

[20] asdf [IP:123.157.162.43发表于2022-08-03 21:42:00]

[19] test [IP:122.96.46.239发表于2022-07-28 23:20:47]

[18] 为各位各位个 [IP:202.105.66.170发表于2022-07-26 09:35:03]

上一页 1/1 下一页