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?
--
with best regards
-------------------------------------------------------------------------
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
