search

OrchardCMS / Orchard

Orchard is a free, open source, community-focused Content Management System built on the ASP.NET MVC platform.
https://orchardproject.net
BSD 3-Clause "New" or "Revised" License
2.37k stars 1.12k forks source link

PERF: SQL CE performance #760

Open orchardbot opened 13 years ago

orchardbot commented 13 years ago

rpaquay created: https://orchard.codeplex.com/workitem/16928

Investigate if keeping a global connection open (and unused) to the SQLCE database file makes opening connections faster when processing requests.

orchardbot commented 13 years ago

@sebastienros commented:

Connections should be open/closed as needed and the internal pooling mecanism do it's work. If more performance is needed the solution to that is to use SqlServer.

orchardbot commented 13 years ago

@bleroy commented:

Sebastien: apparently you don't have all the context here. Renaud knows what this is about.

Also, investigate potential issues with the file being locked, which could impair ability to back up the site.