34 ms·
That's why it is sql "lite". It's great for certain things because it's generally lightweight and manageable. But you wouldn't want a single file format on ent
by PricelessValue 9y ago
That's why it is sql "lite". It's great for certain things because it's generally lightweight and manageable.
But you wouldn't want a single file format on enterprise level systems where enterprise level performance and stability is required. At the very least, you'd want your data and transaction log files to be different files on different disks. Especially when IO throughput is important.
Also, since DBs tend to have important data on them, being able to copy a file (db) and move it anywhere you want isn't much of a selling point on serious systems.
Having said that, sqlite is great for application/client side storage.
- deleted 9y ago[deleted]