Professional Web Applications Themes

Joins or subqueries - Coldfusion Database Access

Lately I have been using a lot of subqueries to get at information from different tables in my databases. I do this by cfincluding a cfm within the cfoutput query of the primary query. I'm wondering if I should be using joins instead. Does it matter? Lately our server performance has been greatly compromised by something and we are trying to figure it out. Indeed, we are getting many more users, so I am wondering if subqueries have their limits. What are they? We are currently using MS Access (we will move to SQL Server soon). Any advice is welcome. ...

  1. #1

    Default Joins or subqueries

    Lately I have been using a lot of subqueries to get at information from
    different tables in my databases. I do this by cfincluding a cfm within the
    cfoutput query of the primary query. I'm wondering if I should be using joins
    instead. Does it matter?

    Lately our server performance has been greatly compromised by something and we
    are trying to figure it out. Indeed, we are getting many more users, so I am
    wondering if subqueries have their limits. What are they? We are currently
    using MS Access (we will move to SQL Server soon).

    Any advice is welcome.

    thanks.
    alex



    alexford Guest

  2. #2

    Default Re: Joins or subqueries

    This is a duplicate post. It has been answered at least once in the cfml general forum.
    Dan Bracuk Guest

Similar Threads

  1. #39146 [NEW]: Named placeholder is not bound correctly with Subqueries
    By php at mailingslists dot birkholz dot biz in forum PHP Bugs
    Replies: 1
    Last Post: October 15th, 04:46 PM
  2. Using COALESCE for subqueries
    By marty3d in forum MySQL
    Replies: 1
    Last Post: June 15th, 09:02 PM
  3. subqueries in query of queries
    By helenmhudson in forum Coldfusion Database Access
    Replies: 2
    Last Post: March 7th, 04:25 PM
  4. DBI and subqueries in mysql 4.1
    By Marc Lambrichs in forum PERL Modules
    Replies: 2
    Last Post: December 13th, 08:03 PM
  5. Why are subqueries recongized as dependencies
    By Chris Becker in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 8th, 07:40 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139