I know this issue has probably been talked about in the past, but I'm new to
the list... I'm certainly NOT new to CF, been doing it for quite some time
(over 5 years), but haven't played much with administration, just coding.
I have a small performance issue that has only recently begun to be
bothersome. I'm running CF 4.5.1 on NT4 in IIS 4 using SQL Server 7.0.
The CF and IIS are on a dual PIII 450, 512MB RAM system and the SQL Server
is on a DUAL PIII Xeon, 1 GIG RAM and the two are connected via a 100
megabit network connection.
I have a simple database with 1400 records in it, all properly indexed... I
run the following query in Enterprise Manager of SQL Server and it takes
mere milliseconds... I run it through CF and it takes 1 minute 40 seconds.
The data I'm looking at for this query has 1400 records...
Ok, so first thing people will tell me is to retrieve a smaller set of
records... well SQL Server is certainly capable of holding this much (and a
whole lot more) data, and using it quite efficiently. A C++ program we have
running on client machines accessing the same set of data take mere seconds
to load. There is no additional processing being done on the page, just
merely calling the CFQUERY...
The OLEDB connection would be one optimization, but as I was reading through
the OLEDB docs there seems to be major issues with missing functionality.
Plus the messages in Allaire's own forums gives the impression that OLEDB is
not quite up to snuff...
So where should I be looking for performance tweaks?
Oh, here's the query:
<CFQUERY NAME="qEmps" DATASOURCE="#DSN_Name#" USERNAME="#DSN_Username#"
PASSWORD="#DSN_Password#">
SELECT IDNumber, FirstName, LastName
FROM dcp_Employees
ORDER BY FirstName
</CFQUERY>
Thanx!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
