When using TADOQuery.Recordset.Fields and TADOQuery.Recordset.MoveNext the loading of the data can be done in about 40 secs.
When using TMSQuery.FieldByName and TMSQuery.Next this takes over 2 minutes.
1. How can I get the same performance out of the SDAC components?
2. Using the follow query (the table has 1 million records in it):
Code: Select all
SELECT owner_location_id, owner_id, owner_location_date_time, owner_location_shape.AsBinaryZM() AS owner_location_shape, owner_location_notes FROM owner_location';