Thanks, Chris and Tom.
I had read *incorrectly* that rtrees are better for <= and >= comparisons.
Chris
On Tue, 13 Jul 2004 14:33:48 +0800, Christopher Kings-Lynne
<[EMAIL PROTECTED]> wrote:
> > I'm storing some timestamps as integers (UTF) in a table and I want to
> > query by <= and >= for tim
I'm storing some timestamps as integers (UTF) in a table and I want to
query by <= and >= for times between a certain period. The table has
gotten quite large and is now very slow in querying.
I think it's time to create an index for the timestamp column.
Uh, yeah.
I tried using an rtree (for <= a
Chris Cheston <[EMAIL PROTECTED]> writes:
> I'm storing some timestamps as integers (UTF) in a table and I want to
> query by <= and >= for times between a certain period.
btree can handle range queries nicely; why do you think you need an
rtree? rtree is for 2-dimensional datums which a timestam