sqlYoga: best way to import lots of data

[Ruslan Zasukhin]

On 3/24/10 9:34 PM, "Trevor DeVore" <lists at mangomultimedia.com> wrote:

> On Mar 24, 2010, at 3:27 PM, David Bovill wrote:
> 
>> I'm working on a database for rev handlers using sql yoga. I want to
>> import
>> a few thousand hander references into the db. So far I've got
>> something
>> like:
>> 
>>     put sqlrecord_CreateObject ("handler") into theRecordA
>>> 
>>>      sqlrecord_set theRecordA, "name", "menu_CreateTable"
>>>      sqlrecord_set theRecordA, "type", "c"
>>>      sqlrecord_set theRecordA, "object", scriptObject
>>>      sqlrecord_set theRecordA, "number", 1
>>> 
>>>      sqlrecord_create theRecordA
>> 
>> I'm thinking it would be better / faster to create one big numerically
>> indexed array and then update - any ideas on the syntax for that?

Actually db engines have own fast IMPORT methods.
You give file, point table and done.


-- 
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]