What is considered slow with respect to SQL queries?

Question

I have a server-side code written in Node.js that makes 6 SQL queries in one request. The queries consist of mostly SELECT statements with a couple of INNER JOIN and OUTER JOIN.

They take about 4ms when I run them directly in command-line.

I am curious at what point they would be considered slow and I'll have to maybe start memcaching the results. Coming from front-end world, 4ms seems extremely fast!

While this is an interesting question, it is not on-topic here. It will be better served on dba.SE, our site for database administrators, or possibly webmasters.SE. — Kevin
– Kevin, Commented Mar 9, 2012 at 2:54

Karl · Accepted Answer · 2012-03-09 02:47:43Z

4

What is considered slow with respect to SQL queries?

Anything the user complains about.

And of course that is not always rational but it is the only meaningful anwer. The quesiton is so dependant on context; a OLTP system will have different characteristics from an OLAP one. Also, what might be fast for a single DB lookup may be slow with 6.

If the finished product is slow to use worry about it, otherwise focus on other aspects of quality. Of course is something presents itwelf to enable you to improve performance do so but don't look for problems before they exist.

answered Mar 9, 2012 at 2:47

Karl

3,38223 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

What is considered slow with respect to SQL queries?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related