Subject | [Firebird-Architect] Re: Index structures |
---|---|
Author | Roman Rokytskyy |
Post date | 2003-06-10T14:18:49Z |
Arno,
engine and we touched an index structure a little bit.
I would say that we need different indices for different purposes.
For example, I am working with geo data and b-tree is not very usefull
there (simple quad-tree or r-tree give me much more better
performance). Full-text search hardly can be implemented with b-tree
too (inverted file structure give much more better performance). But
these ideas belong to what usually is called "object-relational dbms".
Just my 2 cents
Best regards,
Roman Rokytskyy
> The question is, is it intresting to add a new index-structure whichIn Fulda I had a talk with Sean about plugin architecture for the
> could be used when a user want it. I think it isn't bad to have 2
> index-structures inside a engine, but let's wait for some more
> comments/ideas.
engine and we touched an index structure a little bit.
I would say that we need different indices for different purposes.
For example, I am working with geo data and b-tree is not very usefull
there (simple quad-tree or r-tree give me much more better
performance). Full-text search hardly can be implemented with b-tree
too (inverted file structure give much more better performance). But
these ideas belong to what usually is called "object-relational dbms".
Just my 2 cents
Best regards,
Roman Rokytskyy