FAT32 vs NTFS for WinXP

What do you think about subject for Windows XP? What exactly is difference?

In a corporative enviroment it is useful to use NTFS because it allows you to administrate security options. At home it is not really important. in my opinion.

The major limitation of FAT, is large fiels, or many files. When you have a drive that has one 2-4 G file, there is virtually no difference performance wise, so as scirius says it comes down to security. (PS, mathematically FAT is faster, but the difference is negligable)

Basically the differences between file systems are: Speed. Speed depends on the size of the folder, and the location of the file in the folder. When used on an appropriate volume size (and for small folders), FAT32 may be faster than NTFS5 because of its more basic structure. FAT32 also may be able to access files faster because it doesn’t have to first check file permissions, as NTFS5 does. However, if the accessed file is badly fragmented, NTFS5 requires fewer disk accesses to find the fragments because of its B-tree folder structure. This B-tree structure also makes it faster to access files in large folders on a NTFS5 volume than on a FAT32 one. Maximum File Size FAT32 supports up to 4GB per single file size. However, the way that NTFS first attempts to store files entirely within the MFT record for the file. If the file is too big, it extends the file’s data using structures such as external attributes and data runs. This flexible system allows files to be extended in size virtually indefinitely. In fact, under NTFS, there is no maximum file size. A single file can be made to take up the entire contents of a volume (less the space used for the MFT itself and other internal structures and overhead.) Recoverability The big advantage of the NTFS5 file system is its recoverability. Through transaction-based recoverability, NTFS5 guarantees the consistency of the volume. Transaction logging allows Windows NT (2k,XP) to undo or redo any failed operations. NTFS5 will undo any incomplete transaction or transactions that receive errors. Because of the strong reliability of the NTFS5 file system, you’re not required to run any disk repair utilities to maintain the volume Microft says. As resume - the only right choice for file system for running Navision DBMS (SQL or Native - does not matter) is NTFS for sure.

Actually Navision recommend FAT.

David: Can you please give me the reference to this document? What is the date of it?

The Installation Guide.

Actually Installation & System Management Guide (v. 3.60) says (Page 139): FAT This file system is used by MS-DOS, Windows 98 and Windows NT. FAT is a data structure that MS-DOS creates on the disk when the disk is formatted. When MS-DOS stores a file on a formatted disk, the operating system places information about the stored file in the FAT so that MS-DOS can retrieve the file when it is requested later. This system is the only system MS-DOS can use. Limitations One of the limitations of this system is that you can only store file names in the format nnnnnnnn.xxx. The file name can have up to eight characters, and the file name extension can have three. NTFS This is an advanced file system specifically designed for use with the Windows NT operating system. It supports long file names, full security access control, file system recovery and extremely large storage media. Comparison of the File Systems Since Navision Attain uses hard disks extensively, it is important to have a fast and reliable file system. The file systems mentioned have approximately the same performance level with regard to read and write operations, and Navision Attain does not utilize all the facilities of the other operating systems.