Harry, I've switched the connection string to the SQL CLient equivalent and it's working fine. I will try to move this thread to the correct section. I accidentally posted it in the V8 section of the forum. mofcomp 'programfiles (x86)Microsoft SQL ServernumberSharedsqlmgmproviderxpsp2up.mof'. I believe the dedicated server SQL server database will solve the speed issues. So, in order to fix the issue, you can open an elevated command prompt (Run as Administrator) and execute the below command, after of course you replace number with the version of SQL Server in terms of number. Leason learned from now on I go for the SQL database by default.Ĭoncerning your question about the backend vs frontend speed the slowness was mainly in the backend as well as the media load times on the frontend. It's definitely faster than the CE database. I've have used the VS extension 'SqlCeTolbox' () to convert my CE database to an SQL Express database and Umbraco is running fine locally. It turns out that the LocalDB option is not good for the server since it's not a service but rather a developer mode service. Also, remove the preceding or following semicolon ( ). Remove 'User InstanceTrue' if it is present. This change assumes that you installed LocalDB with the default instance name. After doing some more research, I ended up on this StackOverflow page: To convert one of SQL server express connection strings to LocalDB, make the following changes: Change 'Data Source.\SQLEXPRESS' to 'Data Source (LocalDB\v11.0)'.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |