找回密码
 立即注册

QQ登录

只需一步,快速开始

wcld

中级会员

50

主题

133

帖子

509

积分

中级会员

积分
509

微信认证勋章

wcld
中级会员   /  发表于:2021-7-13 16:03  /   查看:2337  /  回复:5
使用签名插件和二维码生成插件
生成的 图片格式是 base64 存数据库里的字节一个图片要占用64KB左右

久而久之 感觉数据库要爆掉。。。。恐怖

下面是一张图片存数据库的字节数。。。

data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAKQAAACkCAYAAAAZtYVBAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAudSURBVHhe7ZJBai05EAT//S89sxVB0UGSki2MAmKVWaV6dv/77/G4iPdBPq7ifZCPq3gf5OMq3gf5uIr3QT6u4n2Qj6t4H+TjKt4H+biK90E+ruJ9kI+reB/k4yreB/m4ivdBPq7ifZCPq3gf5OMq6g/y379/PyrZnVPS5sT6u/PTttQbpqNOSnbnlLQ5sf7u/LQt9YbpqJOS3TklbU6svzs/bUu9YTrqpGR3TkmbE+vvzk/bUm/YfRBJ97PfmmLzaU5T2nlj9/56w+6DSLqf/dYUm09zmtLOG7v31xt2H0TS/ey3pth8mtOUdt7Yvb/esPsgku5nvzXF5tOcprTzxu799QY7iLlJ0tzczfTGTltsH3OTWJ5Sb7CDmJskzc3dTG/stMX2MTeJ5Sn1BjuIuUnS3NzN9MZOW2wfc5NYnlJvsIOYmyTNzd1Mb+y0xfYxN4nlKfUGO4i5SdLcJGlOU2ze8hTbx9wklqfUG+wg5iZJc5OkOU2xectTbB9zk1ieUm+wg5ibJM1NkuY0xeYtT7F9zE1ieUq9wQ5ibpI0N0ma0xSbtzzF9jE3ieUp9QY7iLlJ2pywT8nUSTSmmS9TbJ65SSxPqTfYQcxN0uaEfUqmTqIxzXyZYvPMTWJ5Sr3BDmJukjYn7FMydRKNaebLFJtnbhLLU+oNdhBzk7Q5YZ+SqZNoTDNfptg8c5NYnlJv2H0QafdznhLLCfuUTJ1V43Q/Zff+esPug0i7n/OUWE7Yp2TqrBqn+ym799cbdh9E2v2cp8Rywj4lU2fVON1P2b2/3rD7INLu5zwllhP2KZk6q8bpfsru/fUGHnRa8vIsP21LvWE66qTk5Vl+2pZ6w3TUScnLs/y0LfWG6aiTkpdn+Wlb+g2XY38wyw2bZ06NaWb1r/H3fhGwf6Dlhs0zp8Y0s/rX+Hu/CNg/0HLD5plTY5pZ/Wv8vV8E7B9ouWHzzKkxzaz+NepfNP2REg3rp3kqsZzs7jM3jWnmS2J5Sr2BB6Ua1k/zVGI52d1nbhrTzJfE8pR6Aw9KNayf5qnEcrK7z9w0ppkvieUp9QYelGpYP81TieVkd5+5aUwzXxLLU/oNoD2wnSe2j3lqSjqf9kk7T7iPtvQbQHtgO09sH/PUlHQ+7ZN2nnAfbek3gPbAdp7YPuapKel82iftPOE+2tJvAO2B7TyxfcxTU9L5tE/aecJ9tKXeMB2VaEwzq2TqNLZMO1dPY+8xN4nlKfUGHpRqTDOrZOo0tkw7V09j7zE3ieUp9QYelGpMM6tk6jS2TDtXT2PvMTeJ5Sn1Bh6Uakwzq2TqNLZMO1dPY+8xN4nlKfUGOyjNqTHNfNky7Vwlu3NqTDOrKe28UW+0A9OcGtPMly3TzlWyO6fGNLOa0s4b9UY7MM2pMc182TLtXCW7c2pMM6sp7bxRb7QD05wa08yXLdPOVbI7p8Y0s5rSzhvbN7YHc56SqfMlSXNKps4qSXNK0pz+NtsvaH8g5ymZOl+SNKdk6qySNKckzelvs/2C9gdynpKp8yVJc0qmzipJc0rSnP422y9ofyDnKZk6X5I0p2TqrJI0pyTN6W9z/ILpR6+SNjc4T4nlxPrMaUo7b3A/3c3+jWD6EaukzQ3OU2I5sT5zmtLOG9xPd7N/I5h+xCppc4PzlFhOrM+cprTzBvfT3ezfCKYfsUra3OA8JZYT6zOnKe28wf10N/XG6cjVlGnHqmH9NifsUzJ1Ekmat56mfmE6ejVl2rFqWL/NCfuUTJ1Ekuatp6lfmI5eTZl2rBrWb3PCPiVTJ5Gkeetp6hemo1dTph2rhvXbnLBPydRJJGneeprtL6Q/oO1To+1TMnW+NKaZVWOaWTXSfsv2F9If0Pap0fYpmTpfGtPMqjHNrBppv2X7C+kPaPvUaPuUTJ0vjWlm1ZhmVo2037L9hfQHtH1qtH1Kps6XxjSzakwzq0bab6lfaA+2eeYm2Z3Tlt37iO1n3tpSb2gPsnnmJtmd05bd+4jtZ97aUm9oD7J55ibZndOW3fuI7Wfe2lJvaA+yeeYm2Z3Tlt37iO1n3tpSb7CDLCfWb/OU0/tSydQ5KbE8pd5gB1lOrN/mKaf3pZKpc1JieUq9wQ6ynFi/zVNO70slU+ekxPKUeoMdZDmxfpunnN6XSqbOSYnlKfUGHpRKps5qSjrPPk2x+TYn7JukzVvqjTwwlUyd1ZR0nn2aYvNtTtg3SZu31Bt5YCqZOqsp6Tz7NMXm25ywb5I2b6k38sBUMnVWU9J59mmKzbc5Yd8kbd6yfyOwH2C5YfPMKZk6X5I0Py2ZOqsp7TzpNwh2sOWGzTOnZOp8SdL8tGTqrKa086TfINjBlhs2z5ySqfMlSfPTkqmzmtLOk36DYAdbbtg8c0qmzpckzU9Lps5qSjtP+g0h/AGpKek8+9SwPnPTSPsG99HTnH8BTD8yMSWdZ58a1mduGmnf4D56mvMvgOlHJqak8+xTw/rMTSPtG9xHT3P+BTD9yMSUdJ59alifuWmkfYP76Gm2v2A/wHKD85RYnpLu291nnmpMM4kt/QZgB1pucJ4Sy1PSfbv7zFONaSaxpd8A7EDLDc5TYnlKum93n3mqMc0ktvQbgB1oucF5SixPSfft7jNPNaaZxJZ+gzAdvWpMM6vE8hTuSzWmmS/J7pySqbPa0m8QpqNXjWlmlViewn2pxjTzJdmdUzJ1Vlv6DcJ09KoxzawSy1O4L9WYZr4ku3NKps5qS79BmI5eNaaZVWJ5CvelGtPMl2R3TsnUWW3pNwh2MHNKps4qmTqNJM1PSywn1re8Zf9GYD+AOSVTZ5VMnUaS5qcllhPrW96yfyOwH8CckqmzSqZOI0nz0xLLifUtb9m/EdgPYE7J1FklU6eRpPlpieXE+pa37N8I2h/A+VRiuZHOs28a08xJjbRv9BuE9mDOpxLLjXSefdOYZk5qpH2j3yC0B3M+lVhupPPsm8Y0c1Ij7Rv9BqE9mPOpxHIjnWffNKaZkxpp3+g3/DL8g6QSy1PSfeynpkw7vjzN+RcOM/3REonlKek+9lNTph1fnub8C4eZ/miJxPKUdB/7qSnTji9Pc/6Fw0x/tERieUq6j/3UlGnHl6epX5iOPqkxzaySNifsp5Kp8yU5ne+mfoEHn9aYZlZJmxP2U8nU+ZKczndTv8CDT2tMM6ukzQn7qWTqfElO57upX+DBpzWmmVXS5oT9VDJ1viSn893UL5w+ON3PPiVTZ5VYbnDeNNI+sXnLd1O/cPrgdD/7lEydVWK5wXnTSPvE5i3fTf3C6YPT/exTMnVWieUG500j7RObt3w39QunD073s0/J1FkllhucN420T2ze8t3UL9jBzE1iOWHfTDk9n+a32VJvsIOYm8Rywr6Zcno+zW+zpd5gBzE3ieWEfTPl9Hya32ZLvcEOYm4Sywn7Zsrp+TS/zZZ6gx3E3CQ/ndMW25fmdDfTG6unqV+wg5mb5Kdz2mL70pzuZnpj9TT1C3Ywc5P8dE5bbF+a091Mb6yepn7BDmZukp/OaYvtS3O6m+mN1dPUL9jBzE2S5pRMndXTTG+ukjQ3b6e+0H4wc5OkOSVTZ/U005urJM3N26kvtB/M3CRpTsnUWT3N9OYqSXPzduoL7QczN0maUzJ1Vk8zvblK0ty8nfrC0z/Y9p/ODZtPc0qmzmrKb8+TesPug4jtP50bNp/mlE1ZTfnif1ht0HEdt/OjdsPs0pmTqrKb89T+oNuw8itv90bth8mlMydVZTfnue1Bt40GlJmqeSqfNlS7ov7RPO09PUL0xHn5SkeSqZOl+2pPvSPuE8PU39wnT0SUmap5Kp82VLui/tE87T09QvTEeflKR5Kpk6X7ak+9I+4Tw9zfkXHo+A90E+ruJ9kI+reB/k4yreB/m4ivdBPq7ifZCPq3gf5OMq3gf5uIr3QT6u4n2Qj6t4H+TjKt4H+biK90E+ruJ9kI+reB/k4y

5 个回复

倒序浏览
building
注册会员   /  发表于:2021-7-13 16:48:14
沙发
是啊,我们使用了签名,使用了2个月。现在数据库都快要到2G了
回复 使用道具 举报
wcld
中级会员   /  发表于:2021-7-13 17:56:07
板凳
building 发表于 2021-7-13 16:48
是啊,我们使用了签名,使用了2个月。现在数据库都快要到2G了

666
我研究下 怎么把 base64 上传到 图片空间里 7牛
回复 使用道具 举报
olookok活字格认证
论坛元老   /  发表于:2021-7-13 18:10:57
地板
图片肯定占用很多数据库资源。
回复 使用道具 举报
紫色幽魂
金牌服务用户   /  发表于:2021-7-14 08:28:18
5#
我的系统中也使用签名,占用量特别大,光签名就每天增加几十M,非常苦恼,希望能有其他方法能解决
回复 使用道具 举报
137294886
金牌服务用户   /  发表于:2021-8-26 01:20:36
6#
学习了
回复 使用道具 举报
您需要登录后才可以回帖 登录 | 立即注册
返回顶部