Hello everybody,
having this SQL query:
--
select
variable_id,float_value,ts,good_through,interval,datetime_value,string_value,int_value,blob_value,history_value_type
from records_437954e9-e048-43de-bde3-057658966a9f where variable_id
in (22727) and (ts = '2010-10-02 11:19:55' or
Hello everybody,
I have a simple query which selects data from not very large table (
434161 rows) and takes far more time than I'd expect. I believe it's
due to a poor disk performance because when I execute the very same
query for a second time I get much better results (caching kicks in?).
Can