Do I really need all of these queries ????

[Zorkmid]

Hi there,

I have a TON of queries in my database, and I'm not sure if I need them all, they seem to be slowing my DB down alot. The Db only has one table, which keeps tracks of incidents and all their details (location, date etc.). I want to report back to the managers of the locations with summaries of the collected data.

I have a select query based on a main query, for each location.

I have 2 crosstab queries for each location query, one which breaks the data down by type, and another by degree of injury.

Is there a better way to do this?

-Z

P.S. I built the DB a long time ago and I now realize that the table structure isn't sound the way it is, but I can't change that right now.

 

[georgedwilkinson]

The number of queries in a database wouldn't normally cause the database to slow down.

I would guess that the problem is with your table structure. Single table solutions can get notoriously slow.

Give us more information and perhaps we can narrow it down a little more.

 

[Kryst51]

Have you thought about using the tables analyzer? I have used it once or twice, and it works fairly well, and quickly once you get used to it.