Re: Changes in SQL backend design

2010-04-15 Thread Jan Horák
Dne 16.4.2010 00:04, Greg Stein napsal(a): I'm away from my laptop, so please excuse the brevity... Yes, we can set you up with a branch. You will need to sign an ASF CLA. Then we can go from there. I'll send more details later (unless somebody does it first, or you find the CLA). Thanks,

RE: Changes in SQL backend design

2010-04-15 Thread Bob Archer
> I think it would be nice to store more repositories in one database, but > I find this way a bit confusing and without significant advantages (e.g. > it would be not clear which rows belong to which repository). Please don't do this unless it is an option. Each repository should be self contain

Re: Changes in SQL backend design

2010-04-15 Thread Greg Stein
I'm away from my laptop, so please excuse the brevity... Yes, we can set you up with a branch. You will need to sign an ASF CLA. Then we can go from there. I'll send more details later (unless somebody does it first, or you find the CLA). On Apr 15, 2010 5:58 PM, "Jan Horák" wrote: Hi, Dne 14

Re: Changes in SQL backend design

2010-04-15 Thread Jan Horák
Hi, Dne 14.4.2010 18:08, Greg Stein napsal(a): 2010/4/14 Philipp Marek: Hello Jan! On Dienstag, 13. April 2010, Jan Horák wrote: Dne 12.4.2010 8:02, Philipp Marek napsal(a): Sorry for the delay; but reading the thread "Severe performance issues with large directories" I ju

Re: Changes in SQL backend design

2010-04-15 Thread Jan Horák
I think it would be nice to store more repositories in one database, but I find this way a bit confusing and without significant advantages (e.g. it would be not clear which rows belong to which repository). But, some table prefix could be used by all tables, it would be transparent and easy t

Re: Changes in SQL backend design

2010-04-15 Thread Martin Furter
On Tue, 6 Apr 2010, [ISO-8859-2] Jan Horák wrote: Hi, I've made some changes in SQL backend desing, updated design is at: http://www.stud.fit.vutbr.cz/~xhorak50/diplomathesis/files/100405_mysql_design_v2.png If you add a field "repository_name" to the transactions table it would be possible

Re: Changes in SQL backend design

2010-04-14 Thread Greg Stein
2010/4/14 Philipp Marek : > Hello Jan! > > On Dienstag, 13. April 2010, Jan Horák wrote: >> Dne 12.4.2010 8:02, Philipp Marek napsal(a): >> > Sorry for the delay; but reading the thread "Severe performance issues >> > with large directories" I just remembered that the backend has a little >> > bit

Re: Changes in SQL backend design

2010-04-13 Thread Philipp Marek
Hello Jan! On Dienstag, 13. April 2010, Jan Horák wrote: > Dne 12.4.2010 8:02, Philipp Marek napsal(a): > > Sorry for the delay; but reading the thread "Severe performance issues > > with large directories" I just remembered that the backend has a little > > bit of a problem with big directories -

Re: Changes in SQL backend design

2010-04-13 Thread Jan Horák
Hello Phil, Dne 12.4.2010 8:02, Philipp Marek napsal(a): Sorry for the delay; but reading the thread "Severe performance issues with large directories" I just remembered that the backend has a little bit of a problem with big directories - storage overhead. Do you see any way to split directori

Re: Changes in SQL backend design

2010-04-11 Thread Philipp Marek
Hello Jan, Sorry for the delay; but reading the thread "Severe performance issues with large directories" I just remembered that the backend has a little bit of a problem with big directories - storage overhead. Do you see any way to split directories into a series of blocks (like files are do

Re: Changes in SQL backend design

2010-04-06 Thread Jan Horák
Dne 6.4.2010 10:50, Philipp Marek napsal(a): Hello Jan! On Dienstag, 6. April 2010, Jan Horák wrote: Hi, I've made some changes in SQL backend desing, updated design is at: http://www.stud.fit.vutbr.cz/~xhorak50/diplomathesis/files/100405_mysql_des ign_v2.png ... The last thing

Re: Changes in SQL backend design

2010-04-06 Thread Jan Horák
Dne 6.4.2010 10:54, Senthil Kumaran S napsal(a): Jan Horák wrote: The last thing is the discussed storing of the representations in files, not in DB. I've made a simple test of the access speed to database and to pure filesystem, the report is here: http://www.stud.fit.vutbr.cz/~xhorak50/diplom

Re: Changes in SQL backend design

2010-04-06 Thread Senthil Kumaran S
Jan Horák wrote: The last thing is the discussed storing of the representations in files, not in DB. I've made a simple test of the access speed to database and to pure filesystem, the report is here: http://www.stud.fit.vutbr.cz/~xhorak50/diplomathesis/files/100406_data_access_speed_comparison.

Re: Changes in SQL backend design

2010-04-06 Thread Philipp Marek
Hello Jan! On Dienstag, 6. April 2010, Jan Horák wrote: > Hi, I've made some changes in SQL backend desing, updated design is at: > http://www.stud.fit.vutbr.cz/~xhorak50/diplomathesis/files/100405_mysql_des > ign_v2.png ... > The last thing is the discussed storing of the representations in files

Changes in SQL backend design

2010-04-06 Thread Jan Horák
Hi, I've made some changes in SQL backend desing, updated design is at: http://www.stud.fit.vutbr.cz/~xhorak50/diplomathesis/files/100405_mysql_design_v2.png As Philipp M. proposed, Representations are now provided with an SHA1, but in a bit different way than in BDB. In BDB there is another tab