Performance issues

Performance issues

Postby Zero-G. » Wed 17 Feb 2010 09:21

Hey

I have big performance issues with LinQ
I try to get my data through a server, which is located in the internet.
Connection is compressed!
I do load about 8000 lines through LinQ (about 20 fields/row)
With LinQ this query uses up to 15 seconds

When I use a Datareader, then this Query needs about 4 to 5 seconds.

Is there a way to speed this up? - Because this is a mes...

THX
Zero-G.
 
Posts: 390
Joined: Sat 09 Dec 2006 12:20

Postby AndreyR » Wed 17 Feb 2010 12:33

You can try the new CompiledQueryCache class, we have added it in the latest Beta build.
Code: Select all
Dim compiledQueryCache As Devart.Data.Linq.CompiledQueryCache = Devart.Data.Linq.CompiledQueryCache.RegisterDataContext(GetType(TESTDataContext));
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby Zero-G. » Wed 17 Feb 2010 12:42

Hey

I have to use your product in a productiv environment!
When will the BETA Status be closed and the productiv status reached?

THC
Zero-G.
 
Posts: 390
Joined: Sat 09 Dec 2006 12:20

Postby AndreyR » Wed 17 Feb 2010 15:17

The nearest product is planned to be Beta also.
However, the Beta status is related to the Entity Developer mostly. LINQ code was changed in a negligible extent.
So I recommend you to use the latest version and then upgrade if needed.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to LinqConnect (LINQ to SQL support)