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

Re: [Bacula-devel] Alternative DB proposal


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


This mailing list archive is a service of Copilotco.