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.
45 comments:
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
Life Coach in Chennai
Blue waffles
Blue waffles disease
Blue waffles pictures
How do you get blue waffles
Blue waffles symptoms, causes, prevention
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
به خاطر داشته باشید که آسانسور قیمت آسانسور ، بازسازی آسانسور و شرکت آسانسور نیز مسائل قابل ملاحظه‌ای است.نگهداری قطعات آسانسور ، شغل نصب آسانسور است. سیستم تهویه مطبوع به خاطر داشته باشید که تهویه مطبوع سامسونگ و شرکت تهویه مطبوع نیز بهترین سیستم تهویه مطبوع و تهویه مطبوع ساختمان می باشد. برق یار برای خدمات برق برای عیب یابی ، تعمیر ، نگهداری یا نصب ، سرویس تاسیسات و کامپیوتر است.
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.
This is really an amazing and thank you so much for sharing
คาสิโนออนไลน์ที่น่าเชื่อถือและมีความเป็นมืออาชีพที่สุดในตอนนี้
โปรโมชั่นGclub ของทางทีมงานตอนนี้แจกฟรีโบนัส 50%
เพียงแค่คุณสมัคร สล็อตออนไลน์ กับทางทีมงานของเราเพียงเท่านั้น
ร่วมมาเป็นส่วนหนึ่งกับเว็บไซต์คาสิโนออนไลน์ของเราได้เลยค่ะ
สมัครสล็อตออนไลน์ >>> Goldenslot
สนใจร่วมสนุกกับ คาสิโนออนไลน์ คลิ๊กได้เลย
มีทั้งคาสิโนออนไลน์ หวยออนไลน์ ฟุตบอลออนไลน์ สล็อตออนไลน์ และอื่นๆอีกมากมาย
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.
great article, I was very impressed about it, wish you would have stayed next share
cool math games fireboy and watergirl
I feel sorry for not knowing this sooner, thank you for sharing with us!
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
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.
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.
Very good write-up. I certainly love this website. Thanks! iMessage on PC
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.
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.
نقل عفش من الدمام الى مكة نقل عفش من الدمام الى مكة
نقل عفش من الرياض الى الدمام نقل عفش من الرياض الى الدمام
نقل عفش من الرياض الى جدة نقل عفش من الرياض الى جدة
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.
promo codes for roblox it is the great experience for you in gaming.
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
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.
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 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
I love to read this information.
thanks
I appreciate your efforts, keep sharing with us
Great Article
android based projects
Java Training in Chennai
FInal Year Project Centers in Chennai
Java Training in Chennai
projects for cse
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/.
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.
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.
I appreciate your efforts, keep sharing with us
Visit: WWW.WEBROOT.COM/SAFE
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
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
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
Fantastic blog post.Much thanks again. Great.
www.malwarebytes.com/install
Norton users can protect their data and private information from etiquette, also because the features are excellent in it.
www.norton.com/setup
very nice, Thanks for sharing the most important information I am so glad to visit this blog.
www.malwarebytes.com/install
The users can update Webroot Internet Security where the requirement of computer gives complete protection, repair for the outdated version of Webroot Antivirus Software.
www.webroot.com/safe
Thanks for posting such an interesting post. I truly like it so much.
www.trendmicro.com/bestbuypc
Great article odin download for samsung . Thanks
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.
Thanks for posting such an interesting post. I truly like it so much.
www.trendmicro.com/bestbuypc
this is very nice blog
my.kaspersky.com
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.
Post a Comment