Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have an application that i can configure to get data from different kind of SQL database server, for example Postgres, MSSQL, MySQL, Firebird ...

I must install this application and the database server on windows enviroment, before choice the database server i need to do some benchmarking test to this database importend in all of the supported type of database server for define what's the best choice.

I'm writing a perl script for this job: for test writing and reading speed from this database.

What kind of test i should do to really compare what's the best database server for my app ?

share|improve this question
    
Well you should check what the most used queries your program will be using and make a code to iterate with it and see how it goes, how long each takes to proccess and so forth. –  Prix Aug 19 '10 at 7:55
add comment

2 Answers

up vote 1 down vote accepted

The best test, and the only one that is at all meaningful, is to use it exactly as you would in a production environment. Testing it any other way may give completely different and irrelevant results, so write your test script accordingly.

share|improve this answer
add comment

I agree with John Gardeniers - but in order to actually measure the performance effectively you need to look at the transaction times for a simulated workload at the HTTP level - note that the "standard" log formats only provide integer response times - so you'll need to do some tweaking. Also you need to test out how the system behaves with varying levels of load (running single operations on isolation does not reflect what happens when you've got lots of other stuff happenning - speed <> scalability).

C.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.