Basic query speed question

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Basic query speed question

    When I write a SQL call in TOAD, it takes lapprox 4 seconds to run.. but when I put it in my CF page, it takes over 20 minutes.
    That shouldn't be, should it?
    cobramichelle Guest

  2. Similar Questions and Discussions

    1. basic query question
      Not sure if i am asking this the right way but - Can anyone tell me what the symbol is for 'contains' instead of 'equals' ?. i.e SELECT *...
    2. What looks like a basic SQL query still not resolved
      ARRRRRRRGGGGGHHHHH!! Please can you help, I'm going round the bend with this. I have a simple and small table called STOCKCATS, which I need to...
    3. MS Access Query Speed
      I have two servers sharing a small MS-Access DB. Initially, one was running Server 2003 and CF 6.1, with the other running WinNT and CF4.5. The...
    4. speed question
      is it quicker to create buttons on the fly or use actual images. for rollovers as well.
    5. speed question - ftp vs http???
      I am writing a component to communicate and pass data between 2 servers. I have done some testing using api/ftp functions and using msxml/asp. ...
  3. #2

    Default Re: Basic query speed question

    No it shouldn't be. Even 4 seconds is kinda slow.
    Dan Bracuk Guest

Posting Permissions

  • You may not post new threads
  • You may 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