newbie question : what count in the query limit ?

[manutoo]

Hello,

there's a 72000 hourly query limit per user.
I'm new to MySQL, and I just finished my 1st PHP script using it.
It works fine (it keeps track of online game hosts), but I wonder with how many hosts it could hit the hourly limit.

I read this forum, and I found that only "SELECT" counts toward this limit, but that some MySQL functions contains implicit SELECT, but I don't know which ones (except one : mysql_insert_id() ).

Mainly, I'm using these ones :
- $Row = mysql_fetch_array($Result, MYSQL_NUM);
- $NbEntry = mysql_numrows($Result);
- $LastTime = mysql_result($Result, $i, "LastTime");
- mysql_query("UNLOCK TABLES");

Is there anyone amongst these that counts toward the limit ?

Thanks for your help !

[pureconcepts]

You can check documentation with www.php.net for the mysql_* functions above that implicitly call SELECT and therefore count towards your query limit.

To my knowledge, none of the functions you listed implicitly call SELECT. Furthermore, I would not worry much about hitting that limit. But I am not sure about the type of web site you run.

[manutoo]

Ok, thanks for the info!

I'll have only a few online games to track, so I should be alright, but I decided to lower a bit the frequency of updates to be sure everything will be ok if my game has more success... :P

[pureconcepts]

Good luck!