[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Bacula-devel] small mysql patch2


Le Monday 01 September 2008 12:42:06 Yuri Timofeev, vous avez écrit :
> Hi
>
> This patch you must approve ;)
> Double-created index of the same field PoolId. See attach.
>
> CREATE TABLE Media (
> ...
>    PRIMARY KEY(MediaId),
>    INDEX (PoolId)
> );
>
> CREATE INDEX inx8 ON Media (PoolId);

In fact, if i look the postgresql creation script, this index is on 
VolumeName, which is a much better idea.

I will change that and add this change to the upgrade script for the next 
release.

This table is quite small, so this index is useful but not critical.

Bye

-------------------------------------------------------------------------
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@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/bacula-devel


This mailing list archive is a service of Copilot Consulting.