On Monday 10 February 2003 01:23, Rich Hutchins wrote:
Beyond inspecting the posted code, are there any quality FREE tools that
can monitor MySQL resource usage? I searched Google using mysql resource
tools and came up with a number of tools, but all required payment.
I'm figuring that if you
On Sat, Feb 08, 2003 at 01:13:28PM -0500, pthes wrote:
Here are some claims from the hosting service:
...
It is exceptionally PHP and MySQL heavy and unfortunately not the kind of
application you can safely run in a shared-hosting environment.
It is never safe to allow customers to upload
Thanks for the comments,. I'm putting some code here to hopefully get an
idea of what is considered inefficient when dealing with mysql. I'm confused
because all I'm doing is collecting the data from a form and writing it to
the db. I have about 30 pages in the survey, so a script similar to this
be able to pinpoint precisely what causes the recources to be chewed
up.
Just a thought.
-Original Message-
From: pthes [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 09, 2003 11:42 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Is my Hosting service full of it?
Thanks for the comments
I had trouble the other day. Ran a survey which generated about 700
responses an hour. It ran fine, then about 90 minutes in everything slowed
up. The hosting service suspended our domain claiming our survey was
overload the server. We had run the survey previously using PERL as the
scripting
Their comments do make sense, and without seeing your code it is
impossible to say whether they are correct or not. They are basically
saying that you have written some very inefficient code. 700 requests an
hour should never come anywhere close to bogging anything down unless you
have
Here's an example of code:
I have multiple page form. When the submit of each page is clicked it calls
a php script that then opens the dbase, checks if the user has already
replied to the page (for those who use the back arrow of the browser),
writes the data, and then calls the next page.
