4 ms·
> In an asynchronous/event driven server slow SQL queries won't limit your concurrency Since this is on the JVM, SQL almost always means JDBC and JDBC is block
by fernandezpablo 14y ago
> In an asynchronous/event driven server slow SQL queries won't limit your concurrency
Since this is on the JVM, SQL almost always means JDBC and JDBC is blocking so yes, SQL will in fact limit your concurrency.
- shenedu 14y agoyes, SQL is blocking, JVM also have threads. The http-kit is asynchronous(epoll on linux), the API for programmers is sync, which is more familiar.
- pygy_ 14y agoAlternatively, you can use a message queue or a REST service, and whatever lightweight, async database frontend.
- fernandezpablo 14y agoThat would just move the blocking code elsewhere, and now you have one extra framework / message queue on your stack (free complexity)
- pygy_ 14y agoThe point is to use a non-blocking DB frontend. Not necessarily JVM-based.