Win a copy of Java 9 Modularity: Patterns and Practices for Developing Maintainable Applications this week in the Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Retriving 200 reconds taking 5 seconds  RSS feed

Ashely Parks
Posts: 2
  • Likes 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

When I execute that statement it retrieves about 200 records from a very large table. I've timed that it takes about 5 seconds every time.
The table has four columns, one tinytext (the big one full of text), one date and two ints.

When it is a "streaming" results set I have the same problem, expect the 5sec delay is moved to when I iterate over the result set.

Is it normal that it takes so long?

SOLVED: indexed the UserID column, now it takes a few miliseconds.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!