[swiper]

Based on my experience this will absolutely help any pligg site - the more stories you have the more it will help. Yes it makes the index file bigger but the significantly faster selects will outweigh the slightly slower inserts and updates. But I'm no expert and so we can wait to see what else AshDigg comes up with.

[joehunk]

Is this something I need to implement now on my pligg site. My site http://ebenta.com now reached 1000+ stories and it is now starting to load so slow compare to its normal load 2 weeks ago. I beginning to suspect it was the server (host - GoDaddy) but I have no clue yet. The last thing I remember is I enabled Free sites statistics on the control panel and the site started to load slowly.

Please confirm so I can implement this tip. Thanks, swiper for this tip. Is enabling gzip will help performance as well? I read on some post and they said it adds performance on the load. I haven't implemented any tip yet so I can't comment this time. If anyone can shed us some light on this slowness issue on pligg please let us know.

Thank you.

[dollars5]

I think you need to move to a dedicated machine too if you start to get more traffic.

[swiper]

Joe, it only takes 5 seconds to add an index to your table (assuming you know how to do so). Just try it out and see - you'll instantly know if it speeds things up for you or not. You can always drop the index 2 seconds later. It's no big thing.

[ramesh123]

nice post.........................................

[joehunk]

swiper, i implemented the index tip but no luck on performance. i got the same result - still very slow. i upgraded my hosting account to a dedicated ip and i will see how this step affect the performance of the site. i think the best solution is what dollars5 said - go with a dedicated server hosting. for now, my site is not getting much traffic so, i will reserve this next step when it is the right time to move to dedicated machine.

for others who experienced the same slowness on your pligg site when reaching 1000+ stories and account is hosted via a shared account and came up with a better solution, please share with us.

my site is hosted via a shared hosting account, and running on pligg 9.7. working fine for the first 3 months, when reached 1000+ stories started to slow and most of the times can't load the homepage or upcoming. other than this, story page loads fine (a little bit slow) as well as other pages that doesn't query the database.

i will posted what will be the result of upgrading to a dedicated ip in a couple days.

[Rodney]

i upgraded my hosting account to a dedicated ip and i will see how this step affect the performance of the site

I don't think a dedicated IP will help in performance at all.

[dollars5]

I think he refers to dedicated hosting - that surely would help in performance improvement. Just taking a dedicating IP will not help in any manner.

[VLJ]

Originally Posted by swiper

nothingman - To add the index just issue the following in mysql (via your servers admin panel, SSH, etc):

alter table pligg_links add index(link_status);

I'd like to hear an "official" yes or no from the wonderful Pligg dev team on if the mysql command swiper posted is recommended.

[joehunk]

ok, here is the updates on my site.

I know that getting a dedicated IP does not improved performance ... but guess what? my site improves for doing so. It still hosted on a shared server on GoDaddy (dedicated hosting starts @ a high $$$ they have virtual dedicated @ $29.99) ...but this will be my next option. The sites is now loaded back to normal speed. I still have the tip from @swiper implemented but not sure if it helps, until we confirmed from Pligg devs.

I am on 1300+ stories now and going....