I have documents which store the lat/long cooridnates, timestamp, and a little bit of metadata. I have ran into a problem where I need to start to shard now. The only operation I run on these documents is I run a nearest search which return all the documents within 1km of a point I specify, and orders by newest. Since Geospatial data can't be sharded in MongoDB, what is the most efficient way to shard this data?
mongodb shard geo documents
178 Views Asked by user2924127 At
1
There are 1 best solutions below
Related Questions in MONGODB
- MongoDb not connecting C#
- How do I link two models in mongoose?
- MERN Stack App - User Avatar Upload - 500 Error After Deployment on Render
- On the server side, it returns undefined but on the client side, logs the values no problem
- Laravel: Using belongsToMany relationship with MongoDB
- What are some MERN projects that will grow me from junior dev to senior
- Save Interface in DB golang
- findOneAndUpdate not updating value in mongodb?
- Get Type Error when using .countDocuments with mongoDB
- Getting a Large Error Output When Calling MongoDB/Mongoose Functions Without an Error Message
- How to enter data in mongodb array at specific position such that if there is only 2 data in array and I want to insert at 5, then rest data is null
- using Python to insert_one to my mongo_db, How do I pass key values into a function?
- SSL Certificate Verification Error When Scraping Website and Inserting Data into MongoDB
- connect ECONNREFUSED 43.205.72.30:27017 while connecting to Atlas
- Vite is probably changing my import path. What should I do?
Related Questions in SCALE
- I need an azure product that executes my intensive ffmpeg command then dies, and i only get charged for the delta. Any Tips?
- Merge Azure mp4 blobs via API (Preferred Azure)
- Colorbar and contour plot seem to not match data; individual/custom scale to emphasize data of interest
- Weight measurement with real-time time stamping using the Kern KB 3600-2N precision balance
- Highcharts Spider Chart with different scale for each category
- GKE cluster shutdown
- Prevent blocking the event loop on sync operations
- How to keep original x-axis after utilizing a custom scaling for the geom_rect in ggplot?
- ESP32 attachInterrupt causing (Interrupt wdt timeout on CPU1)
- How to fix SVG being cut off when using as background?
- How to move the background image by clicking and dragging the mouse smoothly?
- How to use pyplot to show data with no scale on xaxis and allow to pan (shift) via mouse
- Page scales down on mobile when width is below 980px
- signalr - programatically scaling up (from azure function)
- Getting scale offset inside tkinter canvas
Related Questions in GEOSPATIAL
- Estimating distance between points and its relative elevation for multiple countries and geometries, using R sf
- Folium Timestampedgeojson - How to add dynamic html for the title of the map
- Convert lat,lon,data points to matrix (2D grid) at 0.5 degree resolution in Python
- Having trouble merging these two datasets for a Spatial Analysis
- How to extract vineyard land cover from CORINE in R?
- find point in inside polygon ..with mysql
- map distance in pixels to meters
- Efficiently Turn Matrix of Intersecting Routes Into Simplified Spatial Network (Graph)
- Oracle SDO_INTERSECTION returning null where an intersection exists in SRID 4326
- Plotting data on shapefile with the same CRS, but things are not lining up as I would expect
- get the band with the maximum value from a xarray stack
- Can spatial features be used as an input for a machine learning model?
- Make SpatRaster from sf point object
- Apache Sedona Version Issues
- MemoryError: Unable to allocate 19.1 GiB for an array with shape (52199, 49069) and data type int64
Related Questions in SHARDING
- Problems encountered when using _shard_num when querying clickhouse shard sets
- Horizontal scaling strategy with 10,000 shards
- MongoDB movePrimary doesn't work when the primary shard is down
- Assigning a dedicated Primary node for write operations in MongoDB replica set
- Why does Elastic search limit the maximum shard number to 1k per node?
- citus add node --> "fe_sendauth: no password supplied" error
- MongoDB Shard Cluster
- How to select the shard key
- When querying a sharded collection, can I filter on shard keys using an operator?
- How to specify region for shards in MongoDB Atlas. Also how to appropriately set 2 shard for a cluster
- akka.cluster.ddata.Replicator$Internal$DeltaPropagation message from clusterReceptionist replicator is dropped because it exceeds the size limit
- Make shard processes use the same pool
- discord.js v14: how to see the number of pending messages in shards
- Total number of docs on a shard in solr
- sharding-jdbc Forced routing failed
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Would recommend including two separate fields in your collection that store the longitude and latitude separately and use those keys to create a compound key which you can then use as a shard key. For example: