I don't think that Linq for DataSets is going to help you here, due to
what I believe (based on what you said) the frequently changing content of
the tables. If you load the database into memory, you still will have to
persist the changes to the dataset in memory back to the database, and at
the least, you are going to have the same overhead on update operations that
you would have if you were just using the database.
On the select side, you might get a performance increase, but honestly,
with that many concurrent users, you will have to manage the concurrency to
updating and selecting that data which to me seems like a database is much
better suited for.
I think that you should take a look at how you are querying the database
and see what optimizations you can make there. You would be surprized at
the kinds of optimizations you can make using indexes, stored procedures,
changing the logic in queries, etc, etc.
--
- Nicholas Paldino [.NET/C# MVP]
-
mv*@spam.guard.caspershouse.com
"Wilson C.K. Ng" <Wi********@discussions.microsoft.comwrote in message
news:40**********************************@microsof t.com...
Thanks experts, let me tell more about the story.
Scenarios:
There are a few (one or two) tables storing some information of servers
(ip,
name, other fields).
The system allows other users add/remove/search by keywords for the
table(s).
It is estimated that there would be 50K concurrency users.
The content of table(s) is changing while the total size of table is
always
within 250MB (when we store it in SQL Server).
Background:
Our previous project is to use SQL Server05 while the bottomneck is at the
ORM stuff in connecting to SQL Server. So, I would like to investigate if
it
is in the case of in-memory db.
And I would like to ask about performance, Concurrency Issues & Memory
Management of LINQ over SQL/DataSet.
Many Thanks.
"Laura T." wrote:
>Hard to say much without knowing the underying data and it's
organization.
For 50k and more users (concurrent=resource consuming?), the overall
architecture becomes quite critical.
Some, hopefully, useful pointers:
http://blogs.msdn.com/wriju/archive/...rformance.aspx
http://www.davepeck.org/oldessay/lin...tion-perf.html
http://www.bluebytesoftware.com/blog...b90c6442b.aspx
"Wilson C.K. Ng" <Wi********@discussions.microsoft.comha scritto nel
messaggio news:78**********************************@microsof t.com...
Hi Experts,
I am doing a prototype of providing data access (read, write & search)
through Web Service. We observed that the data storing in SQL Server
2005,
the memory size is always within 250MB. Our aim is to support ~50K
concurrency users.
After investigation, we are thinking to use In-memory database for
achieving
higher goal. One of choices to use LINQ as data structure while I would
like
to ask some considerations in the meanwhile.
- How is the performance, Concurrency Issues & Memory Management using
LINQ
over Dataset and SQL server ?
Many Thanks.