k4pil

hi ppl!

Not sure if its in right the place, but here it goes.

I am trying to do some resarch on different types of databases, e.g. Spatial, temporal, relational etc.

I want to compare the performance of these different types of databases when implementing different types of applications, e.g. CRM, financial data tracking etc.

However, i have no idea where to start. Anyone with any suggestion

Thanks in advance

Darkhack

Most of my database expierence is with web development although I think I can help somewhat. I know phpmyadmin displays a timer telling how long a paticular query or series of queries took to accomplish. I also know that you can setup a database and then write your own program that will perform some queries and have a timer in the background that will start/stop and report back how long each query took. Your results may vary a lot and since I am just an amature (sp?), I don't know if this is the best/most accurate way of doing this. I know MySQL for example has an "EXPLAIN" statement which will report back statistics on queries. As for your implementation (financial, ect) I don't know how else to go about calculating performance for paticular applications other than writing one your self. Or atleast something that would simulate it. Hopefully someone with more expierence than myself can provide a follow up.

k4pil

Thanks darkhack.

But, I don't want/need to develop a system which analyses performance. I want to be able to analyse how effecient different types of databases are by maybe looking at existing papers or other sources.

Hope this makes sense