Performance of Multiple Joins

Posted by geeko on Stack Overflow See other posts from Stack Overflow or by geeko
Published on 2011-02-11T18:02:08Z Indexed on 2011/02/11 23:25 UTC
Read the original article Hit count: 255

Filed under:
|
|
|

Greetings Overflowers,

I need to query against objects with many/complex spacial conditions. In relational databases that is translated to many joins (possibly 10+). I'm new to this business and wondering whether to go with MS SQL Server 2008 R2 or Oracle 11g or document-based solutions such as RavenDB or simply go with some spacial database (GIS)...

Any thoughts ?

Regards

UPDATE: Thank you all for your answers. Would anybody opt for document/spatial databases ? My database would consist of tens of millions to few billion records. Mostly read-only. Almost no updates unless in case of mistakes in input. Overnight inserts and not that frequent. The join tables are predicted beforehand but the number of self joins (tables joining themselves multiple times) is not. Small pages of results from such queries are going to be viewed on an highly interactive website so response time is critical. Any predictions on how this can perform on MS SQL Server 2008 R2 or Oracle 11g ? I'm also concerned about boosting performance by adding more servers, which one scales better ? How about PostgresQL ?

© Stack Overflow or respective owner

Related posts about database

Related posts about Performance