Microsoft.AspNetCore.Mvc.Localization.LocalizedHtmlStringPErformance issue on windows server 2012 R2

PErformance issue on windows server 2012 R2

Printed from: Snitz™ Forums 2000
URL: https://forum.snitz.com/forumTopic/Posts/71216?pagenum=1
Printed on: 05 November 2025, 01:39

Topic

Author : s80ts0465
Subject : PErformance issue on windows server 2012 R2
Posted : 15 September 2017, 03:34
Message :

Hi, I upgraded the system form Windows 7 to Windows Server 2012 R2 64bit. Everything works, but I noticed a slower forum navigation and in same cases long wait to show pages. Could it be a ODBC connections issue? I still the same string of before...Provider=Microsoft.Jet.OLEDB.4.0

Is there any known issue with Windows server 2012 R2 64bit?
Ste

Replies ...

Reply Author: HuwR
Replied on: 15 September 2017, 06:23
Message:

There aren't any known issues, however you would probably get much better performance using SQL Express rather than an ACCESS database

Reply Author: s80ts0465
Replied on: 15 September 2017, 07:10
Message:

Thanks for the reply,
I was already thinking about to upgrade to MySQL o SQL Express, do you suggest SQL Express? is there any migration procedure?
anyway, before the upgrade everything was much faster, and the DB dimensions are similar

Reply Author: HuwR
Replied on: 15 September 2017, 13:05
Message:

since you are using a windows server, I would install sql express, Microsoft provide an app for migrating access to sql
https://docs.microsoft.com/en-us/sql/ssma/access/installing-sql-server-migration-assistant-for-access-accesstosql

Reply Author: s80ts0465
Replied on: 15 September 2017, 17:34
Message:

I found in the forum this procedure for migration access to sql https://forum.snitz.com/forumTopic/Posts/63884?pagenum=-1
what do I have to follow? this guide or simply use the tool you suggested?

Reply Author: HuwR
Replied on: 15 September 2017, 18:28
Message:

the tool is probably easier (it didn't exist back when that post was made) but following the steps in the post would also work

Reply Author: s80ts0465
Replied on: 17 September 2017, 06:16
Message:

Ok, tomorrow I'll try the tool, hope to not have problems with it and improve performance and avoid index issues.
After completed the migration, Hhve I to do something on the forum? apart to change the connection DB string?

Reply Author: HuwR
Replied on: 18 September 2017, 06:36
Message:

you may need to just load the setup.asp page to refresh everything (you won't need to run anything, just choose go back to forum if the page indicates everything is ok)

Reply Author: s80ts0465
Replied on: 18 September 2017, 07:21
Message:

some problems... after upgraded, entered to forum is requested to upgrade the DB

The database you are using needs to be upgraded !!
Code : 80040E09

, but after that the page is blank

I also tried to install a fresh database and the setup page reply with a good database creation, but after I come back to default.asp I have the blank page