[AccessD] BE on a Network Storage Device..???

John Bartow john at winhaven.net
Wed Apr 16 09:53:13 CDT 2008


I have a client who keeps the BE for an app (one that I didn't write) on an
old Snap Server. Although it's a bit different than the D-Link unit I
thought I'd pass along my experience. 

I haven't (knock on wood) had a problem with any of my apps corrupting the
BE for quite some time. This app's BE has been corrupted a number of times
in the last few years. (They call me to help recover their data.) It could
be the app, and I believe that is part of the problem, but I think the issue
of serving it on the Snap Server (*nix based OS) creates it own problems.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert
Sent: Tuesday, April 15, 2008 2:29 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] BE on a Network Storage Device..???

Bill,
 I have been testing for a while now, RAID 1's performance was the worst,
very slow... RAID 0 (2 identical 500 Gb Drives) was very, very snappy, about
twice as fast as when the back end is sitting on another PC. (other PC on
the same network at the same speed (1Gbit Lan) as the NAS. 

I don't think the lost of the mirror will affect us too much, as we run
frequent backups of the data to another Local HHD. And then for the very
important stuff, to a removable flash drive...

I have not tested any other configurations such as JBOD or No RAID (Plain
Drives), so I still don't know if I'm at the best setup in terms of access
speed.

My concern is corruption. The D-Link DNS-323 formats the drive EXT2, so I
don't know if that is going to cause any problems... 


Thanks for your input

WBR
 ~Robert




-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Patten
Sent: Tuesday, April 15, 2008 1:18 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] BE on a Network Storage Device..???

Robert,

I have a client where we moved the BE (MDB) from a local PC to the server
farm. The program ran so slow (we thought it was a network issue) that we
moved it back to a local PC. Recently for backup issues we moved it back to
the server farm. Same problem. I was talking to one of their IT people and I

found out (to my surprise) that the MDB was being placed on a NAS with.Raid
5. The IT and I discussed the problem, and he said he had heard that the NAS

could not handle multiple connections as well as a PC. I do not know if this

is true, just pass it on for you to check on. Our solution is to move them
to a SQL server backend, which has to go on a Server not the NAS.

Hope this helps.


Bill


----- Original Message -----
From: "Robert" <robert at servicexp.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Tuesday, April 15, 2008 5:39 AM
Subject: [AccessD] BE on a Network Storage Device..???


I've just started testing this with a D-Link 323, and it SEEMS to work. Any
thoughts?


WBR
 ~Robert


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list