Forums Register Login

Retriving 200 reconds taking 5 seconds

4
+Pie Number of slices to send: Send

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.
Every plan is a little cooler if you have a blimp. And a tiny ad.
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 466 times.
Similar Threads
getting List values out of hibernate query
Performance hit using "where" clause in the query
Adding Indexes is causing Poor Performance
ConcurrentHashMap vs synchronizedMap
my inverted index not successfull
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 11:31:18.