Click to go back to front page
Advertisement:

Advertise at Driver Database

Behind the scenes

News, updates, bugs, tired ramblings, small breakdowns and other stuff related to maintaining, adding and expanding Driver Database.

Introducing bugs and putting out the fires

Tuesday, May 13 2008

Weird things have been going on lately. A couple of days ago Driver Database started going extremely slow. It could take up to 15 seconds to load certain pages, and that’s at least 13 seconds too long. Being on a rather tight server budget I started freaking out a bit that the server was taking more load than it could handle. The first thing, before panicing on how to afford a faster server, was to try and figure out where in the code things were going slowly. I soon figured it out and managed to make a work-around a certain area of the code and managed to cut 10 seconds right off. I then managed to optimize some SQL queries to the database and found a couple of more seconds. It’s now back to a more acceptable speed, it’s still a bit on the slow side, but we’ll have to live with that for a while.

I did however introduce a bug when I optimized the database queries, thankfully I had a couple of mails in the mailbox today to point it out. For some reason all Racing and Karting hihglights on the driver’s profile pages claimed "Third position" in everything. It was a quick fix and it is now back to normal.

I was also made aware that there was something wrong with the "Future stars" list. Not all drivers who should be there were showing up. I had a long good look in the code and found out that in some rare cases some rows in the database related to karting were interfereing with the results. This resulted in that not all wins some drivers had were counted. That error’s now been fixed and there now is a new and improved list.

Driver Database should now look much saner in the Opera web browser as well, by the way.

Thanks to all who spotted the errors and let me know about them. :)


Comments:

Dirk (2008-05-21 12:31:39)
your welcome :P


» Comment on this post

» Back to the blog’s front page

Members

Email address:

Password



You need to be logged in to submit or edit new information and to send in photos. The signup process is quick, free and rather painless.

Sign up now

Partners and sponsors

 
 
 
 
 
» Used Car
» New Car
» Used Cars
» Used BMW
» Used Ford
» Used Vauxhall
» Used VW
» Car Finance
» Car Loans
» New Jaguar Cars
» Used cars US
» Car Insurance

The running and continueous updating of Driver Database would not be possible without these sponsors. If you would like to display your brand at this site then the following link would be your first stop:

» Become a DriverDB sponsor

Top 2008 race winners

1Craig Baird29
2Kyle Busch18
3Gabriel Chaves15
Frédéric Vervisch15
5Wayne Boyd14
Nigel Moore14
7Earl Bamber13
Jan Magnussen13
9Valtteri Bottas12
10Gary Findlay11
11Devin Jones10
Jonathan Adam10
Dino Zamparelli10
Kevin Magnussen10
15Andrew Mill9
Ben Winrow9
Eddie Nakato9
Toon Rutgers9
Vito De Pasquale9
Jeff Westphal9
This list also includes series that span over the new year (i.e. 2007-08 championships).


Driverdb.com blog

News, updates, bugs, tired ramblings, small breakdowns and other stuff related to maintaining, adding and expanding Driver Database.

A small change to the driver galleries
September 3 2008
I just made a small change to the driver galleries on the driver profiles. It now shows how many photos there are in the gallery. If there are no photos the "Gallery" link is disabled and very much unclickable (well, you can still click on it if you really want to, but it won't take you anywhere). ...

» Read more

       
 Nick Heidfeld Andreas Wirth Lorenzo Cristini Paul Di Resta Philip Major Michael Herck 
 
Page generated in 8.9985 seconds