Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
 
  • Locked thread
Mo_Steel
Mar 7, 2008

Let's Clock Into The Sunset Together

Fun Shoe
Does it matter when you run the query for a barcode value (i.e. during peak business hours vs. after hours)? Is there a high amount of I/O activity going on, or is the drive array nearing capacity? Does it matter how you enter the query (i.e. instead of scanning a barcode at the POS is it also slow if you directly query the database from the server)?

Adbot
ADBOT LOVES YOU

Mo_Steel
Mar 7, 2008

Let's Clock Into The Sunset Together

Fun Shoe
After ruling out hardware bottlenecks, software settings or database issues would be where I'd look next as well; not sure how old the version you're running is or how much data you've got, but is there a software limit on the size of the database?

  • Locked thread