Thanks for all the answers !

[]s

Carlos
WarmBoot Informatica - http://www.warmboot.com.br
Interbase-BR - http://www.interbase-br.com

GG> I can verify this as well.
GG> I created a purely research db with 10million records and on a indexed field
GG> i get a result in less than 10 secs for any basic query. To add the records
GG> I wrote a program that does volume adding and there was no user-measureble
GG> time loss for adding a new record even if 10 of these program was running on
GG> the network similtaneosly. Each program manages to add about a 1000 records
GG> a minute when 10 programs is running. This is not real-world but still a
GG> good indication of speed.

GG> I am not an expert but I do know that if you plan on such sizes you should
GG> do proper db planning and analasys, because where and when you use indexes
GG> and joins and foreing keys and all other such things will greatly impact on
GG> speed. But then you knew that :-). Typed it for my own reminding.

GG> Groete
GG> Gerhardus

>> -----Original Message-----
>> From: Programming [mailto:Programming@...]
>> Sent: 28 June 2001 05:24
>> To: ib-support@yahoogroups.com
>> Subject: Re: [ib-support] Is IB safe for 50,000,000 records ?
>>
>>
>> I would say absolutely!
>> I have one DB in the size of 7.5 GB, one table around 20 mio records, the
>> other one 13.5 mio and one with around 30 mio records. Close enough?
>>
>> You just have to be careful when joining tables ;-)
>>
>> Speed: Awesome - like usual!
>>
>> Frank
>>
>> -----Original Message-----
>>
>> >Someone asked me that question... any opnions ? Any real world
>> experience ?
>> >
>> >[]s
>> >
>> > Carlos
>>
>>
>> To unsubscribe from this group, send an email to:
>> ib-support-unsubscribe@egroups.com
>>
>>
>>
>> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>>
>>

GG> To unsubscribe from this group, send an email to:
GG> ib-support-unsubscribe@egroups.com



GG> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/