Orla,
here is my example of using ADO but with loops. I don't believe there is
another way to do that.
There are two ways of storing the data in the example:
a) via a recordset
b) via a sql command
My timing results for a 500x5 Real64 array with an Pentium II (256MB/450
MHz/Win2K) are
a) 1.7 s, b) 3.2 s
Hope it helps a bit
Georg Nied
Software-Development
Test and Measurement
51149 Cologne Germany
g.nied@gn-software.de
-----Ursprngliche Nachricht-----
Von: owner-vrf@lvld.agilent.com [mailto:owner-vrf@lvld.agilent.com]Im
Auftrag von Orla Poulsen
Gesendet: Dienstag, 29. Januar 2002 15:21
An: vrf@lvld.agilent.com
Betreff: vrf 2d array to AccessDatabase
Can somebody tell me if there is a possibility to add a 2dArray like (500,5)
to a table with 5 fields in a database without a loop, because its very
slow.
Any help will be a big help, iff it is vee, vb or c++ dosn't matter
Orla Poulsen
ITS.
---------------------------------------------------------------------
This is the "vrf" maillist, managed by Majordomo. To send messages to
this maillist, just email to "vrf@lvld.agilent.com". Subscriptions and
unsubscriptions are done through the address "vrf-request@lvld.agilent.com".
If you need details, just send a message containing the text "help"
to "vrf-request@lvld.agilent.com".
---------------------------------------------------------------------
here is my example of using ADO but with loops. I don't believe there is
another way to do that.
There are two ways of storing the data in the example:
a) via a recordset
b) via a sql command
My timing results for a 500x5 Real64 array with an Pentium II (256MB/450
MHz/Win2K) are
a) 1.7 s, b) 3.2 s
Hope it helps a bit
Georg Nied
Software-Development
Test and Measurement
51149 Cologne Germany
g.nied@gn-software.de
-----Ursprngliche Nachricht-----
Von: owner-vrf@lvld.agilent.com [mailto:owner-vrf@lvld.agilent.com]Im
Auftrag von Orla Poulsen
Gesendet: Dienstag, 29. Januar 2002 15:21
An: vrf@lvld.agilent.com
Betreff: vrf 2d array to AccessDatabase
Can somebody tell me if there is a possibility to add a 2dArray like (500,5)
to a table with 5 fields in a database without a loop, because its very
slow.
Any help will be a big help, iff it is vee, vb or c++ dosn't matter
Orla Poulsen
ITS.
---------------------------------------------------------------------
This is the "vrf" maillist, managed by Majordomo. To send messages to
this maillist, just email to "vrf@lvld.agilent.com". Subscriptions and
unsubscriptions are done through the address "vrf-request@lvld.agilent.com".
If you need details, just send a message containing the text "help"
to "vrf-request@lvld.agilent.com".
---------------------------------------------------------------------