Sorry. I was wrong. I am now looking into the source code bacula. Working with postgresql is using: 'COPY batch FROM STDIN' (not INSERT ;)
I am now prepared and launched a test for MySQL. I look forward to when it will end. ;) 2008/10/8 Yuri Timofeev <[EMAIL PROTECTED]>: > Good work! > But... > I think the test is not quite correct. ;) > I am talking about the command "COPY" in PostgreSQL. > > In other words, I think that COPY and INSERT performed differently. > "COPY" must be implemented faster than individual "INSERT" into real Bacula > Job. > > I may be wrong. > > To make the most correct test, we must take the bacula source code and > based on it to make gen_filetable.c, for example. > We must use INSERTs instead COPY. > > At the moment I have a server (yet completely empty and sufficiently > powerful) where I can create a database size of 100-200Gb or more, to > conduct tests. > I need the source code gen_filetable.c > > I novice C programmer, so do not promise that write code fast. ;) > > 2008/10/7 John Huttley <[EMAIL PROTECTED]>: >> Hi >> My first test are complete. >> To aid in getting all the questions/answers and results in one place, I've >> made a wiki entry. >> >> >> http://wiki.bacula.org/doku.php?id=wiki:playground >> >> >> My scripts are attached. >> >> --John >> > > >> */ >> #include <stdio.h> >> >> #define ROWS 1000000 >> main () { >> >> long int I; >> int row_offset; >> row_offset=2000000000; >> >> // printf("COPY file (fileid, fileindex, jobid, pathid, filenameid, >> markid, lstat, md5, size, mtime,ctime) FROM stdin;\n"); >> printf("COPY file (fileid, fileindex, jobid, pathid, filenameid, >> markid, lstat, md5) FROM stdin;\n"); >> for (I=0; I< ROWS; I++ ) { >> printf("%d\t%d\t%d\t%d\t%d\t%d\t%s\t%s\n", >> // printf("%d\t%d\t%d\t%d\t%d\t%d\t%s\t%s\t%d\t%s\t%s\n", >> I+row_offset, // fileid >> 3, //fileindex >> random(), //jobid >> random(), //pathid >> 1, //filenameid >> 1, //markid >> "LSTATDATA", //LSTAT >> "MD512345678901234" //md5 >> // ,0, //size >> // "2008-09-01T01:02:04", //ctime >> // "2008-09-01T01:02:05" //mtime >> ); >> } >> >> } >> >> ------------------------------------------------------------------------- >> 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 >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/bacula-devel >> >> > > > > -- > with best regards > -- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-devel
