wonderful, Ozair ~ happy to help
have an awesome day,
crystal
Thank you very much Bill & Crystal.
It helped improving speed.
Ozair.PREVIOUS POSTS:
good catch, Bill. I have heard that the Native Client driver is exponentially faster. Ozair, even if there is bad design you should see a big improvement by changing this one thing
~crystal
On 4/13/18 9:49 AM, wrmosca@comcast.net [MS_Access_Professionals] wrote:One thing that should speed things up is to change your SQL driver to:
"ODBC;DRIVER=SQL Server Native Client 11.0
The Native Client might have to be installed on the users' PC. That is a simple task and well worth the time. The Native Client takes advantage of all the new features of SQL Server and has a much higher performance level.
Regards,Bill Mosca, Founder - MS_Access_ProfessionalsMy nothing-to-do-with-Access blog
---In MS_Access_Professionals@yahoogroups.com, <ozairkhalid@hotmail.com> wrote :
Hello all,
Many years ago I created "Updater1" (a tool/form) that updates a large number of records.
It takes 1 minute and 25 seconds to complete its processes.
It can of course be optimized but I never had time to do it.
In attempts to improve overall speed of the application, we recently upgraded hardware/software.
OLD
===
Front End MS Access Office 2003 with SP3 (32bit)
Back End MS SQL 2012
Windows 2008 R2 (64bit)
Intel Zeon E345 @233Ghz (2 processors) with 32Gb RAM
Tables linked using this connection string
"DRIVER=SQL Server;SERVER=MyServer;Trusted_Connection=Yes;APP=Microsoft Office 2003;WSID=RDP1;DATABASE=MyDB;Network=DBMSSOCN"
NEW
===
Front End MS Access Office 2003 with SP3 (32bit)
-ALSO- tried Front End MS Access Office 2013 (64bit) by creating an ACCDE file
"Updater1" takes 2 Minutes 10 Seconds to complete its processes - 50 seconds slower.
Back End MS SQL 2012
Windows 2012 R2 (64bit)
Intel Zeon E7 4860 @2.27Ghz with 50Gb RAM
Tables linked using this connection string
"ODBC;DRIVER=SQL Server;SERVER=Server_IP_Address,1466;Trusted_Connection=Yes;APP=Microsoft Office 2013;WSID=MyPC;DATABASE=MyDB;Network=DBMSSOCN"
Users connect to SERVERS using Windows Remote Desktop Services i.e. "MSTSC.EXE"
Any ideas how to improve performance/speed.
#1 is to make it at least the same as the old servers.
#2 is to make it reasonably faster than the old servers. << Ideal situation.
Thanks.
Ozair
Posted by: crystal 8 <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (7) |
Tidak ada komentar:
Posting Komentar