homepage Welcome to WebmasterWorld Guest from 54.145.183.190
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / WebmasterWorld / Webmaster General
Forum Library, Charter, Moderators: phranque

Webmaster General Forum

    
My website response time is very slow
Website loading slow
anthonyinit



 
Msg#: 4603262 posted 1:33 pm on Aug 19, 2013 (gmt 0)

Hello,
This is my 1st post and i'm new here :)

My website response time is very slow only the main page take about 4-5 sec. when i browse the url it keeps pending for 3-5 sec before it shows transferring..... etc..

i chek with website speed test tools everything looks good except for main page. please check my image

[ultraimg.com...]

Thank you

 

lucy24

WebmasterWorld Senior Member lucy24 us a WebmasterWorld Top Contributor of All Time Top Contributors Of The Month



 
Msg#: 4603262 posted 4:33 pm on Aug 19, 2013 (gmt 0)

Is 8.4K the size of the entire page with all supporting files, or just the html? Obviously it's not a size problem.

If the delay happens before the page even starts loading, then frankly it may be a hosting problem. (I looked up one name the other day and learned that 548 sites share the same server. 548! Holy ###. Even my own site only admits to 90.)

anthonyinit



 
Msg#: 4603262 posted 4:45 pm on Aug 19, 2013 (gmt 0)

Actually that is the main page size, i have a database size 1.9GB and one table have 40000+ news i guess that table is causing problem, maybe index issue

brokaddr



 
Msg#: 4603262 posted 6:59 pm on Aug 19, 2013 (gmt 0)

Check the indexes.

The bigger the database, the more overhead is used during queries. So if your code is something like:
http://example.com/page.php?page_id=21
.. then you'd want to make sure whatever 'page_id' uses from your database is an index.

As well as any other large tables. (Most commonly, 'id' is the primary call, so make sure 'id' is an index)


Additionally, do you optimize the database regularly? If no, you need to optimize periodically to clear out the clutter. (If you use phpmyadmin, there's an easy "select all" option with a pull-down for optimize right beside it).


Do a ping/tracert and see what your response time is like, if it's greater than 70-80ms consistently, contact your host and give them a copy of the ping/tracert.

If all that fails, then consider building a cache for your most intensive queries.

anthonyinit



 
Msg#: 4603262 posted 7:15 pm on Aug 19, 2013 (gmt 0)

Great,
Honestly i have removed the index and reindex them in phpmyadmin, pig response time is less than 60-50ms but still i have this issue, regarding your last option any tips on how to do that :)

i'm not a newbie so i have only little knowledge :)

Thank you so much for your time.

mromero

10+ Year Member



 
Msg#: 4603262 posted 7:34 pm on Aug 19, 2013 (gmt 0)

There are so many variables such as who is your host, what CMS you are using, what scripts are loading and in what order, if database is on its own box etc. etc. - it would be impossible to say.

Post it on the Webmaster World Supporters Section and you should get a clearer picture I think.

anthonyinit



 
Msg#: 4603262 posted 7:39 pm on Aug 19, 2013 (gmt 0)

Great,
Thank you so much i will post it and try to get some answers :)

brokaddr



 
Msg#: 4603262 posted 7:51 pm on Aug 19, 2013 (gmt 0)

regarding your last option any tips on how to do that

Not something you would want to attempt to do unless you have experience programming.

If you are using a CMS like Wordpress or Joomla, they probably have caching plugins you could use.

anthonyinit



 
Msg#: 4603262 posted 8:09 pm on Aug 19, 2013 (gmt 0)

Thanks for the info :)

lucy24

WebmasterWorld Senior Member lucy24 us a WebmasterWorld Top Contributor of All Time Top Contributors Of The Month



 
Msg#: 4603262 posted 8:39 pm on Aug 19, 2013 (gmt 0)

i have a database size 1.9GB

Ouch! Well, that changes the whole picture. Does every page have to read through the entire database on every request? How often, if at all, does content change? How many variables are involved? Can you build pages on your own time and cache them for immediate access?

anthonyinit



 
Msg#: 4603262 posted 11:22 pm on Aug 19, 2013 (gmt 0)

Yeah you are correct. but even large database perform well

onlineleben

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 4603262 posted 5:19 am on Aug 21, 2013 (gmt 0)

Check out this in the Wordpress forum:
[webmasterworld.com...]

An other good resource for you could be the databases forum here at Webmasterworld.

anthonyinit



 
Msg#: 4603262 posted 5:22 am on Aug 21, 2013 (gmt 0)

Thanks you, useful information in that :)

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / WebmasterWorld / Webmaster General
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved