ita, I'd be the first to volunteer had I any idea what's going on. I'm even working all nights all weekend and will be bored.
There's more than one way to skin a cat. And I happen to know that's factually true.
Mayor ,'Lies My Parents Told Me'
Buffistas Building a Better Board
Do you have problems, concerns or recommendations about the technical side of the Phoenix? Air them here. Compliments also welcome.
Elena - Aug 01, 2003 10:44:05 am PDT #4455 of 10000
Thanks for all the fish.
Jessica - Aug 01, 2003 10:46:21 am PDT #4456 of 10000
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
ita, I'd be more than happy to help out in any way I can -- I haven't a clue if my PHP/MySQL skills are up to where I'd understand the Phoenix code if I saw it, but I can certainly try.
Tom Scola - Aug 01, 2003 10:47:33 am PDT #4457 of 10000
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.
Perhaps fangeek can turn on mysqld logging (for a short period of time) so that we can get a handle on what's happening?
DXMachina - Aug 01, 2003 10:48:14 am PDT #4458 of 10000
You always do this. We get tipsy, and you take advantage of my love of the scientific method.
IH informs me that, while they did not anticipate any problems with the site, they simply weren't expecting "over 200 concurrent mysql connections at the same time". They had no way of predicting that. They informed us that we are the reason the server has been so slow of late. They also suggested that we modify our code, as they believe the script we're using is the problem.
IH mentions that they think if we "optimize the database queries" that will help a lot. It isn't our bandwidth usage that is the issue, it's our resource usage.
I gotta say that IH actually giving us a clue as to what's happening is much better than the way HR just kept telling us "You should have fixed your code."
Liese S. - Aug 01, 2003 10:59:41 am PDT #4459 of 10000
"Faded like the lilac, he thought."
Hey, I'm where Jess is. I've been out of the programming loop for a while so I dunno if I'd be any help, but sql used to be my baby, so I'd be happy to at least look it over. I'm limited as to my online time, but if I could look at the code offline I'd have a fair whack of time this weekend to do it up. Let me know how to do whatever I gotta do. Like I said, I dunno if I'm up to scratch but I'd be glad to be extra eyes and hands.
§ ita § - Aug 01, 2003 11:14:59 am PDT #4460 of 10000
Well not canonically, no, but this is transformative fiction.
I have an ERD lying around here somewhere. I'll make sure it's up to date, and then outline the queries involved in each transaction.
I think that's simpler than learning to read the code.
Kristen - Aug 01, 2003 11:17:48 am PDT #4461 of 10000
Sorry, I had to run off and do work for the people who write my paychecks.
Perhaps fangeek can turn on mysqld logging (for a short period of time) so that we can get a handle on what's happening?
I have asked this question. Will let you know what I hear.
§ ita § - Aug 01, 2003 11:24:56 am PDT #4462 of 10000
Well not canonically, no, but this is transformative fiction.
DX -- I've taken off Natter 9 and Bitches 1. I didn't miss any, did I?
DXMachina - Aug 01, 2003 11:32:03 am PDT #4463 of 10000
You always do this. We get tipsy, and you take advantage of my love of the scientific method.
Nope. I've been working on Bitches 2, but it won't be ready for a couple of hours.
§ ita § - Aug 01, 2003 11:34:36 am PDT #4464 of 10000
Well not canonically, no, but this is transformative fiction.
When you're done, just mark it "archived", and I'll check for that periodically and delete any then.