×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Running back end access on Nas

Running back end access on Nas

Running back end access on Nas

(OP)
Hello, I am now running the back end of the database on a Nas. (Synology)

It is now running much slower than it was on a pc.

Has anyone any tips or experience with running from a Nas that may help me speed things up?

Many thanks Mark.

RE: Running back end access on Nas

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?

RE: Running back end access on Nas

(OP)
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

RE: Running back end access on Nas

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 ...

RE: Running back end access on Nas

(OP)
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

RE: Running back end access on Nas

Yes, that IS odd

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close