Hi.........

I working on standalone application and I have to select
database....which must be open source and fullfill following
requirements........

1. I have to parse text file upto 5 GB and data taken from that
which may be 1 Crore of records have to insert in tables

2. Speed should be too fast

3. Dataloss should not be there...

Please, tell which database I can use in this case.....
and what time it will take to insert 1 Crore of records

Waiting for Reply

So why do you post this in the Oracle forum?

Could you explain me what a "Crore record" is?

So you need to do backups on a regular basis.

42

It is an abbreviation for "Croatian record" (records often used in Croatian countryside).

BTW, time required to do that is not 42 any more. It WAS 42 until Crore Developer v0.99b was released.

Easy one. Use either PostgreSQL or MySQL. (they are both open source)
With either of them it will take 3.4 secs to insert one Crore record no matter what platform and system capacity you gonna use.

Hi

One crore is nothing but 10 million (its a indian numbering system) .

You can also use Oracle Express its free.

regards
Hrishy

True, but Oracle Express IS limited (4 GB database size?) and, when parsing 5 GB files, you may run into the limitations fairly quickly.

AFAIK, you will need to write some form of external application to perform the parsing, as the file import utilities are rather limited.