Mongo Index Issue

[Sougata Pal.]

The following query returns result perfectly.

$author = 'Some Author';
$book_list = $var->MongoDB->DBCache->find(array(
  'value.specification.0.info.0.key'      =>  'author',
  'value.specification.0.info.0.value'    =>  $author,
))->sort(array(
  'created'    =>  -1,
))->limit(10);


Now if I create index on keys "value.specification.0.info.0.key" , "value.specification.0.info.0.value" the query returns no results.

But we must do index on those keys as we have 3M entries on collections, the query takes forever to execute without index. All the comparison are case sensitive & exact so we don't need regex for now.

Please help us, as this a immediate bottleneck to our application.

--
Thanks
Sougata Pal.
Chief Architect, Techunits
http://in.linkedin.com/in/skallpaul
Contact: +91 9051042886

[Kyle Banker]

This may be a server bug. I've created a case you can track:
https://jira.mongodb.org/browse/SERVER-3722

In the meantime, can you share your data model? I'm pretty sure that
there's a more efficient way of modeling the data and building the
index you want.

[Sougata Pal.]

Hello,

Thanks for your quick reply. I will track this bug for the any updates as this a urgent issue for us.

--
You received this message because you are subscribed to the Google Groups "mongodb-user" group.
To post to this group, send email to mongod...@googlegroups.com.
To unsubscribe from this group, send email to mongodb-user...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/mongodb-user?hl=en.

--
Thanks
Sougata Pal.

[Kyle Banker]

Great.

As I was saying, we can probably find a way around this if you can
share your data model.

[Tony Hannan]

It turns out this is a duplicate of SERVER-2902 which was fixed in 1.9.2. (2.0.0-rc)

[Sougata Pal.]

Thanks a lot for the info.

[Sougata Pal.]

Hello,

We have an serious issue after upgrading mongo 1.8.2(64bit) to 1.9.2(64bit). Mongo Indexes don't perform well as previous version. The CPU usage is abnormally high now after upgrade, but all the indexes are exactly same as previous.

Please let me know whether what should I do ?

[Kyle Banker]

The best thing you can do is to provide as many details as possible so
that we can reproduce the issue. Which indexes? Which queries?

On Sep 1, 10:11 am, "Sougata Pal." <skall.p...@gmail.com> wrote:
> Hello,
>

> We have an serious issue after upgrading mongo 1.8.2(64bit) to 1.9.2(64bit).
> Mongo Indexes don't perform well as previous version. The CPU usage is
> abnormally high now after upgrade, but all the indexes are exactly same as
> previous.
>
> Please let me know whether what should I do ?
>
>
>
>
>
>
>
>
>
> On Wed, Aug 31, 2011 at 11:04 AM, Sougata Pal. <skall.p...@gmail.com> wrote:
> > Thanks a lot for the info.
>

> > On Wed, Aug 31, 2011 at 12:08 AM, Tony Hannan <t...@10gen.com> wrote:
>
> >> It turns out this is a duplicate of SERVER-2902 which was fixed in 1.9.2.
> >> (2.0.0-rc)
>