← Back to team overview

maria-developers team mailing list archive

Re: storage engine index usage


Hi, Andras!

On Feb 06, Andras Szabo wrote:

> SELECT name, fsize FROM etc WHERE path = “init.d”;
> However we’re in a bit of trouble how we could improve the storage
> engine to be able to handle this.
> Of course we would not like to do a "deep enumeration" of the root
> directory (full table scan) . So somehow we would like to access/use
> the information from the where clause.
> Can anybody recommend a way to solve that?

Supporting indexes would be a natural way to do it.
That's not very difficult. See any existing engine, a simple one,
preferrably. Or check my book
the last chapter is about exactly that.