MySQL Forums
Forum List  »  InnoDB

Re: Server going away after a few seconds
Posted by: David Wright
Date: April 10, 2016 06:30AM

Peter Brawley Wrote:
-------------------------------------------------------
> So the table is to have a lot of approximate,
> largely unqueryable information.
There are only 2 reasons for this data to be queried.
1) To allow updates on individuals.
2) To populate HTML formatted pages containing all or
subsets of the data to the website visitors, all of whom
are classmates.

>
> The MySQL database is on Hostmonster, and you're
> running MySQL WorkBench from Windows 8,1 on a
> local PC? I'd expect that to be slow to very slow
> depending on your ISP connection speed and the
> bandwidth that Hostmonster is offering for this
> remote database connection.

Well, the other website I maintain on Hostmonster
is extremely fast, although there are only 500 records
and they are provided from a phpBB3 installation,
but the difference in speed between the two is
roughly 50-1. (Unless I use the work-a-round, that
I discovered. See Below.)

>
> Is there some reason you're not running phpMyAdmin
> from Hostmonster?

Yes, compared with WB, myPhpAdmin sucks and takes me
4 or 5 times longer to work with when entering new records
or updating them.

If anyone has any other suggestions, I'd be happy to
hear them, but since I appear to be able to work
around the timing problems by limiting the first
query to around 500 records. I'll keep on doing that.
(Recall that I posted that if I am careful about
the timing of the first query and limit it, then
subsequent queries are extremely fast and are not
limited by the number of records.
However, the server will go away if I pause too long
between transactions.)

BTW, The program is NOT generating a new code when a bad one is entered
which has happened almost every time that I posted. Many of the characters
are totally unreadable. This post I had to cut, cancel and paste and reply again to the post I was trying to answer.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Server going away after a few seconds
530
April 10, 2016 06:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.