Slow Performance

[John H. Miller]

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

[Ray]

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

[Byron Gale]

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

[wtodd]

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;

[Jochem van Dieten - TMM]

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.

[GGRam]

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!