Complex queries to test performance

[TartanRug]

Hi

I need to test the performance of a database with some complex sql queries. Being a relative novice in SQL I'm not sure what the best queries would be to run.

I would be very grateful if anyone could give me a set of sql queries of varying complexity (but mainly more complex queries using more than one table) which would be a good test of a databases performance.

Thanks in advance

 

[JarlH]

Why do you need to test database performance?

There's no complex sql query which will give you the answer that the xyz product is the best one for you. Different database contents/queries may work faster/slower on different dbms products, depending on concurrent users, load, hardware etc.

 

[TartanRug]

I actually need to test the performance of a data driver and have been asked to write some complex SQL queries to test this. We are sending data from an Informix database to a product called Streamserve.

Sorry if I am sounding a bit vague about this but it's all new to me at the moment!

I would be grateful for any complex SQL queries which could test this performance

Thanks

 

[r937]

i'll give you a great example of a complex query: how many friends, friends of friends, friends of friends of friends, etc. does todd have?

r937.com | rudy.ca