Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

PowWeb and MySQL problems

Jul 3, 2007 3:27AM PDT

I am hosting some web sites on PowWeb. Currently there are often delays for several minutes when accessing MySQL databases. Normal delays are around 0.2 seconds perhaps.

What do you think about a situation like this? What can one do about it?

Discussion is locked

- Collapse -
You are the host?
Jul 3, 2007 5:59AM PDT

Then can you dive into the code and find where it's sluggish?

Or are you not writing code at all?

Bob

- Collapse -
No, PowWeb is the host
Jul 3, 2007 6:57AM PDT

It is a standard web application I am using and nothing I have written myself. There is no problems with the application, it is very common. It is the capacity of the web hotel that is the problem.

- Collapse -
Then a discussion with your host is next.
Jul 3, 2007 7:16AM PDT

Since you don't code the apps it's not for us to fix it. Yes I do write code and some of it involves MySQL so that's why I responded. Since you are not the host or the coder there is nothing for you to do but talk to the right people.

Bob

- Collapse -
It seems hard to reply here
Jul 3, 2007 8:09AM PDT

Bob:
(I have been trying to write this reply several times now, but it does not show up on CNET - I wonder what has happened.)

I am certainly writing code, but not that one.

And (in a reply to your next message) -- I have been talking to them, but it seems hard for them to resolve the problem. I can understand that, but at the same time I do not know what to do. And I have a hard time to understand how they got into the current trouble. I mean I expect them to be specialist in this area, but something seems very wrong.

I hoped to find other people here who had had similar problems. I wanted share experiences and see what one can do.

- Collapse -
Let me share some BAD SQL CODE.
Jul 3, 2007 10:09AM PDT
- Collapse -
Got your email.
Jul 3, 2007 12:03PM PDT

What this has to do with your delays is that simple code mistakes can result in MySQL going off into long lookups. I offered a common foopah in hopes you could research if such is used in your web app.

If you have no access to the MySQL code this may seem meaningless to you.

Bob