Join DiveBuddy.com

Meet new scuba divers, maintain a virtual dive log, participate in our forum, share underwater photos, research dive sites and more. Members login here.

Scuba Forum
 
#51831
 DiveBuddy Speed Improved
Greg - 12/02/2012 9:19 AM
Category: Web Site Help
Replies: 9
As if DiveBuddy wasn’t fast enough, you will be happy to know I worked on a few scripts over the weekend that improved the database query performance. Quite a few of the scripts on DiveBuddy are either really complicated OR run very often, I concentrated on improving these scripts.

For example, the script to show Related Content at the bottom of most pages is pretty complicated. It requires joining together several database tables and searching through a lot of records. I worked my magic and was able to reduce the avg. time this query took to run from about .55 seconds to around .175 seconds. This was just one of a few scripts I improved.



I hope you enjoy DiveBuddy. As always, please let me know if you experience problems with the site OR have questions/suggestions.
#12205
Eric_R - 12/02/2012 3:02 PM
That’s awesome Greg. That’s a huge reduction! I’m working on some inventory scripts for my work. What a pain in the php.LOL
#5828
Agojo - 12/02/2012 4:55 PM
And I just assumed it was a little slow because of my Philippines internet connection. Actually I never noticed and am just happy you started divebudddy. I have meet some wonderful friends and divebuddies from this website. THNAK YOU!
#51831
Subscribed
Greg - 12/02/2012 6:38 PM
I don’t want my code to be why the site is ever slow. If it is, it’s either my web hosting company or the internet connection. I may one day upgrade my server plan at GoDaddy also to make it even better.
#8049
Rich-D-Fish - 12/03/2012 8:35 AM
I have no idea what language you speak here....but it sounds like it must have come over to my screen faster somehow ;-) Thanks for all your hard work!
#51831
Subscribed
Greg - 12/03/2012 8:59 AM
From Rich-D-Fish: I have no idea what language you speak here....but it sounds like it must have come over to my screen faster somehow ;-) Thanks for all your hard work!...
Yes, it ultimately will make things "come over to your screen faster". Anything I can improve on the back-end will allow the web server and database to serve up content faster.
#2970
SaintsReturn - 12/03/2012 5:15 PM
Thank you!!!!
#51831
Subscribed
Greg - 12/03/2012 5:54 PM
I also just removed/uninstalled an online backup solution I was using, Carbonite. It was draining resources even outside the backup schedule I set. At times, it was consuming so much I/O on the hard drive that everything was running very slow. I’m trying CrashPlan.com now. It has more functionality and lets me set the max resources to use and when to run. We’ll see how it works out.
#20326
Smithsgold - 12/04/2012 12:18 PM
Cool !!!!
#51831
Subscribed
Greg - 5/19/2013 9:18 PM
I improved DiveBuddy speed even more. I figured out that you do not need to use DataBinder.Eval() in ASP.Net when showing records from a result set. You only need to use Container.DataItem(), which improves rendering the page by about 20%. Eval is only needed if you want .Net to automatically determine the datatype. But I’m not doing anything on DiveBuddy that requires this when showing data from a result set so I updated all my pages today.