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.
43 comments:
Life Coach in Chennai
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
This is really an amazing and thank you so much for sharing
คาสิโนออนไลน์ที่น่าเชื่อถือและมีความเป็นมืออาชีพที่สุดในตอนนี้
โปรโมชั่นGclub ของทางทีมงานตอนนี้แจกฟรีโบนัส 50%
เพียงแค่คุณสมัคร สล็อตออนไลน์ กับทางทีมงานของเราเพียงเท่านั้น
ร่วมมาเป็นส่วนหนึ่งกับเว็บไซต์คาสิโนออนไลน์ของเราได้เลยค่ะ
สมัครสล็อตออนไลน์ >>> Goldenslot
สนใจร่วมสนุกกับ คาสิโนออนไลน์ คลิ๊กได้เลย
มีทั้งคาสิโนออนไลน์ หวยออนไลน์ ฟุตบอลออนไลน์ สล็อตออนไลน์ และอื่นๆอีกมากมาย
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
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
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
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
Thanks for posting such an interesting post. I truly like it so much.
www.trendmicro.com/bestbuypc
Great article odin download for samsung . Thanks
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.
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.
This is informative, if you are a student looking for Nursing Case Study Help Online get intouch
If you desire to increase your know-how simply keep visiting this site and be updated with the newest news posted here.
사설토토
온라인카지노사이트
파워볼사이트
바카라
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.
토토사이트
카지노사이트
파워볼
바카라사이트
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.
스포츠토토
온라인카지노
파워볼게임
온라인바카라
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)
نقل عفش من الخبر الى الرياض
نقل عفش من الرياض الى بيشة
مكافحة الحمام بخميس مشيط
كشف تسربات المطابخ بخميس مشيط
كشف تسربات الحمامات بخميس مشيط
شركة تنظيف خزانات شمال الرياض
نقل عفش بالرياض باكستاني
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.
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.
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.
Thanks a lot very helpful and interesting content…it’s article very nice… thanks you
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.
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
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
You glaringly canot confront anybody about what you have located if the facts isn’t always right.
i sense high-quality approximately it and love studying more on this subject matter.
that is a incredible inspiring article.
Post a Comment