dongtiandexue123456 2017-06-09 15:32
浏览 129
已采纳

有没有选项可以使用php快速将mongoDB游标转换为数组

I have got a problem with converting MongoDb cursor to array using PHP. I have 40 000 rows and it takes about 40 seconds to convert it but only 19 miliseconds to get it from mongo. Is there any option to make it faster?

I tried Cursor->getArray and iterator_to_array and it take huge amount of time to complete it. My data in MongoDb has got maximum four nestings, do You think that reducing the nesting could reduce converting time ?

Thank You in advance!

  • 写回答

1条回答 默认 最新

  • dongyan5706 2017-06-12 01:09
    关注

    Copying and reifying 40,000 rows into a PHP array takes a lot of memory and time. You should refactor your code to not use arrays, but the provided 'cursor' iterator if possible.

    The iterator will iterate over each of the documents in a collection that match the query (arguments to find()). Each document is brought in similar to the way a json object is (bson, Mongo's storage format, being inspired by json), which is an PHP array.

    If you wanted to access an internal array in the document for each document matched.

    $cursor = $collection->find();
    foreach ($cursor as $doc) {
         echo $doc["inner_array"] . "
    ";
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥85 maple软件,solve求反函数,出现rootof怎么办?
  • ¥15 求chat4.0解答一道线性规划题,用lingo编程运行,第一问要求写出数学模型和lingo语言编程模型,第二问第三问解答就行,我的ddl要到了谁来求了
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题