Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • April 29, 2004 at 3:13 pm in reply to: Import HUGE table (~1G) via query #15718
    fhlostonparadise
    Member

    Since ODBC is the only way for me to communicate w/ the server, it doesn't matter what format of the data I request the performance issue will be there.

    April 24, 2004 at 2:49 am in reply to: Import HUGE table (~1G) via query #15716
    fhlostonparadise
    Member

    Here is what I have found by playing around with the NonStop SQL ODBC driver. When I switch the cursor mode from read_only_streaming to read_only, the high memory usage no longer happens. However, the data transfer is significantly affected. I'm down to 120 records/sec. That will take me 2 months to import 560M records!

    Looks like I'll have to find some other ways to get round this… Any suggestions?

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)