Running back end access on Nas 1

• Dec 4, 2019

• #2

strongm

MIS

May 24, 2001

20,264

GB

What NAS? What specs? How many disks? What configuration? How is it connected? 1Gb? Through a 1 Gb capable switch? Are both the NAS and the PC physically wired to the same switch?

 

Upvote 0 Downvote

• Dec 4, 2019

• Thread starter
• #3

Moss100

Technical User

Aug 10, 2004

586

GB

Hi Strongm, thanks for your time.

Synology 718+
2 x 256gb Samsung SSD
1Gb wired connection
1Gb switch (both nas and PC on same wired network)

Previously it was hosted on a PC and it ran considerably faster.

Thanks Mark

 

Upvote 0 Downvote

• Dec 4, 2019

1
• #4

strongm

MIS

May 24, 2001

20,264

GB

Ah, well we don't really get a NAS for speed, I'm afraid (despite manufacturer claims that they are 'speedy' and can stream 4K

Even running over 1Gb ethernet, a NAS tops out at about 130Mbs (and with other overheads this is more realistically a max of about 110Mbs). A modern local HDD can do about 200Mbs, and a fast SSD about 500Mbs. So you can see that local storage will outperform your NAS (oh, and that you are not getting the full benefits of the SSDs in the NAS). You'd need to bump up to 10Gb ethernet ...

 

Upvote 0 Downvote

• Dec 5, 2019

• Thread starter
• #5

Moss100

Technical User

Aug 10, 2004

586

GB

Thanks for the input.

I have discovered that on the synology, turning opportunistic locking (on the nas) to On had doubled the speed with Access databases. Thats has been a big help. (it rather surprised me as Synology state that turning this Off will improve performance with databases??

Anyway, hopefully this may help someone else. Thanks Mark

 

Upvote 0 Downvote

• Dec 6, 2019

• #6

strongm

MIS

May 24, 2001

20,264

GB

Yes, that IS odd

 

Upvote 0 Downvote