[SERVER-9254] Read Performance Problem Created: 05/Apr/13  Updated: 10/Dec/14  Resolved: 10/Apr/13

Status: Closed
Project: Core Server
Component/s: Index Maintenance
Affects Version/s: 2.4.0-rc3, 2.4.0
Fix Version/s: None

Type: Question Priority: Critical - P2
Reporter: Srinivas Bikkina Assignee: Stennie Steneker (Inactive)
Resolution: Incomplete Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Windows 64 bit


Participants:

 Description   

I have installed MongoDB 2.4 On windows 64 bit with 16gb ram and 1 TeraByte Storage. I have a collection with 600 GB Size. This collection is fully read heavy and no writes. I created Indexes on Name and Address and City and Sate columns as separate indexes and compound index. I need to perform case insensitive and match searches. It is taking really long time. I tried with Full Text Index Also and No use. Can any one Help me out to how should i get good performance on reading. My searches always include name only and name and address or name and city like that



 Comments   
Comment by Stennie Steneker (Inactive) [ 10/Apr/13 ]

Hi Srinivas,

The SERVER project is for reporting bugs or feature suggestions for the MongoDB server.

For MongoDB-related support discussion you should post on the mongodb-users group (http://groups.google.com/group/mongodb-user) or Stack Overflow / ServerFault.

I can see you've already posted this on the mongodb-user group.

Thanks,
Stephen

Generated at Thu Feb 08 03:19:50 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.