Technical details
Questions frequently arise regarding how many records alfons can store, how securely the data is stored, and whether there are any other limitations. Here, we've compiled the most important key points:
Technical Specifications
| Scope | Limits |
| ---------------------------------------------- | :-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------: |
| File Size | Limited only by disk space, up to a maximum of 8 TB (terabytes) on a single disk and OS API capability |
| Number of Files per Disk | Limited only by disk space |
| Number of Simultaneously Open Files/Windows | macOS: Up to 125 files/windows recommended. Windows: Up to 125 files/windows recommended. |
| Maximum Field Size, Text | < 10,000,000 characters per field and repetition (limited by available memory) with optional text styles and paragraph formatting. Indexing is based on the first 100 characters of each word or value. |
Maximum field size, number | Supports values from 10^-400 to 10^400, including negative values within the same range. Indexing is based on the first 400 significant digits. Up to 1 billion characters per field. The first 400 digits are indexed. |
Maximum field size, media | Multiple streams of binary data, not exceeding 4 gigabytes in total per media field. (Remote storage available) |
Number of fields/columns per record | 256 million fields total for the lifetime of the file. |
Number of relationships per file | Limited only by disk space or the maximum file size. |
Number of tables per file | 1 million |
Number of records per table | 64 quadrillion records total for the lifetime of the file. |
Maximum record size | Limited by disk space or maximum file size |
Supported File Formats
| Area | File Formats |
| --------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| Import File Formats | Comma-separated text files (.csv or .txt), dBASE III and IV DBF (.dbf), FileMaker Pro, mail merge files, Microsoft Excel (.xlsx), tab-separated text files (.tab or .txt), XML files, and ODBC |
| Export File FormatsComma-separated text files (.csv or .txt), dBASE III and IV DBF (.dbf), FileMaker Pro, HTML spreadsheet files, mail merge files, Microsoft Excel (.xlsx), tab-separated text files (.tab or .txt), XML files |
Image formats import | GIF (.gif), JPEG/JFIF (.jpg), JPEG 2000 (.jp2) (macOS), MacPaint (.mac) (macOS), PDF (.pdf) (macOS), Photoshop (.psd) (macOS), PNG (.png), SGI (.sgi) (macOS), Targa (.tga) (macOS), TIFF (.tif), Windows bitmap (.bmp), Windows Metafile/Enhanced Metafile (.wmf/.emf) (Windows) |
Audio/video formats import | AIFF Audio file (.aif, .aiff), AVI movie (.avi), MP3 Audio File (.mp3), MPEG-4 Audio File (.m4a), MPEG-4 movie (.mp4), MPEG movie (.mpg, .mpeg), MPEG-4 video file (.m4v), QuickTime Movie (.mov, .qt), Sun Audio file (.au), WAVE Audio File (.wav), Windows Media Audio (.wma), Windows Media Videos (.wmv) |
Supported platforms
| macOS | Windows |
|---|---|
macOS Sierra v10.12 (64-bit only) |
Windows 10 Pro |