lark

I think for now I just want to monitor gross traffic in and out of the databases -- so purely just the number of queries... then focus on how efficient and time-consuming the queries are later. Fenway, what's the best way to insert "timing breakpoints" Thanks for your help!

Hi everyone, I'm looking for a way to monitor queries to my databases. I'd like to optimize my code to minimize the load to my databases, but I currently have no way of telling when I'm making improvements. I'm on a managed server, so don't have root access to error logs etc. Is there a simple way to do this? I considered making a function called query_count() for example, which would replace all of my mysql_query calls and track each query, but I hate to load the databases down with even more queries just to find out what the traffic is. Any suggestions would be greatly appreciated. Thanks!

Any thoughts on this one?

It doesn't die. If you go back to the domain you logged in from, the session is still there. It just doesn't communicate between mydomain.com and www.mydomain.com

I have a site that uses sessions for user logins. It works fine as long as the user stays in the domain from which they logged in. But if they switch at some point between just the domain mydomain.com to www.mydomain.com (or vice-versa), the session is lost. Is there a workaround for this? Thanks!

I'm just learning how to do joins but am having trouble with this. I have two tables like this: Table A Title........ Category Thing 1.........5 Thing 2.........5 Thing 3..........6 Thing 4........12 Table B Category........Order 5....................13 6.....................20 12....................1 And I want to write a query that gives me this: Title..............Category.........Order Thing 1...........5....................13 Thing 2...........5.....................13 Thing 3...........6.....................20 Thing 4..........12.....................1 So each thing has a category. Each category has an order associated with it. I'd like to know the order of each thing based on its category. Make sense? Thanks for your help!