Number of SQL Queries?

[Qwerty]

How many times does your game run a SQL query on your database?

Mines running about 30, though I'm looking to narrow it down a bit...

[raestlyn]

only 30?
Look at even this pages stats:
Page created in 0.07 seconds with 13 queries.

So your game is running very low number of them. My battle script does about 40 if every condition is met..

[Chris]

2-15 (average is probably 4-7, 15 is on unoptimised low priority communication pages, battle script 11)

[codestryke]

Most pages under 5, battle scripts usually double that depending on the game...

On our game Cypher though that runs a tick every 10 minutes it can sometimes hit up to 300-500  depending on the number of players signed up for missions. Kinda cool to hook up to the mySQL server with there administrator tool and watch the live graphic on the number of queries per second the server is running... That tick hits and WHAM it spikes to the top of the graph.

[Qwerty]

I haven't added a battle script and it isn't tick based. Most of the database queries are for user levels and data, though I made a server side cache so now it rarely goes above 10.