Count statistics of db

[darkmastergyz]

I'm trying to find out the statistics of my dabase:

# of total items
# of unique items from 4 different criterias

When I put that into the queries, using the count function, it works well for 1-2, and then if I add in more into the query, it gives ridiculously high numbers for the counts, and freezes. Am I doing something wrong?

Thanks!

 

[David Eagar]

Check the join criteria in the query, have you got the correct format?

 

[The_Doc_Man]

it gives ridiculously high numbers for the counts, and freezes. Am I doing something wrong?

Probably. I'm going out on a limb but your description triggered a small bubble of a thought in my murky brain.

To find what you want requires a bit of playing around, but find your system's performance monitor that shows CPU and other stats. Start it. Take notes on whatever values it shows you.

Now open your database. Run your query and see if you either are saturating the CPU or some other statistic jumps up really fast and "pegs" at some value.

If it does, you MIGHT have a faulty JOIN query that is doing a permutation join on whatever you are analyzing. Permutation joins build up the number of effective records REALLY fast. You might be thrashing around looking for records to match impossible criteria from a permutation join.

Also, when you run this query, does it cause the database to suddenly become very bloated in size? (If so, that's a temporary table being built in the virtual address space represented by the .MDB file.)

If none of the above seems to apply, then my little percolating bubble in my brain was a brain fart.