<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Julien,<br>
<br>
we are indeed using MySQL as the database backend. As I don't know the
internal table organisation of CDash, I am wondering, if compressing
whole rows wouldn't slow down accesses<br>
to the tables very much. Wouldn't it be better to only compress the
column containing the text output? This could be done in CDash upon
access of this column only.<br>
<br>
I already tried to put a feature request in the bug tracker, but the
bug tracker, which is linked from <a class="moz-txt-link-abbreviated" href="http://www.cdash.org">www.cdash.org</a> does only contain
category entries for CMake, CTest etc., but not for CDash.<br>
So I thought I'd ask on the mailing list first.<br>
<br>
Regards,<br>
<br>
Martin<br>
<br>
Julien Jomier wrote:
<blockquote cite="mid:4B20FB8B.30702@kitware.com" type="cite">
<pre wrap="">
Hi Martin,
This is an interesting point and, as you said, we have two options:
1) Provide a way to store the body of the tests outside the database on
disk. We would have to create a a directory structure to avoid writing
all the files in the same place.
2) Compress the data in the database. I assume you are using MySQL (and
MyISAM as your storage engine). One temporary option is to use InnoDB
which allows for compression of the entire row. PostGreSQL already
compresses the rows so we should be OK for this one.
I think we should try option 2) first and see how this goes, since
option 1) is a little bit more complex to implement. Could you log a
feature request in the bug tracker?
Thanks,
Julien
Martin Apel wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi all,
we currently run lots of tests using CTest/CDash every night (about
4000), which produce a huge amount of output. For reasons difficult to
explain here, we'd like to keep the output, even if the tests succeeded.
For this reason our database has grown a lot recently, so I am looking
for ways how to handle this. I thought about two ways:
1. Is it possible to embed links into the test output, so we could store
the test output in separate files, and simply link to these files in
CDash? We have tried outputting links in the tests,
but ctest seems to replace any special characters such as ampersand,
so we did not succeed until now.
2. Is it possible to store the test output inside the database in a
compressed way? As it is ASCII output, it would probably save a lot of
disk space.
Any comments are welcome.
Best Regards,
Martin
_______________________________________________
Cdash mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Cdash@public.kitware.com">Cdash@public.kitware.com</a>
<a class="moz-txt-link-freetext" href="http://public.kitware.com/cgi-bin/mailman/listinfo/cdash">http://public.kitware.com/cgi-bin/mailman/listinfo/cdash</a>
</pre>
</blockquote>
<pre wrap=""><!---->.
</pre>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
<pre>Martin Apel
Software Architect
Phone: + 49 8105 77266-53
E-Mail: <a class="moz-txt-link-abbreviated" href="mailto:martin.apel@simpack.de">martin.apel@simpack.de</a>
SIMPACK AG
Friedrichshafener Strasse 1, 82205 Gilching, Germany
<a class="moz-txt-link-abbreviated" href="mailto:info@simpack.de">info@simpack.de</a>, <a class="moz-txt-link-abbreviated" href="http://www.simpack.com">www.simpack.com</a>
Phone: + 49 8105 77266-0
Fax: + 49 8105 77266-11
Executive Board: Dr. Alexander Eichberger, Dr. Lutz Mauer
Chair of Supervisory Board: Silvia Förster (CPA)
Commercial Register München HRB 181 229
</pre>
</div>
</body>
</html>