On 6/27/07, Dave G <[EMAIL PROTECTED]> wrote:
select payload_time,HEX(processed_data) from data__ProcessedDataFrames where test_id=18 AND top_level_product_name="DataProduct" AND payload_time > 118080000.74704 AND payload_time < 1180564096.24967; What I'm concerned about is with how much data I will eventually have, even scanning over the KEYS will take a long time.
Hi Dave, In the case above, you want to be sure that everything involved in the query is indexed or a key (probably the same thing). To give an example, "test_id=18" ... if that isn't indexed, it will be an O(N) scan over all records in a table rather than an O(log N) retrieval based on some BTREE or similar. As a first step, be sure that everything involved in a typical query is indexed. For joins, the related columns should also be indexed. Dave A.
