Wednesday, August 12, 2009

Performance Issues Resolved

Recently i notice that page loading were getting slower and slower (up to 5 seconds for a page to load during peak hours). When checking the server logs I did not notice any high CPU usage. When coming back from lunch today, I realize that I have done zero optimization to my database. Database optimization is not a big deal when your are only dealing with a couple hundred rows of data, but when you get into the thousands you start to see a degrade in performance.

I have done some simple optimization to the myVidster's mySQL tables. Simple stuff like adding indexs and running the OPTIMIZE command on the tables. I also setup a nightly cron job to optimize my index files for video searching (Zend Lucene).

The final result was page load times and search gain a 2x to 3x boost! Hopefully the performance issues did not cause me to lose any users.

47 comments:

JANA GANGA said...

Life Coach in Chennai

Oliver Maurice said...

You definitely need to read this article about yahoo messenger spy applications to get all the news about the subject and spy applications in general

TAMILSTATUS said...

Hello there. I found your web site by the use of Google at the same time as searching for a comparable subject, your site came up. It seems great. I have bookmarked it in my google bookmarks to come back then.

Telugu Status
Telugu Whatsapp Video Status
WhatsApp Video Status in Telugu
Telugu Status Video
Telugu Status Video Songs Download
Telugu Status Video Songs Download
Malayalam Status Video Songs Download

Madoo said...

This is really an amazing and thank you so much for sharing

คาสิโนออนไลน์ที่น่าเชื่อถือและมีความเป็นมืออาชีพที่สุดในตอนนี้
โปรโมชั่นGclub ของทางทีมงานตอนนี้แจกฟรีโบนัส 50%
เพียงแค่คุณสมัคร สล็อตออนไลน์ กับทางทีมงานของเราเพียงเท่านั้น
ร่วมมาเป็นส่วนหนึ่งกับเว็บไซต์คาสิโนออนไลน์ของเราได้เลยค่ะ
สมัครสล็อตออนไลน์ >>> Goldenslot
สนใจร่วมสนุกกับ คาสิโนออนไลน์ คลิ๊กได้เลย
มีทั้งคาสิโนออนไลน์ หวยออนไลน์ ฟุตบอลออนไลน์ สล็อตออนไลน์ และอื่นๆอีกมากมาย

Linda said...

great article, I was very impressed about it, wish you would have stayed next share
cool math games fireboy and watergirl

webnovel said...

I feel sorry for not knowing this sooner, thank you for sharing with us!

Geek squad said...

I found this is very interesting and good. Finally, I resolved the issue very fast and good way. If you face any issue related to any electronic devices then visit our website Geek Squad Support

Intuit said...

Great article. Intuit provides you various accounting software for small businesses and offers on-premises accounting applications and cloud-based services also. In case of any help to buy any software for your business then visit intuit customer service.

Ryan Weston said...

Very good write-up. I certainly love this website. Thanks! iMessage on PC

arianapham said...

Thank you for sharing this information. Love your blog posts. Please keep updating. You can also visit our website to play blog post y8 game full of fun.

Oliver john said...

promo codes for roblox it is the great experience for you in gaming.

peter said...

the information which you shared in your article is quite impressive and it helps while developing. keep sharing such kind of article with us. mcafee.com/activate

Twin said...

keep sharing this type of information if you are facing any kind of issue while using norton setup then you can simply visit our website our technical assistant assist you the same we are 24*7 available for our users.

peter said...


if you are looking for antivirus then we suggest you download Mcafee activate for total protection. if you had a premium version of mcafee.com/activate
and face any kind of technical error then you can visit our website.

mcafee free trial said...

Mcafee security is an antivirus that is most commonly used, it is the most popular and the best antivirus, it is an antivirus that has been used since the first appearance of the virus. McAfee offers a full range of security products such as antivirus, firewall and anti-spyware programs that provide us protection against viruses, threats and malware

file said...
This comment has been removed by the author.
open acsm file said...

I love to read this information.
thanks

pdf file said...

I appreciate your efforts, keep sharing with us

sam smith said...

Quickbooks desktop 2019 provides accounting software to the users where you can connect with quickbooks software from any where with just an internet connection at quickbooks online.if you have any query you can contact with us our support team available 24*7.https://thestandarddaily.com/quickbooks-pro/.

sam smith said...

Quickbooks provides accounting software to the users by which you can resolve your accounting related query data then you can contact with quickbooks support team our contact number is QuickBooks support phone number.

lucy jhonson said...

I am really very happy to visit your blog. Now I am found what I actually want. I check your blog every day and try to learn something from your blog.
Please keep it up to date like this. Thanks for sharing.
McAfee is the ultimate cybersecurity software range that keeps your devices protected round the clock. Although set up for any application is a time consuming and complicated process. However,
McAfee Activate activate setup is much simpler and convenient than expected.

Technical Support said...

I appreciate your efforts, keep sharing with us

Visit: WWW.WEBROOT.COM/SAFE

Technical Support said...

The Trend Micro antivirus auto update feature gives you the freedom to use your computer without any hesitation. Trend micro browser extension on the other hand immediately prevents you from visiting unwanted and malicious websites.

Visit: www.trendmicro.com.au/downloadme

safeactivation said...


Thanks for posting such an interesting post. I truly like it so much.
www.trendmicro.com/bestbuypc

Eleveck said...

Great article odin download for samsung . Thanks

Anonymous said...

I think this performance issue applies for everything, even application like Quickbooks if you are using along with many more applications, every application tend to work and function slowly, I usually use Quickbooks Tool Hub if something happens to my Quickbooks application.

Sumona Tiger said...

Webroot SecureAnywhere antivirus offers you online sacurity with the world's most remarkable cloud security arrangement. It examines fundamentally quicker contrasted with its rivals. It is upheld on every one of the essential stages like Linux, Windows, Mac, and Android gadgets. To get the subtleties to download, introduce and actuate your gadget, visit www.webroot.com/safe.

Cmissy said...

This is informative, if you are a student looking for Nursing Case Study Help Online get intouch

youmagine said...

If you desire to increase your know-how simply keep visiting this site and be updated with the newest news posted here.

사설토토
온라인카지노사이트
파워볼사이트
바카라

chilterntraveller said...

Greetings! This is my first visit to your blog! We are a group of volunteers and starting a new initiative in a community in the same niche. Your blog provided us beneficial information to work on.


토토사이트
카지노사이트
파워볼
바카라사이트

longisland said...

I seriously love your blog.. Excellent colors & theme. Did you build this website yourself? Please reply back as I’m planning to create my own website and would like to find out where you got this from or exactly what the theme is called.

스포츠토토
온라인카지노
파워볼게임
온라인바카라

opbest said...


Hi there mates, how is all, and what you would like to say concerning this
article, in my view its truly awesome in favor of me.

Look at my web-site 휴게텔

(freaky)

افضل شركات نقل عفش واثاث said...

نقل عفش من الخبر الى الرياض
نقل عفش من الرياض الى بيشة
مكافحة الحمام بخميس مشيط
كشف تسربات المطابخ بخميس مشيط
كشف تسربات الحمامات بخميس مشيط
شركة تنظيف خزانات شمال الرياض
نقل عفش بالرياض باكستاني

Daniel Lisa said...

Database server manager can be simply updated by going on the intuit website and clicking on the update. quickbooks database server manager grants QuickBooks clients to design QB servers for multi-user access. Additionally, this software allows users to create company network data files on the host PC.

Krunal said...

foundation spalling repair:Spalling is an especially perilous sort of establishment issue in light of the fact that most property holders don't perceive that it's not the restorative issue it has all the earmarks of being. The actual harm that happens during spalling is somewhat unimportant, however it's an indication of significantly more serious issues that should be tended to right away.

Natasha Bryan said...

When you’re trying to get online and suddenly your Norton VPN not working, it can be frustrating. The good news is that many different issues may be causing this trouble. Fortunately, there are ways to fix the issue and get back up and running in no time.

First thing you should do: Confirm you’re using the right VPN for your device. If not, contact your service provider if they can help or find a different VPN that may work better for you.

If the issue is with your device: Restart it and see if that helps. Sometimes, other apps like task managers like Microsoft Task Manager or RAMdisk can interfere with the Norton VPN app on your computer. Click on “End Task” in these apps to restart them before rebooting your computer again.

Users can contact customer support team. They have customer service representatives that answer questions about product, subscription, payment, and technical support. Additionally, they have live chat support.

Crocs3D said...

Thanks a lot very helpful and interesting content…it’s article very nice… thanks you

CouponPlay said...

This is CouponPlay, a professional blogger I enjoy writing on multiple callings with a firm grip on specialty include digital marketing, affiliate marketing, entertainment, and e-commerce blogs.

Tirthdeo Sikdar said...

Thank you for your information and I love your article.
Hey, When I look at your blog site in Ie, it looks fine
I just wanted to give you a quick heads up! Other then that, superb blog!
তেজপাতার উপকারিতা ও অপকারিতা - Bay Leaves

elijah said...

Excellent and decent post. I found this much informative. I'm impressed by the details that you have on this web site. Thank you for this post. I simply couldn't leave your site just my reading this blog. I am really impressed with the content and way of writing. Keep sharing more.
Divorce law in new jersey
best lawyers in virginia for protective order

19guide03 com said...

You glaringly canot confront anybody about what you have located if the facts isn’t always right.

casinosite zone said...

i sense high-quality approximately it and love studying more on this subject matter.

sportstotozone com said...

that is a incredible inspiring article.

Derek said...

Such performance issues indicate that the plugin is not properly configured. I've encountered this before. I saw one site solved this problem by enabling caching. You can see here: https://payid-casinos.com/how-to-use-payid-bankwest/ - here you can see how the page load speed has improved, its performance is amazing. I believe your post has helped a lot of people. And I hope my post will also help some people rethink their approach to using plugins.

ترند نقل عفش السعودية said...

ارخص ٢٤ شركة نقل عفش بالقطيف نقل اثاث بالقطيف
ارخص ٣٥ شركة نقل عفش بالخبر نقل عفش الخبر
ارخص ٢٥ شركة نقل عفش بالاحساء نقل عفش بالاحساء
دينا نقل عفش بالاحساء 0565200383 دينا نقل اثاث بالاحساء

ترند نقل عفش السعودية said...

شركة نقل عفش بالدمام
شركة نقل عفش بالاحساء
شركة نقل عفش بالقطيف
شركة نقل عفش بالاحساء 0566473790 نقل عفش بالاحساء
شركة نقل عفش بالجبيل
شركة نقل عفش بالخبر
شركة نقل عفش بالمدينة المنورة
شركة نقل عفش بالظهران

tradesman trailers said...

I love this content, thanks for uploading it.