PHP driver MongoDB integer problem bug and Strategy _php tutorial

Source: Internet
Author: User
The integer problem described in this article is not a problem with MongoDB, but rather a php-driven problem: MongoDB itself has two integer types: 32-bit integers and 64-bit integers, but older PHP drivers, regardless of whether the operating system is 32-bit or 64-bit, treat all integers as 32-bit integers , resulting in a 64-bit integer being truncated. In order to solve this problem with the same compatibility as possible, the new PHP driver added the Mongo.native-long option to handle integers as 64 bits in 64-bit operating systems, with an interest to refer to: 64-bit integers in MongoDB.

So does the PHP driver really solve the problem of integers? no! also has a bug when dealing with group operations:

To illustrate the problem, let's start by generating some test data:

Ini_set (' Mongo.native_long ', 1);

$instance = new Mongo ();

$instance = $instance->selectcollection (' Test ', ' test ');

for ($i = 0; $i < $i + +) {

$instance->insert (Array (

' group_id ' = rand (1, 5),

' Count ' = rand (1, 5),

));

}

?>

Let's use the group operation to summarize the count based on the group_id grouping:

Ini_set (' Mongo.native_long ', 1);

$instance = new Mongo ();

$instance = $instance->selectcollection (' Test ', ' test ');

$keys = Array (' group_id ' = 1);

$initial = Array (' count ' = 0);

$reduce = '

function (obj, prev) {

Prev.count + = Obj.count;

}

';

$result = $instance->group ($keys, $initial, $reduce);

Var_dump ($result);

?>

The result is not the same as expected, count does not implement accumulation, but instead becomes an [object object], and currently, if you must use group operations, there are two ways to mitigate this problem:

Ini_set (' Mongo.native_long ', 0);

$initial = Array (' count ' = = (float) 0);

Both of these methods are a temporary solution to the problem, since the current PHP driver implementation of the group is problematic, then we bypass it, in other ways to achieve the same function, this way is MapReduce:

Ini_set (' Mongo.native_long ', 1);

$instance = new Mongo ();

$instance = $instance->selectdb (' Test ');

$map = '

function () {

Emit (this.group_id, this.count);

}

';

$reduce = '

function (key, values) {

var sum = 0;

For (Var, index in values) {

Sum + = Values[index];

}

return sum;

}

';

$result = $instance->command (Array (

' MapReduce ' = ' test ',

' Map ' = $map,

' Reduce ' = $reduce

));

$result = Iterator_to_array ($instance->{$result [' Result ']}->find ());

Var_dump ($result);

?>

It takes three steps to put an elephant in the freezer, and using mapreduce requires only a map and reduce two steps, and here's a PDF document that vividly illustrates the correspondence between group by and MongoDB in MySQL:

http://www.bkjia.com/PHPjc/814346.html www.bkjia.com true http://www.bkjia.com/PHPjc/814346.html techarticle the integer problem mentioned in this article is not a problem of MongoDB, but a php-driven problem: MongoDB itself has two types of integers, namely: 32-bit integers and 64-bit integers, but the old version of ...

  • Related Article

    Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.