关于数据库连续更新BLOB字段的问题 [英] On the continuous updating the database BLOB field problem

问题描述

:confused:
我最近遇到一个ADO.NET开发项目，需要将大量实时数据存储到数据库BLOB字段中，每天形成一条记录，每天的数据记录容量约为200M，将实时数据插入到数据结束时，如果进行File操作，只需追加到文件末尾即可，但是我看不到数据库操作具有类似功能，因此，每次执行存储时，我必须读出当前记录，然后添加数据，然后进行UPDATE，因为我每天要进行数百次操作更新，并且随着数据量的增加，系统内存的开销也更大，更麻烦的是每次UPDATE时，数据库都会形成大量的空间浪费，每天压缩数据库，否则数据库每天会增加1G的空间，不知道如果遇到类似的朋友问题，没有好的解决方法，请多指教！

我的开发数据库:ACCESS(也可以使用SQL SERVER)
开发语言:C#ADO.NET
开发工具:VS2008

:confused:
I recently encountered an ADO.NET development projects, require a large amount of real-time data storage to a database BLOB field, forming a record every day, each day of data recording capacity of about 200M, real-time data to insert into the data the end, if File operation, just Append to the end of the file can be, but I do not see the database operation similar functions, so, every time I carry out storage I must read out the current record, then add data , then UPDATE, as I update every day to hundreds of operations, and with the amount of data increases, the cost of system memory is also larger, more troublesome is that each UPDATE, the database will form a large number of waste of space, to compress the database every day, otherwise the database will increase a space every day by 1G, do not know if friends come across a similar problem, there is no good solution, please enlighten me!

My development database: ACCESS (can also use SQL SERVER)
Development language: C # ADO.NET
Development Tools: VS2008

推荐答案

不能在此工具中访问.您应该使用SQL Server

http://msdn.microsoft.com/en-us/library/cc949109(SQL .100).aspx [ ^ ]

Access in NOT the tool for this. You should be using SQL Server

http://msdn.microsoft.com/en-us/library/cc949109(SQL.100).aspx[^]

这篇关于关于数据库连续更新BLOB字段的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！