On Tue, 2009-09-08 at 00:43 -0700, chaitanya wrote:
...
> But due to heavy load on database (around 1000 open connections & 1000
> concurrent Queries), i am trying to make my system scalable.
>
> If i change my application to use DBLinq whether it will be able to
> handle this heavy load and whether it has high performance in
> comparison to MySQL .net connector?
I have no idea.
DbLinq, so far, has been implemented to provide sufficient
functionality. Performance and related optimization has been an
afterthought, and (based on previous optimization work done a few months
back) there is likely *tons* that could be done to better
improve...everything.
However, most of Linq-to-SQL is functionality ADDED to e.g.
IDbCommand/etc. -- it's very rarely that Linq-to-SQL would actually
perform faster than hand-writing everything. For example, with .NET
Linq-to-SQL using SQL Server:
http://blogs.msdn.com/ricom/archive/2007/06/22/dlinq-linq-to-sql-performance-part-1.aspx
In particular:
http://blogs.msdn.com/ricom/archive/2007/07/05/dlinq-linq-to-sql-performance-part-4.aspx
shows that, for .NET 3.5 beta 2, a LINQ select is 53.56% as fast as a
by-hand SELECT, while a CompiledQuery LINQ select is 93.06% as fast as a
by-hand SELECT. (Note: DbLinq doesn't currently support CompiledQuery.)
Oddly, updates & inserts were faster (not sure how they managed this,
nor do I know how DbLinq would fare either, as I haven't done such
performance comparisons).
That said, it seems odd that you'd need 1000 connections for 1000
queries. Usually you can have multiple queries for one connection, so
some form of connection pooling should be possible
Realize that DbLinq is not Linq-to-SQL on SQL Server, and thus any SQL
Server performance comparisons aren't entirely valid. I bring them up
because Linq-to-SQL would have had FAR more performance optimization
than DbLinq has had (to date), so if they're slow at something it's
quite likely that DbLinq is slower still, but (again) actual measurement
would be needed to say anything definitive.
- Jon
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DbLinq" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/dblinq?hl=en
-~----------~----~----~----~------~----~------~--~---
