| Subject | Re: [firebird-support] Re: Large volumes of data |
|---|---|
| Author | Tim |
| Post date | 2005-02-18T09:38:52Z |
I worked on a project several years ago for Blake and Associates (debt
collectors). The Head office was in Durban, and they had branches in
Johannesburg and Cape Town as well.
We had a 64k diginet line from Cape Town (where I worked) and Durban, where
the server was. We were using Interbase - first version 4.x, then 5.0, then
5.1 - and Delphi 5 Enterprise. The server machine was a dual processor P4
with 1 gig ram.
Our DB was (when I left) about 1 GB in size. Each debtor had a record, as
well as several address records, and a contact and response history. There
were (IIRC) 12 million records in the primary table (the debtors table)
when I left, and 23 million in the address table.
While it took some jiggery - pokery, and some quite specialized programming
on both the DB Server and the client application side, I got response times
(from Cape Town to Durban and back) of under 5 seconds on average.
The only problems I experienced were running reports - I developed a
"shadow" database that reports could be run from, and importing records.
In comparison, MySQL sux ....
Regards
Tim
At 11:12 18/02/2005, you wrote:
collectors). The Head office was in Durban, and they had branches in
Johannesburg and Cape Town as well.
We had a 64k diginet line from Cape Town (where I worked) and Durban, where
the server was. We were using Interbase - first version 4.x, then 5.0, then
5.1 - and Delphi 5 Enterprise. The server machine was a dual processor P4
with 1 gig ram.
Our DB was (when I left) about 1 GB in size. Each debtor had a record, as
well as several address records, and a contact and response history. There
were (IIRC) 12 million records in the primary table (the debtors table)
when I left, and 23 million in the address table.
While it took some jiggery - pokery, and some quite specialized programming
on both the DB Server and the client application side, I got response times
(from Cape Town to Durban and back) of under 5 seconds on average.
The only problems I experienced were running reports - I developed a
"shadow" database that reports could be run from, and importing records.
In comparison, MySQL sux ....
Regards
Tim
At 11:12 18/02/2005, you wrote:
> >>What problems are you having?[Non-text portions of this message have been removed]
> >>Alot of companies use firebird for even larger volumes of data than
> >>you are describing.
>
>Hi Dalton,
>
>We are looking at open source databases for an upcoming project. They
>will require fairly extensive search capabilities on person information
>- by area, street, etc.
>
>My other option so far would be MySQL, but because we are a Delphi shop,
>I'd prefer FireBird.
>
>Jannie.
>
>
>----------
>Yahoo! Groups Links
> * To visit your group on the web, go to:
> *
> <http://groups.yahoo.com/group/firebird-support/>http://groups.yahoo.com/group/firebird-support/
>
> *
> * To unsubscribe from this group, send an email to:
> *
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>firebird-support-unsubscribe@yahoogroups.com
>
> *
> * Your use of Yahoo! Groups is subject to the
> <http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.