On Wednesday 03 September 2008 08:22:31 Yuri Timofeev wrote: > Hi > > 2008/8/31 Eric Bollengier <[EMAIL PROTECTED]>: > > If you want to use new indexes with dbcheck, you can modify dbcheck.c in > > this way : > > - ask to the user if he wants to add them (think about disk space) > > - add them + run analyse > > - run the cleanup operation > > - remove them > > > > FYI, postgresql can use composite indexes, so it will require less > > indexes than mysql. > > It seems the problem appears only when working with MYSQL. > > I made a small program in order to make temporary index > CREATE INDEX idxFJ ON File (FileId, JobId); > and then removes him. > > Now I little understand a Bacula API. And there is one problem: > my source code depends on the DBMS (MySQL). > And I still do not know how it can be inserted in dbcheck.c > > > If I write (in dbcheck.c) as follows: > > # ifdef HAVE_MYSQL > / * My code uses bacula api * / > # endif > > So it would be wrong, imho, or is this possible? > Can you suggest any solution?
Please be specific about the exact MySQL dependencies. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel