Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2007
    Posts
    3

    Database Selection problem

    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

  2. #2
    Join Date
    Nov 2003
    Posts
    2,934
    Quote Originally Posted by Phoenix123
    which must be open source
    So why do you post this in the Oracle forum?

    Quote Originally Posted by Phoenix123
    1 Crore of records have to insert in tables
    Could you explain me what a "Crore record" is?

    Quote Originally Posted by Phoenix123
    3. Dataloss should not be there...
    So you need to do backups on a regular basis.

    Quote Originally Posted by Phoenix123
    and what time it will take to insert 1 Crore of records
    42

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Could you explain me what a "Crore record" is?
    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.

  4. #4
    Join Date
    Nov 2007
    Location
    Switzerland
    Posts
    27
    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.

  5. #5
    Join Date
    Jun 2004
    Posts
    115
    Hi

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

    You can also use Oracle Express its free.

    regards
    Hrishy

  6. #6
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    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.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •