2. ASPRunnerPro General questions
  3. MS Access Back End Performance
This topic is locked

MS Access Back End Performance

 		4/3/2009 7:52:21 AM
ASPRunnerPro General questions
B
 bhicks11 author

Does anyone have any comments on using MS Access as an ASPRunner back end as opposed to SQL Server? I am especially interested in comments from any of you that have used Access and how it performed?
Thanks,
Bonnie
Sergey Kornilov admin 4/3/2009

There is no answer if question is asked this way.
It all depends on what kind of data you have, how many concurrent users access your database, how much data is there, is your data normalized, do you have all required indexes in place and so on.
B
 		bhicks11 author 4/4/2009

There is no answer if question is asked this way.

It all depends on what kind of data you have, how many concurrent users access your database, how much data is there, is your data normalized, do you have all required indexes in place and so on.


I was looking for general experiences but here's some details:
I might have 5 to 10 concurrent users.
There might be 100 - 200 records in each table (and I'm estimating on the high side)
Data is normalized.
Indexes: didn't need any. The only filtering is done by log in name.
Thanks,
Bonnie
Sergey Kornilov admin 4/4/2009

Bonnie,
there won't be any difference between MS Access and SQL Server in your case.
B
 		bhicks11 author 4/15/2009

Bonnie,

there won't be any difference between MS Access and SQL Server in your case.


I thought that. Thanks Sergey.