On Tue, 17 May 2011 23:19:06 +0200, Crack <[email protected]> wrote: > A few more questions for my phpMyAdmin project. For now I will stick > to using this mailing list, as I have a better chance that somebody > with good knowledge of Drizzle actually sees my questions. > > 1. Is there/will there be HAILDB_SYS_TABLESTATS ever available, or any > other possibility to get at least an estimated row count for HailDB > tables? Unified view in D_D would be nice, but I never saw any mention > of it.
Yes, there should be a unified view. Have each engine do the common bits sep is just silly :) > 2. Is it safe to issue "SELECT COUNT(*) "FROM I_S/D_D.SOMEVIEW", or is > it as with InnoDB - a very very bad idea? It will have to iterate through whatever it is, but for something like I_S.TABLES, this just means the same as SHOW TABLES in each schema. There's no special optimisation for COUNT(*), so it'd be the same as SELECT *, but without having to do all the network transfer. Not as bad as InnoDB for a bunch of them as a bunch of them just traverse in-memory data structures. > For anyone interested, there's a demo available at [1], updated hourly > from my git repository. > > [1] http://demo.phpmyadmin.net/gsoc-piotr/ oh neat! -- Stewart Smith _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
