Tagged Questions
3
votes
5answers
489 views
Structuring database for multi-object “activity” and “following” functionalities
I am working on a web application which operate with different types of objects such as user, profiles, pages etc. All objects have unique object_id.
When objects interact it may produce "activity", ...
6
votes
1answer
209 views
How do I efficiently store all OpenStreetMap data in an indexed way?
I have a PBF file that contains the following information about a country:
Nodes, each with their own longitude, latitude and properties; used to store points in a 2D space.
Ways, each with their ...
3
votes
3answers
176 views
How to query a very long list of properties fast
I have a structure for storing item properties on SQL Server:
ItemId PropertyId Value
1 1 a
1 2 b
2 1 a
2 2 5
Currently there are over 130000 ...
