load data

[Ruslan Zasukhin]

On 11/18/09 9:36 PM, "pphillips99 at gmail.com" <pphillips99 at gmail.com> wrote:

Hi Philip,

Sorry, we only have start make it few months ago,
Not finished.

> Saw the new LOAD DATA sql statement but there are no details. Wondering
> if someone can direct me.
> 
> Basically, I have a 8G tab delimited text file I'd like to import to a
> table. I've tried to use Import via Studio with slow progress. What's
> the preferred method(s) for bulk data import?

In code you can use

    VCursor.ImportText() method.

* may be before import set cache quite big ..



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]