AutoCAD Map 3D General Discussion

Reply
Distinguished Contributor
bingeomatics
Posts: 216
Registered: ‎04-29-2012
Message 1 of 7 (790 Views)

SDF or SQLite

790 Views, 6 Replies
09-19-2012 05:11 AM

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.....

Binnat Khalilov
Mentor
Robert_Fritz
Posts: 162
Registered: ‎12-08-2011
Message 2 of 7 (771 Views)

Re: SDF or SQLite

09-19-2012 11:19 PM in reply to: bingeomatics

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

http://raumpatrouille3d.blogspot.ch/
Distinguished Contributor
bingeomatics
Posts: 216
Registered: ‎04-29-2012
Message 3 of 7 (767 Views)

Re: SDF or SQLite

09-19-2012 11:50 PM in reply to: Robert_Fritz

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

Binnat Khalilov
Valued Mentor
jackie.ng
Posts: 273
Registered: ‎10-06-2008
Message 4 of 7 (742 Views)

Re: SDF or SQLite

09-20-2012 09:04 PM in reply to: bingeomatics

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

Distinguished Contributor
bingeomatics
Posts: 216
Registered: ‎04-29-2012
Message 5 of 7 (740 Views)

Re: SDF or SQLite

09-20-2012 09:24 PM in reply to: jackie.ng

Thanks, all !

Binnat Khalilov
Valued Mentor
jackie.ng
Posts: 273
Registered: ‎10-06-2008
Message 6 of 7 (737 Views)

Re: SDF or SQLite

09-20-2012 09:41 PM in reply to: bingeomatics

Correction:

 

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

 

:smileyhappy:

 

- Jackie

Distinguished Contributor
nkg2
Posts: 110
Registered: ‎11-20-2008
Message 7 of 7 (492 Views)

Re: SDF or SQLite

05-15-2013 12:15 PM in reply to: jackie.ng

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?

Autodesk 2015 Infrastructure Design Suite - Premium
Windows 7 Professional, x64, Intel Xeon W3350 3.07GHz, 12GB Ram, NVidia Quadro 4000

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community