On Wed, Sep 20, 2006 at 09:44:24AM -0400, Bill Moran wrote:
> Try them out ... if they make a significant improvement, use them.
As an aid to experimenting with indexes, and to help people give more hard
data, perhaps it might be usefull to add an option to dbcheck to output the
results of running explain (mysql, I assume postgresql has an equivalent) on
the queries used. This info is really useful to find hotspots that would
benefit the most from adding an index or two.
--
Frank Sweetser fs at wpi.edu | For every problem, there is a solution that
WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken
GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29E3 E2E8 8CEC
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
