SDF or SQLite

[Anonymous]

Hi, everyone.

I have one question. Whisch file type good to use in AutoCAD Map - SDF or SQLite? What kind of difference have between them?  Which distinctive feature? Which plus and minus characteristic both files? Thnaks, everyone, who can informed and advice me.....

[Anonymous]

Hi,

SDF is an Autodesk (only) file format and - as far as I know - not being used anywhere else. It has been around since introduction of FDO technology (or it's "predecessor "SDF2 even for longer).

SQLLite is a widely used database. Autodesk developed an FDO provider in order to support SQLLIte databases as well.

I do not have any reference to it but I remember to have heard that SQLLIte is faster than SDF files when used in Map/MapGuide.

Second advantage of SQLLIte - it is not just a file formabt but a database. There are many tools (commercial and free ones) which allow open SQLLIte databases, executing SQL queries against tables and so on. SQLLIte might also be supported in many programming language.

So, I suppose SQLLIte is the better choice,

Rob

[Anonymous]

Have any difference among them amount of information. How much GBytes they can contet? Do you know abut it?

[Anonymous]

Here's the limits of SQLite http://www.sqlite.org/limits.html

The numbers are astronomical enough that you should have to concern yourself about hitting such limits.

- Jackie

[Anonymous]

Thanks, all !

[Anonymous]

Correction:

The numbers are astronomical enough that you *should not* have to concern yourself about hitting such limits.

- Jackie

[nkg2]

My question is somewhat related but more so from the standpoint of bringing in conceptual data and base information from Infraworks to Map3d.  I am trying to figure out a good way to bring in my rasters and vector data without having to duplicate the process and also to translate the information to the correct coordinate system.  Infraworks would prefer that the default settings don't get changed but that does not work for my situation.  Regardless, I data connected to the sqlite file that is generated by Infraworks and clicked on the layers that should have been the information I needed (or thought I was going to get).  All I get are shape file tiles and even if I change the style to put a gradient on say min Z and max Z, all I do is change the tile colors.   So what then does the SQLite file do in that situation?