🚀 go-pugleaf

I have just upgraded from Delphi 7 to Delphi 2006. The applications
that our company has developed in the past make extensive use of the
dbGo/TClientDataSet components and I'm trying to investigate the impact
of upgrading them to VCL.NET. I decided to do an experiment to compare
the performance of the dbGo components in the VCL for Win32 compared to
the VCL for .NET.

I created a simple SQL Server client application with a TAdoQuery (set
as a Firehose Cursor for maximum performance) connecting to a
TDataProvider connecting to a TClientDataSet. The application measures
the amount of time it takes to load 100,000 records from SQL Server
into the TClientDataSet. I compiled the application for Win32 and .NET.
I was a bit surprised to see that the .NET version of the application
took five times longer than the Win32 application to load the same
data.

Is there a known performance difference between VCL applications on
these two platforms?

Another question: Is MIDAS.DLL still required for VCL.NET applications
that make use of the TClientDataSet component?

Cheers,

Larry
Cape Town.