I'm using Delphi 7 and SQL Server 2008. The connection is AdoConnection and the Query component I'm using is TAdoQuery.
When i run the following simple query in sql server
select FMStreamid, Latitude, Longitude, RealTime from tblFMStream where vehicleid = 2
it takes 2 sec to execute in sql server (see pic) sql server response
However running the same query in Delphi takes around 15 seconds to Open. Does anyone know how to speed that? Thanks
They extra time from Delphi is probably a combination of the provider that AdoConnection is using and dataset events being fired when you open your query
