Hello i have a mongo db
db name: Quicklook_db
Collection name: quicklook_analyticsDesign
Total Documents in collection: 2,00,000 +
Sample json attached.
From all the documents i want to find the most used 10 values in this attribute: $[login to view URL]
I tried this code:
$analytics = DB::connection('mongodb')->collection($this->designViewed)->raw(function($views) use ($dateto, $datefrom) {
return $views->aggregate(array(
array('$group' => array('_id' => ['store_id' => '$[login to view URL]'],
'total' => array('$push' => '$[login to view URL]'))),
), ['allowDiskUse' => true]);
});
//suspect
$analytics_arr = [];
foreach ($analytics as $a) {
$analytics_arr[$a->_id->store_id] = get_tiles_from_plane_union($a->total);
unset($a);
}
$new_analytics_arr = [];
foreach ($analytics_arr as $key => $pch) {
if (empty($new_analytics_arr[$entities_arr[$key]['name']])) {
$new_analytics_arr[$entities_arr[$key]['name']] = $pch;
} else {
$new_analytics_arr[$entities_arr[$key]['name']] = custom_array_merge($new_analytics_arr[$entities_arr[$key]['name']], $pch);
}
}
$analytics_arr = $new_analytics_arr;
dd($analytics_arr);
But gives document size error 14 MB exceeded.
Greetings! I am placing the current avarage price now and we can discuss it later. I am available to start work immediately and will be glad to discuss further details via chat if you still search for someone. Have over 10 years of experience as Web Expert and exstensive knowledge in nosql couch & mongo, mysql, amazon web services, elasticsearch, mongodb. Best Regards! Toma :)
I am writing this proposal in order to work for you in Software and Web Development. We are highly trained professional developers seeking to freelance and earn online.
Having a flair in programming and development I have been excellent with JAVA,C#,C/C++ and PHP programming language along with MySQL with XAMPP Server. I also build application for Cloud computing and High performance computing as I also have knowledge regarding Hadoop, MPI, OpenMP (distributed frameworks) and also have build applications in CUDA C++ and OpenCL. I also have experience with the most famous framework ASP.NET. My most expertise are in JAVA where I have built countless projects for semester projects and Final year project.
You may find many developers in this field however we assure that you will not be able to find a team like us. We not only ensure the code is quality wise but we also assure that the code we write are optimised and we ensure that the program performs right operation under right environment i.e. we create programs that are defect free. You may also find freelancers that cost low but they do not put their 100% which then shows in the software and leads to an unhappy customer. We ensure reasonable price are put as tag on the job and we ensure in order to give the write product.
We highly appreciate your time, if you are interested kindly let me know
Hi, I have more than 14 years in Java JEE and 4 years of experience in Mongo db.
I have implemented complex mongo queries , used GridFs to solve 16mb document limitation etc.
Please contact me if you are interested to proceed with me.