homepage Welcome to WebmasterWorld Guest from 54.163.72.86
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:4603264
 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




msg:4603320
 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:4603324
 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:4603366
 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:4603370
 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




msg:4603375
 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:4603379
 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:4603382
 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:4603386
 8:09 pm on Aug 19, 2013 (gmt 0)

Thanks for the info :)

lucy24




msg:4603402
 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:4603437
 11:22 pm on Aug 19, 2013 (gmt 0)

Yeah you are correct. but even large database perform well

onlineleben




msg:4603758
 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:4603760
 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