4 ms·
Plus read-only isn't a guarantee. You can't write data, but you can run a bad select or join that ends up effectively locking the database. SELECT * FROM my_20
by MBCook 14y ago
Plus read-only isn't a guarantee. You can't write data, but you can run a bad select or join that ends up effectively locking the database.
SELECT * FROM my_200_GB_table will always be there.
- michaelt 14y agoWhy should a select or join lock a database? Surely no database lets one query starve another of IO or CPU?