Wednesday, July 8, 2009

DNS Lookups Cause Site Slowness

As per the usual, I've been tinkering with the back-end from time to time. Things slowly and silently improve -- well, hopefully!

Right now I'm at the University of Kentucky participating in an intensive conversational Latin seminar. Intense is the appropriate word. Today is day 2 of the seminar itself, although I've been here since the 4th of July. We'll see how my Latin improves after 10 days of immersion.

Since I've been here at UKY I found a bug -- well, a performance issue. Some Universities (like this one) don't put individual host names in DNS for their various thousands of connections. UNM happens to be one that does. Normally, my web server is set to perform a DNS lookup on every single connection (inefficient, I know). For a normal internet connection (say, a UNM student or a home Comcast user), that lookup takes microseconds. In the case of UKY, that lookup took 6 seconds ... to timeout. That timeout happened every single time the browser connected. Needless to say, this site must seem incredibly slow at a University like this. I can verify that it did for the short time it was affecting me.

So, to all the UKY students out there ... I apologize for the slowness. I also apologize to all the users of this site who experienced the ... shall we call it a mismatched configuration? On a pleasant note, this was a truly easy situation to resolve. One # (hash) sign in the config file and all is well. C'est la vie? Oui. Or in Latin, perhaps Re vera est? Ita.

Incidentally, I clean up words on the back-end on a regular basis. Since I've been intensely studying here, I've been catching a few more errors than usual!

I also had a suggestion to incorporate the full Lewis and Short dictionary into this site. Great idea! I'm looking into it now.

Labels: , , , ,


Wednesday, December 24, 2008

New Server and Speed Increases

It's finally here and up and running!

I bought a new server. Did you know you can get slightly older computers, but still really powerful, for super cheap? People and businesses upgrade and then basically give their computers to discounters for nothing! I got this server for $144, with tax, shipping and an extra year's warranty. I'm very impressed.

Also, U.N.M (University of New Mexico) gave me a static IP address on their network, so we have a super-fast internet connection.

So, if you're used to this site being slow, get ready for serious changes! In general, moving to this new server on this new internet connection has increased the speed by an order of magnitude (from 300ms per request to 15ms per request). Wow!

But that's not all folks! I've also done some back-end coding to cache the results of morphology lookups. So now morphology lookups should increase by another order of magnitude (as long as a word is cached). If the word is not cached, the lookup will still be 2-3 times faster.

I apologize for geeking out a bit here, but I hope you notice the speed improvements.

As usual, I'm always developing The Latin Lexicon, but since I'm on winter break, expect to see some serious improvements for January!

Oh, one more thing. I also set up some bug-tracking software (BugZilla) to keep track of issues and improvements. So if you find all this technical stuff interesting, feel free to check it out!

Ok, one more thing! OpenID logins will be down for a day or two. Also, if you created an account or any flashcards between the 16th of December and today, I'm afraid that information is lost because I upgraded the database on the 16th and didn't get it moved until today. Sorry about that, if you're affected. 

Happy holidays! Happy Hannakwanzaamas!

Labels: , , , , , , ,


Thursday, November 6, 2008

Current Grant Status

I recently got a rejection letter concerning a grant for a new computer.

But it's not all bad news. I have a backup plan. I can get a slightly older, slightly slower computer from an online source (all told about $150) or from UNM Surplus (if I can figure out all the paperwork and if there are any machines available).

Other updates: I haven't done much back-end work recently, but I have been correcting entries as I find them. So! Work continues at a slower pace. Normally I do get most updates done during holidays, so expect to see large-scale changes in late December and early January!

Vale.

Labels: , ,


Wednesday, August 6, 2008

Prettying up the Joint

So I haven't had as much free time as I wanted this week. I've been busy at my day job getting everything "taken care of" before my last day there on August 13th. After that, I'll just be contracting with them for 5 hours a week, because I'll be a full time teaching and grading assistant for the University of New Mexico Foreign Languages and Literatures Department. I'm pretty excited about that!

Nevertheless, I had a few hours free tonight, so I did some sprucing up. I made some icons, fixed some style sheets and squashed some small bugs. There are a few things I want to include before the semester starts:
  • Add a few pronoun paradigms: is and iste for sure.
  • Add some verb paradigms: perhaps volo verbs.
  • Fix up the database backend, especially in the realm of update cascades (it's technical, and you're probably wondering what that means -- don't worry, it'll make things better).
  • Speed up the morphology lookup. It's not slow by any means, coming in at approximately 100 milliseconds per word. But still, I think I can get it down to 40ms. Every bit helps, especially if this site ever gets popular!
  • Make a new database and web server. Right now it's being graciously hosted at the place I work here on campus (Natural Heritage New Mexico). I've been the system admin there for about 5 years, but now -- as I wrote earlier in this post -- I won't be there for very much longer.
I'm sure there's more to update, but I think it's time to take a break for the evening. Enjoy!

Labels: , , , , , , , , ,