Re: how do you handle multiple update request on the database?
- From: "Nicholas Paldino [.NET/C# MVP]" <mvp@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 19 Mar 2007 18:58:59 -0400
I made the assumption that the OP was using an RDBMS like SQL Server,
but the statement applies for any RDBMS. It will handle multiple update
requests that come in at the same time to the server. Things such as
Access, FoxPro, Excel etc, etc, have to be handled differently, as they do
not scale well when hit with many requests at the same time (the
drivers/providers just aren't up for it).
If the OP was using Oracle, mySql, the same applies.
Any database will handle #2 fine. The OP wasn't clear about how he
wants sequential statements handled. If a database couldn't handle
sequential statements, then I would be pretty wary of it, wouldn't you?
He/she didn't mention if he wanted it in a transaction or not, but from the
original post, my impression was that the OP was concerned about the
database handling that many updates/requests at a time.
--
- Nicholas Paldino [.NET/C# MVP]
- mvp@xxxxxxxxxxxxxxxxxxxxxxxxxxx
"Arne Vajhøj" <arne@xxxxxxxxxx> wrote in message
news:45ff06b4$0$90262$14726298@xxxxxxxxxxxxxxxxxx
Nicholas Paldino [.NET/C# MVP] wrote:
This depends on the database that you are using. If it is SQL
server, then I would just set connection pooling on for your app, and
then just make the requests as they come in. SQL Server will handle the
concurrency issues (as far as updating the same tables at the same time,
but not making sure that changes don't overwrite each other, that's up to
you).
There are two aspects of the subject:
1) 2+ requests with 1 SQL statement each
2) 2+ requests with 2+ SQL statements each
#1 is handled fine by all databases I know about out of the box.
#2 is not not generally handled by any database I know of. Depending
on the SQL statements various solution exists (often involving
a high transaction isolation level).
I do not see SQLServer as being special.
Arne
.
- Follow-Ups:
- Re: how do you handle multiple update request on the database?
- From: Arne Vajhøj
- Re: how do you handle multiple update request on the database?
- References:
- how do you handle multiple update request on the database?
- From: AboutJAV
- Re: how do you handle multiple update request on the database?
- From: Nicholas Paldino [.NET/C# MVP]
- Re: how do you handle multiple update request on the database?
- From: Arne Vajhøj
- how do you handle multiple update request on the database?
- Prev by Date: Re: Threading question (newbie)
- Next by Date: Re: Saving Windows Media Video files
- Previous by thread: Re: how do you handle multiple update request on the database?
- Next by thread: Re: how do you handle multiple update request on the database?
- Index(es):
Relevant Pages
|
