Performance gains from external database

Hi,

We have been using TeamCity with the internal database for some time now and encountered no problems. It has successfully handled with running out of disc space and RAID failures without any problems. We are about to move out TeamCity server to a new machine and wondered what other experience other people have had using external databases. Our database of choice would by MySQL but unless there is a speed/performance advantage we are likely to continue using the internal database as this has proved to be robust.


Richard Taylor.

Lead Game Systems.

Travellers Tales Ltd.

http://www.ttgames.com/



2 comments
Comment actions Permalink

Usually external database is easier to maintain and has many parameters that can be tuned. As for performance I would not expect differences if database size is relatively small. But for large databases I think external DB will work faster. BTW our own database (MySQL) is about 6.5Gb, and the biggest table is test_info holding almost 19 millions of rows. I do not think HSQLDB will be able to deal with such tables.

0
Comment actions Permalink

Hello Pavel,

We started running into performance problems in TC 4, running with the internal
database. TC 3 was OK, but things degraded significantly when we upgraded
to 4 (tens of seconds to finish loading the main page, server CPU pegged
at 100%, stuff like that). The new text indexing feature really killed our
server (not a beefy machine, by any means), but even disabling that did not
improve performance too much.

After trying all sorts of things (with no visible results) we switched to
an external DB. It's been sunny ever since.

Our HSQLDB size, before switching, was about 130 megs.

HTH,
Andrei



PS> Usually external database is easier to maintain and has many
PS> parameters that can be tuned. As for performance I would not expect
PS> differences if database size is relatively small. But for large
PS> databases I think external DB will work faster. BTW our own database
PS> (MySQL) is about 6.5Gb, and the bigges
PS>
PS> t table is test_info holding almost 19 millions of rows. I do not
PS> think HSQLDB will be able to deal with such tables.
PS>
PS> ---
PS> Original message URL:
PS> http://www.jetbrains.net/devnet/message/5236870#5236870


0

Please sign in to leave a comment.