Upstairs there's some rather annoying people in control of a database. I need information from that database. It took me all week to get them to even allow me to use some program they wrote to query the database for information.
I don't know if it's the querying app they wrote, or the database itself, but it's taking alomst 5 seconds per value to retrieve some really simple information (I give it a location, it gets me 3 numbers for that location).
Anyway, I made a script to process lists of locations. I tested it with 100 locations (there's 331 total in the database). It took 13 minutes to get 300 values....
jesus christ it's slow. I know they're gonig to blame my script... I tested, my script was sitting there idly by waiting for the damn database software to fetch values....
I'm supposed to update all 331 values every 15 minutes. It's jsut too slow....
I don't know if it's the querying app they wrote, or the database itself, but it's taking alomst 5 seconds per value to retrieve some really simple information (I give it a location, it gets me 3 numbers for that location).
Anyway, I made a script to process lists of locations. I tested it with 100 locations (there's 331 total in the database). It took 13 minutes to get 300 values....
jesus christ it's slow. I know they're gonig to blame my script... I tested, my script was sitting there idly by waiting for the damn database software to fetch values....
I'm supposed to update all 331 values every 15 minutes. It's jsut too slow....
Facebook
Twitter