Page 1 of 1

Performance issues

Posted: Wed 17 Feb 2010 09:21
by Zero-G.
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

Posted: Wed 17 Feb 2010 12:33
by AndreyR
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));

Posted: Wed 17 Feb 2010 12:42
by Zero-G.
Hey

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

THC

Posted: Wed 17 Feb 2010 15:17
by AndreyR
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.