We can give you guesses, but for a question this specific only you know the relevant facts, like what hardware and software you are using. Why not write a simple
unit test using your components in the most minimal way possible but pulling the data volumes you expect to have, and see what kinds of timings you get? 5 seconds doesn't sound bad, but we don't know if you are pulling an integer or the encyclopedia britannica, what your transactionality concerns are, etc.