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