Subject | Re: [Firebird-general] Data warehousing using Firebird |
---|---|
Author | Dalton Calford |
Post date | 2004-05-12T15:33:25Z |
Hi Pradeep,
Large databases are not a problem, nor will you have problems with the
database being very active.
We have a 24/7 database system that supports multiple remote offices,
well over 300 concurrent active users and automated interactive voice
systems that query and update the database. The database is updated
with customer call records that are starting to exceed 5GB a month in
call volume.
The limits you will experience will come from poorly designed client
apps that do not properly deal with transactions, and the 40 GB limit on
a single table (miliage may vary, but we find that you need trim your
database once a single table starts getting near the 38 GB mark).
best regards
Dalton
Pradeep wrote:
Large databases are not a problem, nor will you have problems with the
database being very active.
We have a 24/7 database system that supports multiple remote offices,
well over 300 concurrent active users and automated interactive voice
systems that query and update the database. The database is updated
with customer call records that are starting to exceed 5GB a month in
call volume.
The limits you will experience will come from poorly designed client
apps that do not properly deal with transactions, and the 40 GB limit on
a single table (miliage may vary, but we find that you need trim your
database once a single table starts getting near the 38 GB mark).
best regards
Dalton
Pradeep wrote:
>Hi,
>We are developing a data warehousing solution for a telco. We used SQL
>server 2000 for proto and pilot project before moving onto Oracle on Unix.
>And our experience with SQL server 2000 was NOT good.
>So, I was wondering whether Firebird could be a good choice when it
>comes to building data-marts if not full fledged datawarehouses?
>
>Thanks in advance,
>Pradeep
>
>
>
>
>Community email addresses:
> Post message: Firebird-general@yahoogroups.com
> Subscribe: Firebird-general-subscribe@yahoogroups.com
> Unsubscribe: Firebird-general-unsubscribe@yahoogroups.com
> List owner: Firebird-general-owner@yahoogroups.com
>
>Shortcut URL to this page:
> http://www.yahoogroups.com/community/Firebird-general
>Yahoo! Groups Links
>
>
>
>
>
>
>
>