Fast reading?

[Ivan Smahin]

Hello Thomas,

Friday, April 9, 2010, 6:04:06 PM, you wrote:

> Hi,

> to write large amount of data into the database there is:

> "INSERT INTO [mytable] (f1, f2, f3, ... ) VALUES ( :1, :2, :3, ...)"

> which is very fast.

> Is there also something similar to READ all fields of a record very fast into
> an array of objects?

> I'm still doing

> cursor.Position = i
> f1 = cursor.fields("f1").value
> f2 = cursor.fields("f2").value
> f3 = cursor.fields("f3").value
> ...


> which is quiet slow...

Probably you are trying to solve your needs in an inappropriate way?

Say, you get a cursor and fill another table with its data.
So  you  iterate  cursor  records  getting  all  column  values and do
"inserts"  into another table. Instead of doing something like this at
once:

insert into another_table select f1,f2... from t1...

Please describe your task and we will find a solution.

-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com