Running Querries during the day



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.



Glenn Adams [MVP - Retail Mgmt]

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
(e-mail address removed)

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. After that, you can post your question and our members will help you out.

Ask a Question