|
|
Posted by Jerry Stuckle on 02/18/06 19:35
'~=_Slawek_=~' wrote:
> Maybe you have some suggestions what host should I try? My hosting is very
> good (cpanel, unlimited ftp, mail, domains, awstat, server logs, custom
> error pages, directory protection, installed nearly all PHP extensions, 6
> postgre + mysql database without limits, 10 GIG month transfer, 2GIG on disk
> for only $35 yearly).
>
> @Alex:
> Yes i wrote its overloaded. Sometimes there is 10MBytes of data/sec taken
> from DB (probably some site written badly).
>
> I just taken some stats, the question is: should i change hosting. I mean I
> only updated 25 X 4-byte fields that are not primary indexes and delay is
> IMO huge (but im new to DB optimisation so I can be wrong). How slow itll
> get when i finally have 2000 records table (its my destination, not much
> IMO).
>
> I guess that after 4'th update my table finally all go to cache the >WHOLE<
> 25 rows >LOL<.
>
> /*[23:22:21][ 344 ms]*/ UPDATE liczniki SET value=1
> /*(25 row(s) affected)*/
> /*[23:22:21][ 406 ms]*/ UPDATE liczniki SET value=1
> /*[23:22:22][ 609 ms]*/ UPDATE liczniki SET value=1
> /*[23:22:22][ 219 ms]*/ UPDATE liczniki SET value=1
> /*[23:22:22][ 63 ms]*/ UPDATE liczniki SET value=1
> /*[23:22:22][ 62 ms]*/ UPDATE liczniki SET value=1
> /*[23:22:22][ 63 ms]*/ UPDATE liczniki SET value=1
> /*[23:22:22][ 47 ms]*/ UPDATE liczniki SET value=1
> /*[23:22:22][ 47 ms]*/ UPDATE liczniki SET value=1
> /*[23:22:22][ 63 ms]*/ UPDATE liczniki SET value=1
>
>
>
Well, you also get what you pay for. Hosting companies have to pay for
the servers, connections to the world, electricity, personnel, etc.
If they're going to charge a cheap price, they have to put a lot of
people on a server. And if your server is being overloaded by another
user (or multiple users), there's not much you can do about it.
You can request a different server from your host. If they move you,
you might or might not get better response. Or you can find another
hosting company. Again, if you go with a $35/yr hosting company you may
or may not get better response.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|