|why do travel sites make you wait|
I'm always waiting 3-10 seconds for a flight quote
| 9:42 pm on Jan 4, 2010 (gmt 0)|
I wonder if anyone knows if there is a technical reason for sites like expedia, travelocity, etc to use a transition page when requesting quotes on flights?
I figure the answer is either that they are so overwhelmed with queries that the database is always playing catchup, or they are purposely doing this to make it more difficult for 3rd parties to mine data from their sites.
I found a site that says there were about 50k flights/day in 2000. Multiply that by 5 and you still only have 250,000 flights per day. That isn't much to look up and even with connections it shouldn't be an inordinate amount of lookups.
I was looking to travel this summer and trips were pricey where I wanted to go. I tried looking at nearby cities or alternative dates and it seemed to take forever.
Anyway, does anyone know why travel sites make you wait for a result?
| 10:06 pm on Jan 4, 2010 (gmt 0)|
What, you think airfares are stored in a static DB table on the site's servers' hard drives?!? Oh, heh heh, that's a good one!
Airfares (and availability) change constantly and I don't know of any sites that store the data on their servers. Most likely, when you go to a travel site and request an airfare, the site has to make a call through their taps into the airline reservations systems mainframes (or go through a 3rd party interface).
Also, you have to realize that the DB structure is not simple. If you do a search for flights from L.A. to New York, your query is going to return non-stop L.A.-New York flights; 1-stop flights that could go through Las Vegas, Denver, Atlanta, St. Louis, Chicago, etc...; 2-stop flights; plane changes, etc. And that's if you specify which airport to use at each end. What if you specified the flexibility of using Long Beach or John Wayne Airport instead of LAX and Newark or JFK instead of La Guardia?
So after all the possible routes have been determined, the system has to check availability and pricing for each leg along the way.
| 9:00 pm on Jan 12, 2010 (gmt 0)|
A "flight" in the business sense is something different from a "flight" in the operational sense, so the number of the latter (i.e. a plane going from point A to point B) is almost meaningless.
A lot of the complication of airline pricing arises from "revenue management," where airlines use restrictions on tickets (e.g. requiring a Saturday night stay or purchase of a round trip) to segregate price-insensitive passengers from price-sensitive passengers. All airlines and intercity trains and buses do this. A low-cost airline (e.g. Ryanair or Southwest) might sell seats on a plane in a dozen different price "buckets." A traditional network carrier (e.g. Delta or Qantas) might have three times that many. So all the fare rules for all those buckets need to be scanned to ensure that your request meets the restrictions applied to the fare and the fare class.
Add connections, and it becomes more complicated. United may sell you a cheap "L" fare for LAX-ORD if you buy a connection onto a more profitable flight, say ORD-LHR as a "Q" fare. But they wouldn't want to sell the "L" fare to someone who's just going to ORD, lest that passenger take a seat away from the more profitable passenger, so they'll hold out for a while and only offer a more expensive, say, "K" fare. So if you just list out the available fares, you'll see the cheapo, but you won't see inventory for it without the connection.
These buckets are changing constantly, as the pricing triggers in the mainframe fireó sell 20 "H" and 10 "W," but if you sell 10 "H" tickets at once then reduce "W" inventory to 5 and up remaining "H" inventory to "15," unless it's a holiday weekend in a month that ends in "R," etc.
And, of course, you're not just looking at one day. Flights are sold up to 330 days in advance, and especially when you're looking for the lowest-cost option, you're searching a lot of extra permutations of departure dates and times.
| 6:06 pm on Jan 17, 2010 (gmt 0)|
I think many of the services are pulling the data/pricing real-time from the various airlines, which adds some lag to the response.
Just my guess.
| 9:23 pm on Jan 17, 2010 (gmt 0)|
i used to work for a travel company and they had to pull the availability and prices from the airlines for each individual quote. airlines charge travel companies different rates for the seats depending on how many are remaining on the flight -- even if they are all in the same class. so economy seats might have ten different prices. and travel companies can't know know how many seats are remaining on each flight until they ask the airline. so even if the travel company keeps the price the same to the customer, they still have to get the changing info from the airline so they know how much they are paying.
and when you think that a page might contain flight quotes for 5 different airlines, that adds up to a lot of waiting