[Info-vax] VMS databases

[Arne Vajhøj]

On 11/20/2023 11:50 AM, Stephen Hoffman wrote:
> On 2023-11-19 22:22:37 +0000, Jan-Erik Söderholm said:
>> Den 2023-11-19 kl. 18:37, skrev Stephen Hoffman:
>>> As with many things in IT, that depends.
>>>
>>> Expectations and related sizes can also differ. What can be 
>>> considered a small database for SQLite can potentially be considered 
>>> a large database for OpenVMS, for instance.
>>>
>>> Expectations? SQLite tops out at 256 TiB databases, while OpenVMS 
>>> file storage tops out at 2 TiB files absent 'heroic' efforts.
>>
>> A single Rdb database can have 8192 storage areas (individual files) 
>> so the max database size would be something like 16.000 TiB.
> 
> So... Heroic _and_ expensive.

I believe that people would:
* switch from SQLite to a database server way before 256 TB
* switch from Rdb to Wide Column Data Store NoSQL database (like
   HBase or Cassandra/ScyllaDB) way before 16 PB

Arne