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 _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
