Q&A - Question

If you use Delphi, then you can connect via FireDAC. But I'm not sure if the database supports blob or clob data types to store the geometry.

Thank you about the reply.

I am using .Net framework.

I've saw in mongo db docs, there are a solution to generate geometry data. There are the functions to geometry relate and stuff like that.

Maybe it's a good way to improve the render performance. The mongo db performance is great.

Mongodb looks nice but for GIS it has only basic support like geojson geometry type, near spatial index that is enough for web but won't be fast for desktop.

Yeah, I got it.

Our desktop solution, after some years learning, using different databases, we implemented a good data managing to improve rendering performance.

Basically, we use Oracle to store our whole spatial data and a sqlite database (each desktop has one) where the GIS viewer use to render. The application queries the oracle database to keep the sqlite updated.
Tha map became very fast.

We started our ASP.NET solution and so far, we are using Oracle to connect the viewer to render. The performance is much slower. We know that just connecting directly to Oracle contributes to slowing down.

About your experience, what is the best database or set of databases to use in ASP.Net technology for better performance?

What can I say if you use ASP.NET - MS SQL with spatial support.

I'll make the tests and I'll post the results here.

Thank you Artur Redzko.