Running Querries during the day

Discussion in 'Microsoft Point Of Sale' started by Kris, Mar 28, 2007.

  1. Kris

    Kris Guest

    Is there any harm in running querries in Administrator during the day while
    POS is in use? I've always assumed we shouldn't do it, but just wondered if
    it might be safe. I always backup first.
     
    Kris, Mar 28, 2007
    #1
    1. Advertisements

  2. It depends on the query in too many ways for me to even begin listing...
    The main danger is locking. You can write select queries so that they
    don't lock anything - in that case you're safe, except for the memory
    and CPU cycles that your query takes to execute. Every query has a
    cost. If you have high transaction counts in your location, even a
    'safe' query may reduce performance while it runs. Any query you run
    that locks tables or rows has the potential to cause a 'deadlock' - you
    do not want a deadlock...

    Generally Selects are safe if your database server has power to spare;
    Inserts, Updates and Deletes are never safe.

    Glenn Adams
    Tiber Creek Consulting
    http://www.tibercreek.com
     
    Glenn Adams [MVP - Retail Mgmt], Mar 28, 2007
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.