Question

我正试图利用Sqlite(sqlite3)进行一个项目,储存数十万记录(如像qlite那样,方案t的用户不必经营一个[米]sql服务器)。

我必须更新数以万计的记录,以便有时输入左上正确的价值(等级),但已经找到标准。

update table set left_value = 4, right_value = 5 where id = 12340;

速度非常缓慢。我每千人就座。

begin;
....
update...
update table set left_value = 4, right_value = 5 where id = 12340;
update...
....
commit;

然而,情况再次非常缓慢。 Odd,因为当我用数十万人(带上插头)居住时,就在第二位。

在我转向C++执行之前,我目前正在尝试测试猪的速度(速度缓慢在指挥线和on上),但现在,这是缓慢的,我需要找到新的解决办法,除非我做错的话。想法? (可能采取开放源替代可运输的QQ)

Answer 1

建立<代码>表>id索引

create index table_id_index on table(id)

Answer 2

除了确保你具备一个指数外,还可以检查。

如果你提到,利用交易可使你更快地提高速度,而且你也可以设法取消新闻报道。

例1:

2.2 PRAGMA 同步

The Boolean synchronous value controls whether or not the library will wait for disk writes to be fully written to disk before continuing. This setting can be different from the default_synchronous value loaded from the database. In typical use the library may spend a lot of time just waiting on the file system. Setting "PRAGMA synchronous=OFF" can make a major speed difference.

例2:

2.3 PRAGMA = 变化

When the count_changes setting is ON, the callback function is invoked once for each DELETE, INSERT, or UPDATE operation. The argument is the number of rows that were changed. If you don t use this feature, there is a small speed increase from turning this off.

友情链接