Re: Query execution for intervals

frebe73_at_gmail.com wrote:
> I am writing a calendar client application. I am trying to decide if
> the calendar data should be managed by an emedded RDBMS (hsqldb) or
> just using ical text files (using ical4j). Using ical files I will have
> to traverse every event to find out if it should be displayed in the
> view. Are you saying that using a RDBMS, the query engine also has to
> traverse the evernt in a linear way? From this aspect, would you
> recommend ical files or a RDBMS?

I believe bitmapped indexes behave in linear way, although with very generous coefficient. Don't know about R-Trees. I suggest you to experiment with db queries before making any design decision. Received on Mon Feb 06 2006 - 19:01:00 CET