Welcome to WebmasterWorld Guest from 54.163.52.98

Forum Moderators: phranque

Message Too Old, No Replies

My website response time is very slow

Website loading slow

     

anthonyinit

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

4:33 pm on Aug 19, 2013 (gmt 0)

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



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

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

6:59 pm on Aug 19, 2013 (gmt 0)

5+ Year Member



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

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

7:34 pm on Aug 19, 2013 (gmt 0)

10+ Year Member



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

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

7:51 pm on Aug 19, 2013 (gmt 0)

5+ Year Member



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

8:09 pm on Aug 19, 2013 (gmt 0)



Thanks for the info :)

lucy24

8:39 pm on Aug 19, 2013 (gmt 0)

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



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

11:22 pm on Aug 19, 2013 (gmt 0)



Yeah you are correct. but even large database perform well

onlineleben

5:19 am on Aug 21, 2013 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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

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

anthonyinit

5:22 am on Aug 21, 2013 (gmt 0)



Thanks you, useful information in that :)
 

Featured Threads

Hot Threads This Week

Hot Threads This Month