6 Feb
2015
6 Feb
'15
6:54 p.m.
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 https://www.packtpub.com/big-data-and-business-intelligence/mysql-51-plugin-... the last chapter is about exactly that. Regards, Sergei