MongoDB::Indexing - Indexing collections
version 0.503.2
Unique and non-unique indexes can be created on collections using MongoDB::Collection::ensure_index.
MongoDB::Collection::ensure_index
For example, to create a non-unique index on x:
x
$collection->ensure_index({'x' => 1})
To create a unique index on y:
y
$collection->ensure_index({"y" => 1}, {"unique" => 1});
Multi-key indexes can be created to speed up queries like "sort by name, then by age." Index direction (1 or -1) is only important for multi-key indexes and should be the sort order. So, for example, if we want a fast sort by name ascending and age descending, we'd write:
my $idx = Tie::IxHash->new(name => 1, age => -1); $collection->ensure_index($idx);
Keep in mind that you should use Tie::IxHash for multi-key indexes to guarantee the keys will be saved in the correct order.
The second parameter to MongoDB::Collection::ensure_index specifies index options. Available options are:
unique => boolean
By default, indexes are not unique. To create a unique index, pass unique => true. true can be boolean::true or any other true value.
unique => true
true
drop_dups => boolean
If a unique index is being created on an existing set of data that has duplicate values, creating the index will fail. To force the index creation by deleting duplicate values, use this option. Again, any value that evaluates to true will work.
safe => boolean
If the update fails and safe is set, this function will return 0. You should check MongoDB::Database::last_error to find out why the update failed.
MongoDB::Database::last_error
background => boolean
Create the index as a background operation.
name => string
Give the index a non-default name. This can be useful if the index contains so many keys that you get an "index name too long" assertion, or if you just prefer a more human-readable name.
MongoDB documentation on indexing: http://dochub.mongodb.org/core/indexes.
Starting in version 1.3.3 of MongoDB, you can create geospatial indexes. These are useful for querying for "N documents nearest this point" or "documents within this shape."
To create an index for geospatial queries, use "2d" instead of 1 or -1. For example, this would create an index on the "location" field:
$coll->ensure_index({"location" => "2d"});
Then, you can query for documents using $near:
$near
my $cursor = $coll->query({"location" => {'$near' => [44, -70]}})->limit(10);
This finds the 10 nearest documents (automatically sorted by distance ascending) to latitude -70, longitude 44.
Documents must have some sort of pair in the "location" field, although the database is pretty flexible as to what it will accept:
# valid geospatial locations $coll->insert({"location" => [44, -70]}); $coll->insert({"location" => {"x" => 44, "y" => -70}}); $coll->insert({"location" => {"foo" => 44, "bar" => -70}});
You can save values in (x,y) or (y,x) order, but you must be consistent.
(x,y)
(y,x)
By default, the geospatial index assumes that points will lie between -180 and 180, for longitude and latitude queries.
min => int
By default, the geospatial index assumes that points will lie between -180 and 180, for longitude and latitude queries. If you need an alternative minimum value, you can use this option. This value is exclusive: if you specify min => 0, you cannot save a point with a 0 value coordinate.
min => 0
max => int
Alternative maximum value, exclusive.
MongoDB documentation on geospatial indexes: http://dochub.mongodb.org/core/geo.
Florian Ragwitz <rafl@debian.org>
Kristina Chodorow <kristina@mongodb.org>
Mike Friedman <mike.friedman@10gen.com>
This software is Copyright (c) 2012 by 10gen, Inc..
This is free software, licensed under:
The Apache License, Version 2.0, January 2004
To install MongoDB::Async, copy and paste the appropriate command in to your terminal.
cpanm
cpanm MongoDB::Async
CPAN shell
perl -MCPAN -e shell install MongoDB::Async
For more information on module installation, please visit the detailed CPAN module installation guide.