|
|
Posted by ~=_Slawek_=~ on 02/18/06 17:31
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
Navigation:
[Reply to this message]
|