Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP DBC on a NAS or SAN
Message
From
05/02/2008 03:40:27
Al Doman (Online)
M3 Enterprises Inc.
North Vancouver, British Columbia, Canada
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01289439
Message ID:
01289446
Views:
12
>Does anyone have any knowledge/experience on using a Visual Foxpro database on a SAN or NAS?

SANs and NASs are very different things. Overview for lurkers: http://en.wikipedia.org/wiki/Storage_area_network

A SAN is usually configured to appear to a given server as if it is local storage. IOW you can think of a SAN as a large, high-performance disk subsystem installed in that server. Your Fox files are stored somewhere on the SAN but you don't access the SAN directly, you do so by accessing the server. If the server is a Windows server it's just like running your app on a LAN with a Windows server.

The server may not actually be a Windows (SMB/CIFS) server; it might emulate one instead (e.g. Novell, SaMBa on *n?x, etc.) It's worth noting that a VFP app busy with a lot of file I/O is a stern test of any SMB/CIFS or compatible file system. You might want to look at message#1275777 and those following. Although I've had ongoing/intermittent issues running VFP against a SaMBa file store at one client, John Fabiani seems to have had good experiences.

In contrast, client computers usually access a NAS device directly. Although these boxes are sometimes not much bigger than a 3.5" hard drive, they are not just a bare drive, they are in fact servers typically running an embedded version of Linux, and SaMBa running as a process on Linux to emulate an SMB/CIFS disk. Unfortunately, many of these have limited hardware - a low-end processor and maybe only 32MB of RAM, so their I/O performance is poor. I don't know if it's still the case, but some low-end NASs would not even support multiple simultaneous users of a given file - it was the equivalent of SET EXCLUSIVE ON. I'd be wary about trying to run a multi-user VFP app with its files stored on a typical NAS.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform