Queries: How many are too many?

[Hummingbird]

How many mysql queries are too many?

I'm working on a RPG but I'm worried that i might have too many mysql queries going on in one page, before I upload it I would like to make a few adjustements if have too many. 7 is the most I have in one file as of right now.

Also, what would you recommend as a good or average number of queries?

Thanks

[Sxooter]

The number of queries isn't nearly as important as how "heavy" they are. If a query is gonna trundle through millions and millions of rows doing complex math, worry about it. If it's gonna grab a row or two of indexed data, don't worry about it.

[MarkR]

It depends entirely on, well, everything including the phase of the moon.

Personally I'd say that once you reach 100 queries, it's beginning to get over the top. but as Scooter says, it depends on how heavy they are.

It also depends on your server architecture- if you're running MySQL locally you can get away with far more queries than if it's going over the network, because the network increases the fixed overhead (latency) per query, no matter how trivial it is.

Mark