Professional Web Applications Themes

Slow Performance - Coldfusion Database Access

I'm having difficulty with the browsing function in elements 2. It will work fine for a while and then slow my computer dramatically. I have a 1gig pentium processor ,512meg. of ram and am running windows 98second addition. Quite often I will end up with disk errors that have to be corrected with my scan disk function. Any ideas? Thanks. John Miller...

  1. #1

    Default Slow performance

    I'm having difficulty with the browsing function in elements 2. It will work fine for a while and then slow my computer dramatically. I have a 1gig pentium processor ,512meg. of ram and am running windows 98second addition. Quite often I will end up with disk errors that have to be corrected with my scan disk function. Any ideas?
    Thanks.
    John Miller
    John H. Miller Guest

  2. #2

    Default Re: Slow performance

    John,

    I've had this problem before. I had a folder which contained like 4000
    pictures. I split it, and the problem vanished. Also, if your files are
    big (TIFF of 40Mb +, for example), try to split the folder as well.

    Ray


    Ray Guest

  3. #3

    Default Re: Slow performance

    I have found that the single, most effective thing I can do to keep PSE running as snappily as possible is to close the File Browser when I'm not using it.

    Even though I don't have any huge (in my estimation) folders full of images, performance benefits from only having File Browser open when I need it.

    Byron
    Byron Gale Guest

  4. #4

    Default Slow Performance

    PLEASE HELP ME. It takes about 21 seconds to bring up a form which has 24
    input fields (7 of which are drop down fields that brings up selection items
    from the access database such as mfg, vendor, bldg #, etc.). The access
    database is not big at all.

    I'm running CFMX 6.1 on a stand alone W2K Server and connecting to MS Access
    2000 database, which is also on the server. I added my datasource from the
    CFMX Administrator with Access as my datasource and everything checked fine. I
    have 7 drop down fields on my form such what you see below: Can someone help
    me with this incredibly slow performance. By the way my server has plenty of
    space and ram.

    <cfquery name=?mfg_name? datasource=?eeeproj?>
    SELECT distinct manufacturer
    FROM JWST_Table
    ORDER BY manufacturer
    </cfquery>

    <SELECT NAME = ?manufacturer?>
    <OPTION SELECTED VALUE = ??> <CFOUTPUT QUERY=?mfg_name?>
    <OPTION VALUE = ?#manufacturer#?>#manufacturer#
    </cfoutput>
    </select>
    :confused;

    wtodd Guest

  5. #5

    Default Re: Slow Performance

    wtodd wrote:
    > PLEASE HELP ME. It takes about 21 seconds to bring up a form which has 24
    > input fields (7 of which are drop down fields that brings up selection items
    > from the access database such as mfg, vendor, bldg #, etc.). The access
    > database is not big at all.
    Enable debuggng so you can identify the slow query. Then we can
    focus on optimizing that one.

    Jochem

    --
    Jochem van Dieten
    Team Macromedia Volunteer for ColdFusion, beer and fun.
    Jochem van Dieten - TMM Guest

  6. #6

    Default Re: Slow Performance

    Something else to look into is the number of tdifferent queries you are
    running. If the data for all 7 drop down lists resides in the JSWT_Table and
    you have 7 separate queries then your form is taking 7 times longer than
    necessary to load (accessing the hard drive, which happens wehn reading from
    and Access database, is always the slowest part of any process). Define one
    query to retreive all the data then use the CFOUTPUT 7 times for each drop
    down list. If the sorted order is an issue then store the list values in 7
    different arrays, use the arraysort function on each and then loop over the
    arrays to load the values into the drop downs.

    Good luck!

    GGRam Guest

Similar Threads

  1. Slow performance from Word X
    By Bill_Detty@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 2
    Last Post: August 11th, 07:44 PM
  2. Slow system 10 performance
    By Larry_Platt@adobeforums.com in forum Adobe Illustrator Macintosh
    Replies: 9
    Last Post: May 7th, 01:44 PM
  3. Fireworks MX performance very slow under XP
    By gruuvebot webforumsuser@macromedia.com in forum Macromedia Fireworks
    Replies: 14
    Last Post: September 22nd, 01:17 PM
  4. Dog, Dog slow performance
    By judith moser in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 6
    Last Post: August 17th, 12:48 PM
  5. Dog slow performance?
    By Chris Cox in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 0
    Last Post: August 5th, 11:15 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