| 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.)
| 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
| 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:
.. 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.
| 7:15 pm on Aug 19, 2013 (gmt 0)|
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.
| 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.
| 7:39 pm on Aug 19, 2013 (gmt 0)|
Thank you so much i will post it and try to get some answers :)
| 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.
| 8:09 pm on Aug 19, 2013 (gmt 0)|
Thanks for the info :)
| 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?
| 11:22 pm on Aug 19, 2013 (gmt 0)|
Yeah you are correct. but even large database perform well
| 5:19 am on Aug 21, 2013 (gmt 0)|
Check out this in the Wordpress forum:
An other good resource for you could be the databases forum here at Webmasterworld.
| 5:22 am on Aug 21, 2013 (gmt 0)|
Thanks you, useful information in that :)