If you have a couple of queries in one script you can divide them up on different pages.
I have a page that uses many queries to gather a bunch of stats that are saved for later display. It is not too important that they be noted at exactly the same time so every xxth time (or after a timestamp) 1 of them is updated. The next case to update is saved in the row. Adds a bit of overhead, but I don't have to worry as the db grows and can easily add more cases.
Jeff
