My problem is the following: I have two arrays $first and $second of the same length, containing strings. Every string is given a positive value in a table named Fullhandvalues:

我的问题如下:我有两个数组$ first和$ second相同的长度,包含字符串。在名为Fullhandvalues的表中,每个字符串都给出一个正值:

Field: board : string(7) PRIMARY KEY
Field: value : int (11)

I want to count how many times $first[$i] has a better value than $second[$i], how many times they have the same value, and how many times $first[$i] has a worse value than $second[$i].

我想计算$ first [$ i]有多少次价值比$ $ [$ i]更好,有多少次它们具有相同价值,以及$ first [$ i]有多少次价值比$ $更差第二[$ i]中。

What I have done now is getting all the values via

我现在所做的就是获得所有价值

$values[0]= DB::table('Fullhandvalues')->where_in("board",$first)->get(Array("value"));
$values[1]= DB::table('Fullhandvalues')->where_in("board",$second)->get(Array("value"));

and then comparing the values. But this seems to be very slow (approximately 6 seconds, for an array length of 5000 and 50000 entries in the table)

然后比较这些值。但这似乎非常慢(大约6秒,表中的数组长度为5000和50000个条目)

Thanks very much in advance

首先十分感谢

EDIT: How I loop through them:

编辑:我如何循环它们:

$win=0;$lose=0;$tie=0;
for($i=0;$i<count($values[0]);$i++)
    {
        if ($values[0][$i]>$values[1][$i])
            $win++;
        elseif ($values[0][$i]<$values[1][$i])
            $lose++;
        else $tie++;
    }

1 个解决方案