Le Lundi 22 Février 2010 15:34:07, Philipp Storz a écrit :
> Hello Eric,
>
> the second patch changes nothing in the behaviour:
>
> The mysql query lasts exaclty as long as before, and there is no error.
Hi Philipp,
I have corrected the small mistake in the first patch, could you try it ?
Thanks
diff --git a/bacula/src/cats/sql_create.c b/bacula/src/cats/sql_create.c
index a106fe8..429f4d1 100644
--- a/bacula/src/cats/sql_create.c
+++ b/bacula/src/cats/sql_create.c
@@ -1237,6 +1237,11 @@ bool db_create_base_file_list(JCR *jcr, B_DB *mdb, char *jobids)
if (!db_sql_query(mdb, mdb->cmd, NULL, NULL)) {
goto bail_out;
}
+ Mmsg(mdb->cmd, "CREATE INDEX basefile%lld_idx ON basefile%lld (Path(255), Name(255))",
+ (uint64_t) jcr->JobId, (uint64_t) jcr->JobId);
+ if (!db_sql_query(mdb, mdb->cmd, NULL, NULL)) {
+ goto bail_out;
+ }
Mmsg(buf, select_recent_version[db_type], jobids, jobids);
Mmsg(mdb->cmd,
"CREATE TEMPORARY TABLE new_basefile%lld AS "
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Bacula-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-devel
