SQL CE插入性能 [英] SQL CE Insert Perfomance

问题描述

我正在尝试在移动应用程序中插入大小为1 mb的a.wav文件.
但是插入数据要花费很长时间，大约需要1分钟.

I was trying to insert a.wav file of size 1 mb in my mobile application
But it takes a long time to insert into the databe ,about 1 min.
How can I improve the sql Ce insert perfomance??

推荐答案

Hai Hiren，
您能否建议我一些有用的链接来通过基表游标方法执行插入.
.
预先感谢.

Hai Hiren,
can u suggest me some useful links to perform the insertion through the base table cursor method.
.
Thanks in advance.

即使使用参数化的
，通过SQL语句插入的速度也很慢. 和准备好的声明.在SQL CE 2.0中插入记录的最快方法是
通过基本表游标，该选项在.NET中不可用
CF.我正在向SQL CE 2.0的OLE DB接口编写托管包装器
并且已经设法在iPAQ 3850上对这两种方法进行了基准测试.基准
表方法可以比准备和参数化的方法快5倍
SQL INSERT语句.
CF 2.0将不会出现此问题，因为它公开了基表游标
通过SqlCeResultSet类.

如果有帮助，请 投票 和 接受答案 .

Inserting through a SQL statement is slow even if you use a parameterized
and prepared statement. The fastest way to insert records in SQL CE 2.0 is
through the base table cursor, an option that is not available through .NET
CF. I am writing a managed wrapper to the OLE DB interfaces of SQL CE 2.0
and already managed to benchmark both approaches on an iPAQ 3850. The base
table approach can be up to 5 times faster than a prepared and parameterized
SQL INSERT statement.
This will be a non-issue with CF 2.0 as it exposes the base table cursor
through the SqlCeResultSet class.

Please vote and Accept Answer if it Helped.

这篇关于SQL CE插入性能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！