copyFromRecordset - vs - getRows
What provider are you using?
Ingres
What does your SQL statement look like?
very simple:
SELECT value, period
FROM relevant table
WHERE (identifier = X) or (identifier = Y) or etc
ORDER BY period
(and the number of identifiers can be very large)
I'm asking because I think it may be easier/more efficient to have the db
convert the string to numeric
That's what I was hoping.
Bob Phillips asked why try to use .copyFromRecordset. It's because some
testing shows that the speed differences are several orders of magnitude.
I'm trying to get people to change some habits, so this speed carrot is
important for me.
thanks,
Christopher
|