Results 1 to 12 of 12

Running a bunch of query on MS SQL database

Threaded View

  1. #1
    Forum Contributor VAer's Avatar
    Join Date
    09-10-2016
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    803

    Running a bunch of query on MS SQL database

    I have created a VBA loop, and SQL statement is inside the loop. The code runs fine, no issue at all. So this is for workplace task, I have permission to use the data (as I can run query on the database).

    But my question: What would IT admin (or database Admin) think of an employee running thousands of query on the database within 20 minutes? Does it matter? Is it a normal thing for employee to do? Do they think the action as some kinds of "database attack"? Or I should intentionally place a few seconds pause before running next query? If I add 3 seconds to each query and there is 1000 query, then it adds additional 3000 seconds (50 minutes) of running time, not a good option too.
    Last edited by VAer; 11-06-2024 at 09:15 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] What's difference between a database query and a database table query?
    By sumdumgai in forum Excel General
    Replies: 5
    Last Post: 09-27-2012, 05:30 PM
  2. Database Query-possible to link a spreadsheet to a database
    By COYF in forum Access Tables & Databases
    Replies: 1
    Last Post: 03-04-2010, 09:37 AM
  3. Running a database query with contents of cell
    By davidrough in forum Excel General
    Replies: 4
    Last Post: 11-16-2009, 01:16 PM
  4. Replies: 3
    Last Post: 08-14-2006, 05:10 PM
  5. Excel query of Access database - changed database filename, now error
    By ucdcrush@gmail.com in forum Excel General
    Replies: 2
    Last Post: 03-08-2006, 04:45 PM
  6. Database Query-a query that reads data from MS Access
    By Osmar Mateus in forum Excel General
    Replies: 4
    Last Post: 01-29-2006, 04:10 PM
  7. Replies: 4
    Last Post: 11-29-2005, 09:44 AM
  8. Type Mismatch when running query on SQL Database
    By Neily in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-08-2005, 11:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1