If multiple queries run parallel on a single database instance, random I/O patterns can significantly slow down response times.
For each database instance, a single cursor and buffer pool is created. We could enhance this and…
- allow one cursor per thread.
- multiple buffer pools would be possible as well, but all of them would need to be flushed, or refreshed, after update operations.
If multiple queries run parallel on a single database instance, random I/O patterns can significantly slow down response times.
For each database instance, a single cursor and buffer pool is created. We could enhance this and…