|
| |
|
|
Eli
Posts: 2659
From: ... er ...
Status: offline
 |
MS SQL vs Access - 5/9/2003 7:43:30
ok - i' m looking at trying out MS SQL with a new server I' m looking at. I understand that this type of databse can handle more concurrent users that Access (?).
Can anyone give me some pros and cons about switching?
Many Thanks
_____________________________
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning
|
|
|
|
Jim McShane
Posts: 48
Joined: 8/13/2002
Status: offline
|
RE: MS SQL vs Access - 5/9/2003 8:08:10
hi micah,
yes SQL can defiatly handle more users and requires less maintinence that access databases ... for example my company recently (about 9 months ago) upgraded our system software to a windows version (from dos ) :) our database was converted to access first and was about 400MB.... we only have about 10 concurrent users... but were experiencing performance problems with access.. we upgraded to MS SQL about 3 months later and performance greatly improved...
also with sql once you configure the server you dont have to worry about compacting and repairing the database as you do with access overtime..
another benifit is the way sql is sturctured ... say your server crashes, for some reson :( , at 2:00PM , you could lose all days trasactions with access via last nights tape backup... with sql transactions are backed up every few hours ( 2 hours in our case) and if server were to crash ... you could restore from tape back up and bring the database as current as a 2 hrs since crash
overall there are a lot of benifits to using SQL over access ... one dowbside of SQL is cost ... but it well worth it for all the features mentioned here..
-jim
| |
|
|
|
Eli
Posts: 2659
From: ... er ...
Status: offline
|
RE: MS SQL vs Access - 5/9/2003 8:18:49
Thanks Jim - what is an sql database costing you?
_____________________________
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning
| |
|
|
|
Jim McShane
Posts: 48
Joined: 8/13/2002
Status: offline
|
RE: MS SQL vs Access - 5/9/2003 8:22:42
can u tell me about you system configuration a little more and what you are planning on using SQL server for???
-jim
| |
|
|
|
Eli
Posts: 2659
From: ... er ...
Status: offline
|
RE: MS SQL vs Access - 5/9/2003 8:43:40
sure - checkout
www.leisure-ideas.com/
It' s a popular site but you' ll find it VERY slow. My main purpose is to speed it up.
My new hosting package has the following:
1Gb space
all the regulars stuff ... FTP, email, virus scanning, asp.net etc etc.
Unlimited bandwidth with multiple server load-balance
they' re saying that to have an sql server option will cost £400 per year
< Message edited by micah -- 5/9/2003 8:46 AM >
_____________________________
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning
| |
|
|
|
Jim McShane
Posts: 48
Joined: 8/13/2002
Status: offline
|
RE: MS SQL vs Access - 5/9/2003 8:50:36
the reason i ask is costs to run server depend on OS and hat you plan on using for... also it is recommended to have a seperate server just for SQL .. so that costed us 7K but since we bought win2K small business server OS SQL server came with it...
our costs:
new server
7,000.00
pentium xeon processor
1 mirrored disk (2 HD) -program and logs
RAID-5 (3HD) hot swappable -sql database
SQL server software -included in win2k SBS
-SQL server CALS i can' t remember but i believe thay were also included in SBS
so depening on your server OS, and how many internal users... im not sure if there is additional cost if you are using SQL for website database... im more farmiliar with internal client/server arch for our companys system software...
| |
|
|
|
Jim McShane
Posts: 48
Joined: 8/13/2002
Status: offline
|
RE: MS SQL vs Access - 5/9/2003 8:52:56
ok thats what i thought... using for web and not setting up your own:) in your case costs aren' t too bad... how big is database and how many ppl are concurrently using it???
-jim
| |
|
|
|
Eli
Posts: 2659
From: ... er ...
Status: offline
|
RE: MS SQL vs Access - 5/9/2003 9:06:41
database is only 21MB. Not sure how to calculate concurrent users. I' m assuming that this is the problem because of the speed of the site. When the site is using simple asp without using the database all is well.
_____________________________
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning
| |
|
|
|
Jim McShane
Posts: 48
Joined: 8/13/2002
Status: offline
|
RE: MS SQL vs Access - 5/9/2003 9:18:40
in your case i woudn' t go to SQL with only 21 MB of data there has to be something else causeing the slow performance.. i went on your site and spped wasn' t to bad... i have DSL though so i dont know how long it takes on slower connection. who is your web host? what do u use to track webtraffic? i use webtrends and you can view when users are on during what times and how many...this could help with finding out how many users are on concurrently.
-jim
| |
|
|
|
Eli
Posts: 2659
From: ... er ...
Status: offline
|
RE: MS SQL vs Access - 5/9/2003 9:26:45
i have a number of sites with the same co. and they are all slow when querying the db. (i' ' ve sent you an IM with their name).
I' m using Statistics Server 5.03 from Media House - it doesn' t seem to give that option.
_____________________________
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
