Re: Query Optimization Needed
Hi Rick/Peter,
I am getting best results with index order (`deviceid`, `created_on`, `user_id`)
Row_returned are 167667 and total rows in table are 432301.
Yes we can increase some more memory for InnoDB Buffer Pool, but as I said earlier, MongoDB is also running with dataset around 3 GB on this server. so we can not allow a large buffer pool to InnoDB as recommandation (70% of available RAM).
Is there any suggestion to improve performance of this query?
Regards,
Devrishi
Subject
Views
Written By
Posted
1672
February 11, 2015 01:31AM
753
February 11, 2015 12:42PM
855
February 12, 2015 03:51AM
787
February 12, 2015 01:24PM
754
February 13, 2015 06:53AM
687
February 13, 2015 07:36AM
708
February 14, 2015 01:04AM
Re: Query Optimization Needed
781
February 15, 2015 11:07PM
798
February 16, 2015 12:15AM
659
March 13, 2015 11:15AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.