• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Retriving 200 reconds taking 5 seconds

 
Ashely Parks
Greenhorn
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