The online community for software testing & quality assurance professionals
 
 
Calendar   Today's Topics
Sponsors:
Lost Password?

Home
BetaSoft
Blogs
Jobs
Training
News
Links
Downloads



Software Testing >> Performance & Load Testing

Pages: 1
desmi
Newbie


Reged: 07/16/10
Posts: 2
Performance test for MS-Access app
      #635024 - 07/16/10 02:19 AM

I need to test an application that is created in MS-Access.

The company that uses the application wants to migrate the database from an Access database to MS-SQL database.

I have experience in testing webapplication (with jmeter) but I never tested a Access application.

Does anyone knows a good way to do this?

I came up with 3 ways to do a test:

1. Skip the Access GUI app and just use jmeter to fire database querys at the database

2. Record the network traffic and try to play it back

3. Use several (virtual) machines run the application on all of them and use a Macro to simulate users.


I dont really like these options so I really hope there is a better way.


Maybe its also good to say that this company doesn't have the budget for expensive tools like loadrunner.

Edited by desmi (07/16/10 02:29 AM)


Post Extras: Print Post   Remind Me!   Notify Moderator  
Joe Strazzere
Moderator


Reged: 05/15/00
Posts: 10104
Loc: Massachusetts, USA
Re: Performance test for MS-Access app [Re: desmi]
      #635039 - 07/16/10 03:55 AM

Quote:

I dont really like these options so I really hope there is a better way.




What don't you like?

Knowing that might help others suggest something that more closely fits what you do like.

--------------------
- Joe
I speak only for me. I do not speak for my employer, or for anyone else.

Visit my new blog All Things Quality


Post Extras: Print Post   Remind Me!   Notify Moderator  
James Pulley
Moderator


Reged: 08/01/01
Posts: 4225
Loc: 22031, 28112 & 85711
Re: Performance test for MS-Access app [Re: Joe Strazzere]
      #635044 - 07/16/10 04:30 AM

Don't bother. Your scalability will drop off horribly at six users and end completely by the time you hit ten.

Get a dozen of your friends together and ply them with pizza and beer if you must test an Access based solution for scalability. It's not worth the investment of time and resources to automate a test like this with the scalability of the target so well known.

--------------------
James Pulley

Offsite, fixed price, defined deliverables, LoadRunnerByTheHour. Starting @ $19.95/hr USD.
Flexible Delivery-off-site & on-site, negotiated deliverables, Test Architecture and tools, Professional Services The ScriptFarm

Put us to the test, skilled expertise is less expensive than you might imagine.


Post Extras: Print Post   Remind Me!   Notify Moderator  
desmi
Newbie


Reged: 07/16/10
Posts: 2
Re: Performance test for MS-Access app [Re: Joe Strazzere]
      #635050 - 07/16/10 05:11 AM

Quote:


What don't you like?





I like it if I make a simple testscript that people without much performance testing knowlegde can start and use.

I also like it if al the tests are the same so I can start the test and have a good way to compare different settings/versions etc.


Post Extras: Print Post   Remind Me!   Notify Moderator  
Pages: 1



Extra information
0 registered and 6 anonymous users are browsing this forum.

Moderator:  AJ, RSBarber, rstens, Corey_G 

Print Topic

Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Rating:
Topic views: 443

Rate this topic

Jump to

Contact Us | Privacy statement SQAForums

Powered by UBB.threads™ 6.5.5