dbGo and TClientDataSet Performance in VCL.NET

Thread View: borland.public.delphi.vcl.components.using.dotnet

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Larry Mon, 30 Jan 2006 13:46

#76

Author: Larry
Date: Mon, 30 Jan 2006 13:46

17 lines
2159 bytes

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 AdoQuery (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 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? 

Do these controls use COM interop? Is that what's slowing them down?

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


Cheers, 


Larry 
Cape Town.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads