Question

我有一个具有变量的Rubyh:

a two-element array of strings
an integer

我尝试了以下两种方式,将散射线元素插入3银:

myRubyHash.each do |k, v|
   x=[k[0],k[1],v] 
   db.execute "INSERT INTO MyTable VALUES ( ?, ?, ? )", x
end

而且,

myRubyHash.each do |x|
   db.execute "INSERT INTO MyTable VALUES ( ?, ?, ? )", x
end

第一个速度大大加快(但依然相当缓慢)。是否有更快的途径来做到这一点?

如果能够帮助,我的三个桌子就是:

rows = db.execute <<-SQL
  CREATE TABLE Assoc_words_p (
    name1 varchar(30),
    name2 varchar(30),
    val int,
    PRIMARY KEY (name1,name2)
  );
SQL

增编

Answer 1

我发现,准备声明如下:

stmnt1 = db.prepare( "INSERT INTO Table(name1,name2,val) VALUES (?, ?, ?)" )
myRubyHash.each do |k, v|
    stmnt1.execute(k[0],k[1],v/2)
end

Answer 2

Sadly, Hash#each is just not a fast method, and I expect that s what s causing the performance concerns. The first thing that comes to mind in terms of performance is wondering why there s a hash there at all - it seems like the faster way to go would be to put your data into the database directly and skip the hash altogether.

友情链接