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.


Mharish 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. - packers and movers marathahalli

JANA GANGA said...

Life Coach in Chennai

Anonymous said...

Blue waffles
Blue waffles disease
Blue waffles pictures
How do you get blue waffles
Blue waffles symptoms, causes, prevention

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


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

برق یار said...

به خاطر داشته باشید که آسانسور قیمت آسانسور ، بازسازی آسانسور و شرکت آسانسور نیز مسائل قابل ملاحظه‌ای است.نگهداری قطعات آسانسور ، شغل نصب آسانسور است. سیستم تهویه مطبوع به خاطر داشته باشید که تهویه مطبوع سامسونگ و شرکت تهویه مطبوع نیز بهترین سیستم تهویه مطبوع و تهویه مطبوع ساختمان می باشد. برق یار برای خدمات برق برای عیب یابی ، تعمیر ، نگهداری یا نصب ، سرویس تاسیسات و کامپیوتر است.

meldaresearchusa said...

Our research paper service writers have been 14 years experience in the field where they have assisted thousands of returning clients in attaining high scores.

Madoo said...

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

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

Puremelda said...

We understand that students in Australia encounter different challenges in completing their Best Custom Essay Writing Service. We offer Best Online Paper Writing Service to students regardless of their specialty, discipline or educational level.

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

Legitimate Custom Research Paper Services said...

The backbone of Term Paper Writing Services company is its writers and ours are the choicest in the industry to ensure that clients acquire the Best Term Paper Services and that will make you collect a high-quality Custom Term Paper Writing Help.

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

Best Packers and Movers in Delhi | Best Packers and Movers in India said...

Your blog is awesome, all contents are really unique. thanks for sharing with us.Looking for some help from Packers And Movers in Dwarka, for shift your home or office then contact Zodiac Packers Movers.

jack miller said...

DMG files are like ISO file.DMG files are Mac-specific files and are not for use in windows. You are not able to run this file on Windows due to the Operating system compatibility issues. And, more than that you cannot open directly DMG file. In windows, you can use FreeViewer DMG Tool viewer to view different files of DMG on the windows platform. For more information, visit dmg file opener windows 7.

Unknown said...

نقل عفش من الدمام الى مكة نقل عفش من الدمام الى مكة
نقل عفش من الرياض الى الدمام نقل عفش من الرياض الى الدمام

نقل عفش من الرياض الى جدة نقل عفش من الرياض الى جدة

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.

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
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.

pdf file said...

I appreciate your efforts, keep sharing with us

mary Brown said...

Great Article
android based projects

Java Training in Chennai

FInal Year Project Centers in Chennai

Java Training in Chennai

projects for cse

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.

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


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.


safeactivation said...

AOL Desktop Gold is that the easy to use, all-in-one desktop you recognize and love with mail, browsing, search, content and now includes: Premium security measures to assist prevent your AOL account from being compromised and hacked.
aol desktop gold download

safeactivation said...

If you've got scanned your computer and verified it for malware and viruses, and located nothing, then it'll be safe to show off your Antivirus and Firewall for a short time until you discover what's wrong together with your software.
Aol Desktop Gold Download

safeactivation said...

Fantastic blog post.Much thanks again. Great.

safeactivation said...

Norton users can protect their data and private information from etiquette, also because the features are excellent in it.

safeactivation said...

very nice, Thanks for sharing the most important information I am so glad to visit this blog.

safeactivation said...

The users can update Webroot Internet Security where the requirement of computer gives complete protection, repair for the outdated version of Webroot Antivirus Software.

safeactivation said...

Thanks for posting such an interesting post. I truly like it so much.

Eleveck said...

Great article odin download for samsung . Thanks

ross taylor said...

While working on QuickBooks accounting software user can face some errors which obstructs users from working smoothly. On of them error a you can solve is QuickBooks Error 15241.

Security Software said...

Thanks for posting such an interesting post. I truly like it so much.

Security Software said...

this is very nice blog

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.

sam hatter said...

Open your gadget's application store and track down the "Prime Video" application.
Presently click on download and introduce the application in your gadget.
Open the "Prime Video" application and snap on "Register on the Amazon site".
Go to on an internet browser of your gadget.
Enter your activation code.
Enjoy Prime Video.

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

Cmissy said...

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

An AOL mail service that is free, an AOL login is an email service that is web-based. So you can access a free AOL email, all that is needed is a mobile device or a computer with a web browser program such as Mozilla Firefox, Internet Explorer, or Google Chrome, and an internet connection.

aol login
aol mail login
aol mail login problems

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.


Packers and Movers Bangalore said...

Packers and Movers Bangalore - Reliable and Verified Household Shifting Service Providers Give Reasonable ###Packers and Movers Charges. Cheap and Best Office Relocation Compare Quotation for Assurance for Local and Domestic House Shifting and Get estimates today to save upto 20%, ***Read Customer Reviews - @ Packers And Movers Bangalore

Couponsva said...

This is Couponsva, 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.

Packers And Movers Gurgaon said...

Really impressive post. I read it whole and going to share it with my social circules. I enjoyed your article and planning to rewrite it on my own blog Packers And Movers Gurgaon

Packers And Movers Delhi said...

Get Shifting/Relocation Quotation from ###Packers and Movers Delhi. Packers and Movers Delhi 100% Affordable and Reliable ***Household Shifting Services. Compare Transportation Charges and Save Time, Verified and Trusted Packers and Movers in Delhi, Cheap and Safe Local, Domestic House Shifting @ Packers And Movers Delhi

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 휴게텔


fgthtyhsrty said...

yeezy shoes
100% real jordans for cheap
supreme clothing
golden goose sneakers
kobe 9
kobe basketball shoes
golden goose sneakers
air jordan
supreme clothing

esfahanjanebi said...

لوازم جانبی
لوازم جانبی موبایل

Packers and Movers Hyderabad said...

Packers and Movers Hyderabad Give Certified and Verified Service Providers, Cheap and Best ###Office Relocation Charges, ***Home Shifting, ✔✔✔Goods Insurance worth Rs. 10,000, Assurance for Local and Domestic House Shifting. Safe and Reliable Household Shifting Services in Hyderabad with Reasonable Packers and Movers Price Quotation @ Packers And Movers Hyderabad

jasonbob said...

kyrie 7
giannis shoes
hermes online
nike sb dunks
hermes belt
pg 1
yeezy boost 350
kobe shoes
golden goose outlet
off white outlet

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

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

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

شركة نقل عفش ببريدة
شركة نقل عفش بتبوك
شركة نقل عفش بالظهران
شركة نقل عفش برابغ
شركة نقل عفش بالباحه
شركة نقل عفش بعسير
شركة نقل عفش بالمجمعة

افضل شركات نقل عفش واثاث 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.

Carol Roberts said...

We specialise providing eCommerce Websites, wordpress development houston & Magento Development, eCommerce Website Design, Local SEO Houston & Digital Marketing Houston Services.

liam neeson said...

What makes Prolific Ghostwriting the best? We're professional, experienced and have a team of the best ghostwriters of the industry.

Zonas said...

The pros and cons of period underwear are as follows, They are reusable and have a minimal environmental impact. They can hold a couple of tampons full of blood. The fuller briefs are great for overnight protection. Cons: They require 24-48 hours of the drying time! You need a few pairs to get you through your cycle. They're not as environmentally friendly as a menstrual cup.

prolific said...

Prolific Studio is where we combine our many years of cinematic knowledge, talented studio team and top-notch animation to bring your stories to life. Our animation production company can't wait for you to see what we’ve done!

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.

Riyano said...

Anonymous said...

에볼루션접속 먹튀검증 안전노리터 go