SQL Lite vs SQL Server

[TRdesigner82]

I'm currently involved in a project that is pretty big. We have Revit models for the building structures along with a long list of dwgs all Xref'd into our working files. We have about 5 designers modeling piping and equipment and we have the drawings broken up enough that we can all work together without stepping on each other's toes. My question is, at what point should we consider switching t SQL Server instead of SQL Lite? I've notice an increase in load time for tool palettes, switching drawings, the program crashes from time to time, etc......  I'm just wondering if these are issues because we're still on SQL Lite? I've attached a screen shot for a reference to the size of job. We've barely started adding pipe at this point so I'd assume the current issues are only going to get worse...

[aldevos]

Hello,

I recommend you to migrate to SQL Server ASAP !!

You had many many problems with SQL Lite (data corruption, project not accessible to some users because "locked" by ohters, ...) during 3 months until we migrate to SQL Server. Since we migrate we had a lot less problems.

On our project, we have 8 people working with Plant 3D.

Regards,

Alexandre Devos

[quentin.contreras]

Here is a list comparision that might help with you decision to switch from SQLite to SQL Server.

SQLite versus Microsoft SQL Server

SQLite
• Fast, Reliable, for Free
• Many read, write ones
• Doesn’t use a Server process
• No writing to views
• Local/client user SQL storage
• Non-Scalable
• No sync with other SQL DBases
• Integrated with software

SQL SERVER
• Faster, Reliable, unbelievable Stable
• Many read, many write
• Uses seperate Server process, easy control
• Easy to create views
• Peer-to-Peer database synchronisation
• Scalable, from one to many users
• Seperate process, so able to communicate with
multiple software solutions
• User rights, user access
• Full Text search capabilities

[TRdesigner82]

With the current scale of our job and more pipers to come, would you think it would benifit us to upgrade at this point? Would it help with crashes and drawing load time? Would it help with Ortho drawing creation speed?(took me 45 min to create a plan view of one of our building. No pipe was included but will be in the future...)

[quentin.contreras · Accepted solution]

Yes, it will help. Additionally, are you using correct workflows in managing your large projects? There are help documents located in the Plant Exchange website that you should refer to if you have not done so already. Here is the link:

http://autocad.autodesk.com/?nd=whitepapers

[TRdesigner82]

I've looked at the "How to Manage Large Projects" in the Whitepapers and I beilve we're follow it as closely as possible considering the job we have at hand. Thanks for your help...