[OSM-dev] Lean and mean Tile- and XML-API-Server

[Stefan de Konink]

Matt Amos wrote:
>> C/C++ is not a prototype language.
> 
> do you mean http://en.wikipedia.org/wiki/Prototype-based_programming ?

No I mean a language where you start scripting and others have no clue 
what you are doing until it finished and it works. Other words; 
Proof-of-Concept. Low level languages are not good for this, too much 
distractions with memory management etc., but once you know exactly what 
you want. Don't waste your time on a language that does 90% for you 
sadly has no compiler to native machine code.


>>> how did you optimise it? (other than converting ways to relations)?
>> Not using MySQL, but MonetDB. It uses column based storage.
> 
> interesting. the web site describes it as an in-memory database, but i
> assume it can store to disk as well. so why is everyone still using
> mysql / postgres / oracle?

I know some pretty big Dutch banking/insurance organisations are using 
an ancient version of it, that was tailor made and tested specifically 
on their applications. There are some datawarehouses that use it. Plus 
this database implements SQL92 by the letter, no funny extensions. So we 
can call it; nobody knows, no body is using it.

>> Jup, but extra mathematical overhead in query generation that should not be
>> forgotten. Every output has to be atoi -> double back. And in the case of
>> storing doubles/floats the input can directly be passed to the user. I need
>> to figure out if the overhead of data translation is not bigger than
>> querying speed.
> 
> to be fair, the latency between here and the states is about 150ms, so
> you may not need to optimise further.

You miss the point of concurrent usage every performance improvement 
will allow more users to be served simultaneously.


Stefan