Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2006
    Posts
    7

    Question Unanswered: Which is better: One large query, or Many small queries?

    Hey guys and gals,

    In general, if you are working with a lot of calculated fields, is it better to set up a "master" query, and pull from it, or set up smaller, separate queries to accomodate each report or field you tie to it? I figure it costs more in processing time and memory to use one master query, but if you're using, for example, DLookup to snag one value, does it even matter?

    I find it easier to keep track of fewer large queries, but I'm afraid it makes my database less efficient.

    Thoughts?

  2. #2
    Join Date
    Nov 2004
    Location
    Harrogate, N.Yorks, UK
    Posts
    83
    My personal preference is many small ones as it is easier to spot/check that the data being returned is what you expect at key points. The more complex the query the less obvious any errors in the final result will be. As far as performance issues go, I've not really had any problems but that would depend on how much data you are working with at any one time.

Posting Permissions

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