| switching from Access to SQL |
| Jim Tanner posted at Tuesday, March 22, 2005 4:41 PM |
|
hey
i have an ASP app that has been functional for about 2 years now...... due to overwhelming traffic to the site (50,000 hits / day), we've noticed that our DB connection has been flaking out sometimes... (errors about file in use / unspecified errors when trying to cnonect)
so, we thought maybe switching the DB from Access to SQL Server may clear up this problem.
is SQL Server more tolerant of multiple concurrant connections? obviously, about 95% of the SQL syntax will be the same...... do you forsee any problems switchin from access to sql? |
| Reply Reply Using Power Editor |
| |
| |
Rank |
Winnings |
Points |
| November |
0 |
$0.00 |
0 |
| October |
0 |
$0.00 |
0 |
|
|
|
|
|
|
|
| Access was never designed |
| Peter Bromberg replied on Tuesday, March 22, 2005 4:58 PM |
|
to handle a large number of concurrent connections. It is a file-based database.
Sql Server is a service, it is a broker-based database. Sql Server is designed to handle a large number of concurrent jobs efficiently.
You should not have any problems. You may have some work ahead writing stored procedures from your Access queries (the syntax can be somewhat different), but it will be good practice. |
| Reply Reply Using Power Editor |
| Peter Bromberg is a C# MVP, MCP, and .NET expert who has worked in banking, financial and telephony for over 20 years. Pete focuses exclusively on the .NET Platform, and currently develops SOA and other .NET applications for a Fortune 500 clientele. Peter enjoys producing digital photo collage with Maya,playing jazz flute, the beach, and fine wines. You can view Peter's UnBlog and IttyUrl sites.
Please post questions at forums, not via email! |  |
|
| |
Rank |
Winnings |
Points |
| November |
0 |
$0.00 |
0 |
| October |
0 |
$0.00 |
0 |
|
|
|
|
|
|
| Datatype Conversion |
| Eddie Molieri replied on Tuesday, March 22, 2005 5:05 PM |
|
You should be aware of some datatype conversions. Not too much of a problem though. |
| Reply Reply Using Power Editor |
|
.c0 { margin-left:0pt;margin-top:0pt;margin-right:0pt;margin-bottom:7.5pt; }
.c1 { background-color:Yellow;color:Black;font-weight:bold; }
testing the html editor |
| |
Rank |
Winnings |
Points |
| November |
0 |
$0.00 |
0 |
| October |
0 |
$0.00 |
0 |
|
|
|
|
|
|
|
|