Performance issues

Zero-G. · Post by **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

AndreyR · Post by **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));

Zero-G. · Post by **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

AndreyR · Post by **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.